def askquestion(request): con = settings.CONNECTION() cr = con.cursor() id = request.session['userdata'].get('id') if request.method == 'POST': qus = request.POST.get('qus') query = "insert into question(qus,ask_by) value('{0}',{1})".format( qus, id) cr.execute(query) con.commit() # get all question .. query = "select * from question where ask_by={0} order by qid DESC".format( id) cr.execute(query) questions = cr.fetchall() finaldata = [] for qus in questions: lst = list(qus) qid = lst[0] qu = "select ans,ans_date,name from answer,user where qus={0} and answer.ans_by=user.uid".format( qid) cr.execute(qu) a = cr.fetchall() lst.append(a) finaldata.append(lst) print(finaldata) con.close() return render(request, "ask.html", {"questions": questions})
def signup(request): name = request.POST.get('name') mail = request.POST.get('mail') pwd = request.POST.get('pwd') query = "insert into signup(name,mail,password) value('{0}','{1}','{2}')".format( name, mail, pwd) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) cnn.commit() msg = "Sign Up Success!" return render(request, "signup.html", {"msg": msg})
def verify(request): if request.method == "GET": return render(request, 'verify.html') else: otp = request.POST.get('otp') mail = request.POST.get('email') query = "update user set isVerify=1 where mail='{0}' and otp={1}".format( mail, otp) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) cnn.commit() return redirect('/college/login')
def resend(request): name = request.POST.get('NAME') email = request.POST.get('EMAIL') otp = sendMail(name, email) print(name, email, otp) #query = "update user set name=NULL, email=NULL,otp=NULL where email='{1}'".format(email,otp) query = "update user set otp={1} where mail='{0}'".format(email, otp) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) cnn.commit() msg = "OTP Sent!" return render(request, 'verify1.html', {"msg": msg})
def home(request): name = request.session['userdata'].get('name') branch = request.session['userdata'].get('branch') query = "select name,mail,phone from user where branch={0} and type=2".format(branch) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) students = cr.fetchall() return render(request,"facthome.html",{"name":name,"students":students})
def home1(request): name = request.session['userdata'].get('name') branch = request.session['userdata'].get('branch') id = request.session['userdata'].get('id') query = "select name,mail,phone from user where branch={0} and type=2 and uid!={1}".format(branch,id) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) names = cr.fetchall() return render(request,"studhome1.html",{"name":name,"branch":branch,"names":names})
def verify1(request): if request.method == "GET": return render(request, 'verify1.html') else: otp = request.POST.get('otp') mail = request.POST.get('email') #password = request.POST.get('password') query = "update user set isVerify=1 where mail='{0}' and otp={1}".format( mail, otp) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) #record = cr.fetchone() #type = record[5] cnn.commit() #msg = "Invalid OTP" return redirect('/college/login1')
def register(request): name = request.POST.get('username') email = request.POST.get('email') pwd = request.POST.get('pwd') type = request.POST.get('type') branch = request.POST.get('branch') #mail = request.session['userdata'].get('email') #if email!=mail: otp = sendMail(name, email) query = "insert into user(name,mail,password,type,branch,otp) value('{0}','{1}','{2}',{3},{4},{5})".format( name, email, pwd, type, branch, otp) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) cnn.commit() reg = "Registration Success!" return render(request, "login1.html", {"reg": reg})
def saveContact(request): name = request.POST.get("cname") mail = request.POST.get("email") phone = request.POST.get("phone") sub = request.POST.get("subject") msg = request.POST.get("message") query = "insert into contact(name,email,phone,subject,message) value('{0}','{1}','{2}','{3}','{4}')".format( name, mail, phone, sub, msg) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) cnn.commit() #print(name,mail,phone,sub,msg) context = "Contact Saved!" return render(request, "contact1.html", {"messages": context})
def resetpw(request): if request.method == "GET": return render(request, 'resetpw.html') else: MAIL = request.POST.get('MAIL') np = request.POST.get('np') PWD = request.POST.get('PWD') if np == PWD: query = "update user set password='******' where mail='{0}'".format( MAIL, np) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) cnn.commit() return redirect('/college/login1') else: msg = "Password NOT matched!" return render(request, 'resetpw.html', {"msg": msg})
def loginuser(request): email = request.POST.get('email') pwd = request.POST.get('pwd') query = "select * from user where mail='{0}' and password='******'".format( email, pwd) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) record = cr.fetchone() #print("Record: ",record) if record is None: msg = "Login Failed!" return redirect('/college/login1?error=1') else: id = record[0] name = record[1] email = record[2] phone = record[3] branch = record[6] type = record[5] isVerify = record[8] # 0 if isVerify == 0: return redirect('/college/verify1') else: user = { "id": id, "name": name, "email": email, "phone": phone, "branch": branch, "type": type } request.session['userdata'] = user if type == 1: # faculty return redirect('/faculty/home1') else: # student return redirect('/student/home1')
def register(request): name = request.POST.get('name') email = request.POST.get('mail') password = request.POST.get('password') type = request.POST.get('type') branch = request.POST.get('branch') otp = sendMail(name, email) query = "insert into user(name,mail,password,type,branch,otp) value('{0}','{1}','{2}',{3},{4},{5})".format( name, email, password, type, branch, otp) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) cnn.commit() cnn.close() return HttpResponse("Register User Success !")
def stuanswer1(request): branch = request.session['userdata'].get('branch') sid = request.session['userdata'].get('id') cnn = settings.CONNECTION() cr = cnn.cursor() if request.method=="POST": answer = request.POST.get('answer') qus = request.POST.get('qus') query = "insert into stuanswer(ans,qus,ans_by) value('{0}','{1}',{2})".format(answer,qus,sid) cr.execute(query) cnn.commit() # subquery - nested query query = "select qid,qus,qus_date,name from stuquestion, user where ask_by in (select uid from user where branch={0} and type=2 and uid!={1}) and stuquestion.ask_by=user.uid".format(branch,sid) cr.execute(query) questions = cr.fetchall() return render(request,'stuanswer1.html',{'questions':questions})
def loginuser(request): email = request.POST.get('email') pwd = request.POST.get('pwd') from cryptography.fernet import Fernet cipher_suite = Fernet(HASHKEY) # query = "select * from user where mail='{0}' and password='******'".format(email,pwd) query = "select * from user where mail='{0}'".format(email) cnn = settings.CONNECTION() cr = cnn.cursor() cr.execute(query) record = cr.fetchone() if record is None: msg = "Login Failed !" return redirect('/college/login?error=1') ciphered_text = record[4] print(">>>>>", ciphered_text) ciphered_text = bytes(ciphered_text, "utf-8") try: unciphered_text = (cipher_suite.decrypt(ciphered_text)) print("this is uncipherd txt>>>>>>", unciphered_text) except Exception as e: print(":Exception") return redirect("/college/login?error=1") if pwd != unciphered_text.decode("utf-8"): print("pwd not matched") msg = "Login Failed !" return redirect('/college/login?error=1') else: print(">>>>>> ", record) id = record[0] name = record[1] email = record[2] phone = record[3] branch = record[6] type = record[5] # type isVerify = record[8] # 0 if isVerify == 1: return redirect('/college/verify') else: user = { "id": id, "name": name, "email": email, "phone": phone, "branch": branch, "type": type } request.session['userdata'] = user if type == 1: # faculty return redirect('/faculty/home') else: # student return redirect('/student/home')