def jsonTeacherCrud(request): # Display/Filter is only on GET if request.is_ajax() and request.method == 'GET': id = request.GET.get('id', None) action = request.GET.get('action', None) if (action == "filter"): dictData = Teacher.objects.filter(id=id).values() else: dictData = Teacher.objects.all().values() #print dictData jsonData = json.dumps(list(dictData)) return HttpResponse(jsonData, content_type='application/json') # CRUD is only on POST if request.is_ajax() and request.method == 'POST': action = request.POST.get('action', None) #ADD if (action == "add"): codeAfm = request.POST.get('codeAfm', None) codeGrad = request.POST.get('codeGrad', None) codeSpec = request.POST.get('codeSpec', None) surname = request.POST.get('surname', None) name = request.POST.get('name', None) try: record = Teacher( codeAfm=codeAfm, codeGrad=codeGrad, codeSpec=codeSpec, surname=surname, name=name, ).save() #'Αδυναμία εισαγωγής | τροποποίησης | διαγραφής | εγγραφής.' msg = "Επιτυχής εισαγωγή εγγραφής!" helperMessageLog(request, msg, tag='info') except DatabaseError: transaction.rollback() msg = "Αδυναμία εισαγωγής εγγραφής!" helperMessageLog(request, msg, tag='error') dictData = Teacher.objects.filter(id=record.id).values() jsonData = json.dumps(dictData) return HttpResponse(jsonData, content_type='application/json') #DELETE if (action == "delete"): id = request.POST.get('id', None) try: record = Teacher.objects.filter(id=id) record.delete() msg = "Επιτυχής διαγραφή εγγραφής!" helperMessageLog(request, msg, tag='info') except DatabaseError: transaction.rollback() msg = "Αδυναμία διαγραφής εγγραφής!" helperMessageLog(request, msg, tag='error') return HttpResponse(msg, content_type='application/json') #UPDATE elif (action == "update"): id = request.POST.get('id', None) codeAfm = request.POST.get('codeAfm', None) codeGrad = request.POST.get('codeGrad', None) codeSpec = request.POST.get('codeSpec', None) surname = request.POST.get('surname', None) name = request.POST.get('name', None) try: record = Teacher.objects.filter(id=id) record.update( codeAfm=codeAfm, codeGrad=codeGrad, codeSpec=codeSpec, surname=surname, name=name, ) #'Αδυναμία εισαγωγής | τροποποίησης | διαγραφής | εγγραφής.' msg = "Επιτυχής τροποποίηση εγγραφής!" helperMessageLog(request, msg, tag='info') except DatabaseError: transaction.rollback() msg = "Αδυναμία τροποποίησης εγγραφής!" helperMessageLog(request, msg, tag='error') dictData = record.values() jsonData = json.dumps(list(dictData)) return HttpResponse(jsonData, content_type='application/json') # DEFAULT on View else: dictData = Teacher.objects.all().values() jsonData = json.dumps(list(dictData)) #print jsonData return HttpResponse(jsonData, content_type='application/json')
def jsonTeacherCrud(request): # Display/Filter is only on GET if request.is_ajax() and request.method == 'GET': id = request.GET.get('id', None) action = request.GET.get('action', None) if (action=="filter"): dictData = Teacher.objects.filter(id=id).values() else: dictData = Teacher.objects.all().values() #print dictData jsonData = json.dumps(list(dictData)) return HttpResponse(jsonData, content_type='application/json') # CRUD is only on POST if request.is_ajax() and request.method == 'POST': action = request.POST.get('action', None) #ADD if (action=="add"): codeAfm = request.POST.get('codeAfm', None) codeGrad = request.POST.get('codeGrad', None) codeSpec = request.POST.get('codeSpec', None) surname = request.POST.get('surname', None) name = request.POST.get('name', None) record = Teacher( codeAfm = codeAfm, codeGrad = codeGrad , codeSpec = codeSpec, surname = surname, name=name, ).save() # return Lesson record dictData = Teacher.objects.filter(id=record.id).values() jsonData = json.dumps(dictData) return HttpResponse(jsonData, content_type='application/json') #DELETE if (action=="delete"): id = request.POST.get('id', None) record = Teacher.objects.filter(id=id) try: record.delete() result = "Teacher (%s) deleted successfully." %(record) except IntegrityError: transaction.rollback() result = "Error Teacher (%s) could not be deleted." %(record) return HttpResponse(result, content_type='application/json') #UPDATE elif (action=="update"): id = request.POST.get('id', None) codeAfm = request.POST.get('codeAfm', None) codeGrad = request.POST.get('codeGrad', None) codeSpec = request.POST.get('codeSpec', None) surname = request.POST.get('surname', None) name = request.POST.get('name', None) record = Teacher.objects.filter(id=id) record.update( codeAfm = codeAfm, codeGrad = codeGrad , codeSpec = codeSpec,surname = surname, name=name , ) dictData = record.values() #print dictData jsonData = json.dumps(list(dictData)) return HttpResponse(jsonData, content_type='application/json') # DEFAULT on View else: dictData = Teacher.objects.all().values() jsonData = json.dumps(list(dictData)) #print jsonData return HttpResponse(jsonData, content_type='application/json')