def search(request):
if "emailid" in request.session:
name = request.POST.get('name')
dao = Student()
dao1 = Faculty()
dao2 = Course()
row = dao.searchstudent(name)
row1 = dao1.searchfaculty(name)
row2 = dao2.searchcourse(name)
context = {'row': row}
context1 = {'row1': row1}
context2 = {'row2': row2}
if dao.searchstudent(name):
print(name)
return render(request, 'schedules/view_after_search.html', context)
elif dao1.searchfaculty(name):
return render(request, 'schedules/f_view_after_search.html',
context1)
elif dao2.searchcourse(name):
return render(request, 'schedules/c_view_after_search.html',
context2)
else:
return render(request, 'schedules/Dashboard.html')
else:
return redirect('index-page')
def vfaculty(request):
if "emailid" in request.session:
dao = Faculty()
row = dao.viewfaculty()
context = {'row': row}
return render(request, 'schedules/viewfaculty.html', context)
else:
return redirect('index-page')
def efaculty(request):
if "emailid" in request.session:
fid = request.GET.get('fid')
dao = Faculty()
row = dao.viewfacultybyid(fid)
context = {'row': row}
return render(request, 'schedules/editfaculty.html', context)
else:
return redirect('index-page')
def deletefaculty(request):
if "emailid" in request.session:
email = request.GET.get('email')
dao = Faculty()
lst1 = dao.deletefaculty(email)
context = {'lst1': lst1, 'deletefaculty': "deletefaculty"}
if dao.deletefaculty(email) > 0:
return redirect('viewfaculty')
else:
return redirect('index-page')
def fviewleave(request): #for viewing leaves (tables)
if "emailid" in request.session:
dao = Faculty()
row = dao.fviewleave()
context = {'row': row}
if dao.fviewleave():
return render(request, 'schedules/facultyleave.html', context)
else:
return redirect('dashboard')
else:
return redirect('index-page')
def rejectf(request):
if "emailid" in request.session:
l_id = request.GET.get('l_id')
dao = Faculty()
a = dao.rejectfaculty('l_id')
row = dao.fviewleave()
context = {'a': a, 'row': row}
if dao.rejectfaculty(l_id) > 0:
return render(request, 'schedules/facultyleave.html', context)
else:
return redirect('index-page')
def rejectfleave(request):
if "emailid" in request.session:
l_id = request.POST.get('l_id')
# print("l_id1:",l_id)
dao = Faculty()
a = dao.rejectfaculty(l_id)
# print("a1:",a)
row = dao.fviewleave()
context = {'a': a, 'row': row}
if dao.rejectfaculty() > 0:
print("def")
return redirect('facultyleave')
else:
return redirect('index-page')
def editfaculty(request):
if "emailid" in request.session:
fid = request.POST.get('fid')
f_name = request.POST.get('f_name')
l_name = request.POST.get('l_name')
emailid = request.POST.get('emailid')
phno = request.POST.get('phno')
dao = Faculty()
row = dao.viewfacultybyid(fid)
context = {'row': row, 'editfaculty': "editfaculty"}
if dao.editfaculty(f_name, l_name, emailid, phno, fid) > 0:
return redirect('viewfaculty')
else:
return redirect('index-page')
def Plannerform(request, c_code_selected=None):
dao1 = Student()
dao2 = Course()
dao3 = Faculty()
lst1 = dao1.selectcourse()
lst2 = dao2.selectmodule(c_code_selected)
lst3 = dao3.selectfaculty()
context = {
'c_code_selected': c_code_selected,
'lst1': lst1,
'lst2': lst2,
'lst3': lst3
}
return render(request, 'schedules/session.html', context)
def addf(request):
if "emailid" in request.session:
# fid = request.POST.get('fid')
f_name = request.POST.get('f_name')
l_name = request.POST.get('l_name')
emailid = request.POST.get('emailid')
password = request.POST.get('password')
phno = request.POST.get('phno')
dao = Faculty()
context = {'addfaculty': "addfaculty"}
if dao.addf(f_name, l_name, emailid, password, phno) > 0:
return redirect('viewfaculty')
else:
return render(request, 'schedules/Dashboard.html')
else:
return redirect('index-page')