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')
