def adminManageUser(): try: if adminLoginSession() == "admin": loginVO = LoginVO() userDAO = UserDAO() loginId = request.args.get('loginId') userList = userDAO.getUserData(loginId) userDictList = [i.as_dict() for i in userList] if userDictList[0]['loginStatus'] == "inactive": loginStatus = "active" loginVO.loginId = loginId loginVO.loginStatus = loginStatus userDAO.manageUser(loginVO) elif userDictList[0]['loginStatus'] == "active": loginStatus = "inactive" loginVO.loginId = loginId loginVO.loginStatus = loginStatus userDAO.manageUser(loginVO) return redirect(url_for('adminViewUser')) else: return adminLogoutSession() except Exception as ex: print(ex)
def adminManageBloodbank(): try: if adminLoginSession() == "admin": loginVO = LoginVO() bloodBankDAO = BloodBankDAO() loginId = request.args.get('loginId') bloodBankList = bloodBankDAO.getBloodbankData(loginId) bloodBankDictList = [i.as_dict() for i in bloodBankList] if bloodBankDictList[0]['loginStatus'] == "inactive": loginStatus = "active" loginVO.loginId = loginId loginVO.loginStatus = loginStatus bloodBankDAO.manageBloodbank(loginVO) elif bloodBankDictList[0]['loginStatus'] == "active": loginStatus = "inactive" loginVO.loginId = loginId loginVO.loginStatus = loginStatus bloodBankDAO.manageBloodbank(loginVO) return redirect(url_for('adminViewBloodbank')) else: return adminLogoutSession() except Exception as ex: print(ex)
def adminunblockUser(): try: loginVO = LoginVO() loginDAO = LoginDAO() loginId = request.args.get('loginId') print('loginId::', loginId) loginVO.loginId = loginId registerDAO = RegisterDAO() loginVO.loginRole = 'user' loginVO.loginStatus = 'active' loginDAO.validateLogin(loginVO) registerDAO.viewRegister() loginDAO.unblockUser(loginVO) return redirect(url_for('adminViewUser')) except Exception as ex: print(ex)
def updateProfile(): if session['loginRole'] != 'user': return redirect(url_for('login')) loginDAO = LoginDAO() loginVO = LoginVO() registerDAO = RegisterDAO() registerVO = RegisterVO() loginVO.loginId = session['loginId'] loginVO.loginEmailId = request.form['registerEmailId'] loginVO.loginActiveStatus = 'active' registerVO.register_LoginId = session['loginId'] registerVO.registerFirstName = request.form['registerFirstName'] registerVO.registerLastName = request.form['registerLastName'] registerVO.registerContact = request.form['registerContact'] registerVO.registerActiveStatus = 'active' registerDAO.updateRegister(registerVO) loginDAO.updateLogin(loginVO) return redirect(url_for('userProfile'))
def adminFile(): try: loginVO = LoginVO() loginDAO = LoginDAO() fileUrl = request.form['file'] print(fileUrl) loginUsername = request.form['loginUsername'] print(loginUsername) nameOfFile = loginUsername+".jpg" nameOfFileForDatabase = loginUsername loginList = loginDAO.findUser(loginUsername) loginId = loginList[0].loginId loginVO.loginId = loginId loginVO.loginFileName = nameOfFileForDatabase loginDAO.addNameForFr(loginVO) urllib.request.urlretrieve(fileUrl, "project/static/adminResources/face/"+nameOfFile) print("DONE") return redirect(url_for('adminLoadLogin')) except Exception as ex: print(ex)
def adminDeleteTrafficPoliceStation(): try: if adminLoginSession() == 'admin': loginDAO = LoginDAO() loginVO = LoginVO() trafficPoliceStationVO = TrafficPoliceStationVO() trafficPoliceStationDAO = TrafficPoliceStationDAO() loginId = request.args.get('loginId') trafficPoliceStationId = request.args.get('trafficPoliceStationId') loginVO.loginId = loginId trafficPoliceStationVO.trafficPoliceStationId = trafficPoliceStationId trafficPoliceStationDAO.deleteTrafficPoliceStation(trafficPoliceStationVO) loginDAO.deleteLogin(loginVO) return redirect(url_for('adminViewTrafficPoliceStation')) else: return adminLogoutSession() except Exception as ex: print(ex)
def adminEditTrafficPoliceStation(): try: if adminLoginSession() == 'admin': trafficPoliceStationVO = TrafficPoliceStationVO() trafficPoliceStationDAO = TrafficPoliceStationDAO() loginVO = LoginVO() loginDAO = LoginDAO() areaDAO = AreaDAO() trafficPoliceStationId = request.args.get('trafficPoliceStationId') trafficPoliceStation_LoginId = request.args.get( 'trafficPoliceStation_LoginId') trafficPoliceStationVO.trafficPoliceStationId = trafficPoliceStationId loginVO.loginId = trafficPoliceStation_LoginId trafficPoliceStationVOList = trafficPoliceStationDAO.editTrafficPoliceStation( trafficPoliceStationVO) loginVOList = loginDAO.editLogin(loginVO) areaVOList = areaDAO.viewArea() return render_template( 'admin/editTrafficPoliceStation.html', trafficPoliceStationVOList=trafficPoliceStationVOList, areaVOList=areaVOList, loginVOList=loginVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminViewPurchase(): try: if adminLoginSession() == 'admin': purchaseDAO = PurchaseDAO() purchaseVOList = purchaseDAO.viewPurchase() print("__________________", purchaseVOList) loginVO = LoginVO() loginDAO = LoginDAO() packageVO = PackageVO() packageDAO = PackageDAO() purchaseDictList = [i.as_dict() for i in purchaseVOList] print('$$$$$$$$$$$$$$$$', purchaseDictList) loginVO.loginId = purchaseDictList[0]['purchase_loginId'] packageVO.packageId = purchaseDictList[0]['purchase_packageId'] packageVOList = packageDAO.viewUserPackage(packageVO) loginVOList = loginDAO.registerLogin(loginVO) print('ok') return render_template('admin/viewPurchase.html', purchaseVOList=purchaseVOList, packageVOList=packageVOList, loginVOList=loginVOList) else: adminLogoutSession() except Exception as ex: print(ex)
def adminUpdateTrafficPoliceStation(): try: if adminLoginSession() == 'admin': trafficPoliceStationId = request.form['trafficPoliceStationId'] trafficPoliceStationUsername = request.form[ 'trafficPoliceStationUsername'] trafficPoliceStationName = request.form['trafficPoliceStationName'] trafficPoliceStation_AreaId = request.form[ 'trafficPoliceStation_AreaId'] trafficPoliceStationAddress = request.form[ 'trafficPoliceStationAddress'] trafficPoliceStationContact = request.form[ 'trafficPoliceStationContact'] trafficPoliceStation_LoginId = request.form[ 'trafficPoliceStation_LoginId'] trafficPoliceStationVO = TrafficPoliceStationVO() trafficPoliceStationDAO = TrafficPoliceStationDAO() loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginId = trafficPoliceStation_LoginId loginVOList = loginDAO.registerLogin(loginVO) loginDictList = [i.as_dict() for i in loginVOList] loginVO.loginId = loginDictList[0]['loginId'] loginVO.loginUsername = trafficPoliceStationUsername loginVO.loginPassword = loginDictList[0]['loginPassword'] loginVO.loginStatus = loginDictList[0]['loginStatus'] loginVO.loginRole = loginDictList[0]['loginRole'] loginDAO.updateLogin(loginVO) trafficPoliceStationVO.trafficPoliceStationId = trafficPoliceStationId trafficPoliceStationVO.trafficPoliceStationName = trafficPoliceStationName trafficPoliceStationVO.trafficPoliceStationAddress = trafficPoliceStationAddress trafficPoliceStationVO.trafficPoliceStationContact = trafficPoliceStationContact trafficPoliceStationVO.trafficPoliceStation_AreaId = trafficPoliceStation_AreaId trafficPoliceStationVO.trafficPoliceStation_LoginId = trafficPoliceStation_LoginId trafficPoliceStationDAO.updateTrafficPoliceStation( trafficPoliceStationVO) return redirect(url_for('adminViewTrafficPoliceStation')) else: adminLogoutSession() except Exception as ex: print(ex)
def userValidateOTP(): try: passwordOTP = request.form['passwordOTP'] if passwordOTP == session['session_OTP']: loginPassword = ''.join( (random.choice(string.ascii_letters + string.digits)) for x in range(8)) loginUsername = session['session_loginUsername'] sender = "*****@*****.**" receiver = loginUsername msg = MIMEMultipart() msg['From'] = sender msg['To'] = receiver msg['subject'] = "Reset Password" msg.attach(MIMEText('Your new Password is:')) msg.attach(MIMEText(loginPassword, 'plain')) server = smtplib.SMTP('smtp.gmail.com', 587) server.starttls() server.login(sender, "9925646618") text = msg.as_string() server.sendmail(sender, receiver, text) server.quit() loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginUsername = loginUsername loginVO.loginId = session['session_loginId'] loginVO.loginPassword = loginPassword loginDAO.adminUpdateUser(loginVO) return render_template( "admin/login.html", error="Your new password is sent to your email address!") else: return render_template('admin/login.html', error="Invalid OTP,Please ty again!") except Exception as ex: print(ex)
def userProfile(): if session['loginRole'] != 'user': return redirect(url_for('login')) loginDAO = LoginDAO() loginVO = LoginVO() loginVO.loginId = session['loginId'] loginDict = loginDAO.searchLoginDetailsById(loginVO) print "loginDict : ", loginDict return render_template('user/user-profile.html', loginDict=loginDict)
def userupdatePassword(): try: if adminLoginSession() == 'user': oldPassword = request.form['oldPassword'] newPassword = request.form['newPassword'] confirmPassword = request.form['confirmPassword'] loginId = session['session_loginId'] loginUsername = session['session_loginUsername'] loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginUsername = loginUsername loginVOList = loginDAO.loginUsername(loginVO) loginDictList = [i.as_dict() for i in loginVOList] print(loginDictList) for row in loginDictList: loginPassword = row['loginPassword'] session['session_loginPassword'] = loginPassword session.permanent = True if session['session_loginPassword'] == oldPassword: if newPassword == confirmPassword: loginVO.loginId = loginId loginVO.loginPassword = confirmPassword loginDAO.updatePassword(loginVO) return redirect(url_for('userLoadDashboard')) else: msg = "Your New and Confirm Password does not match!!!" return render_template('user/changePassword.html', error=msg) else: msg = "Your Old password is Incorrect!!!" return render_template('user/changePassword.html', error=msg) else: return adminLogoutSession() except Exception as ex: print(ex)
def deletebuyer(): if session['loginDictrole'] == "admin": registerDAO = UserregisterDAO() loginVO = LoginVO() #registerVO.userregisterId=request.form['userregisterId'] loginVO.loginId = request.form['loginId'] registerDAO.deletebuyer(loginVO) return redirect("/viewbuyer")
def adminUpdatePassword(): loginVO = LoginVO() loginDAO = LoginDAO() password1 = request.form['password1'] password2 = request.form['password2'] if password1 == password2: loginVO.loginId = session['session_LoginId'] loginVO.loginPassword = password1 loginDAO.updateLogin(loginVO) return render_template('admin/login.html', msg="Password Reset") else: return render_template('admin/resetPassword.html', msg="Password Mismatch")
def userFavouriteProperties(): if session['loginRole'] != 'user': return redirect(url_for('login')) loginDAO = LoginDAO() loginVO = LoginVO() loginVO.loginId = session['loginId'] loginDict = loginDAO.searchLoginDetailsById(loginVO) return render_template('user/favourite-properties.html', loginDict=loginDict)
def loadProfile(): try: if session['loginRole'] == 'user': loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginId = session['loginId'] getdataDict = loginDAO.getdata(loginVO) return render_template('user/profilePage.html', getdataDict=getdataDict) else: return render_template('admin/login.html') except: return render_template('admin/login.html')
def adminSendForgotPassword(): try: loginDAO = LoginDAO() loginVO = LoginVO() OTP = request.form["otp"] if session['session_OTP'] != OTP: msg = "OTP IS NOT MATCHED" return render_template('user/otp.html', error=msg) else: loginId = session['session_loginId'] password = ''.join((random.choice(string.ascii_letters + string.digits)) for x in range(8)) print(password) sender = "*****@*****.**" receiver = session['session_loginUsername'] msg = MIMEMultipart() msg['From'] = sender msg['To'] = receiver msg['Subject'] = "YOUR PASSWORD" msg.attach(MIMEText('Your Password is:' + password, 'plain')) server = smtplib.SMTP('smtp.gmail.com', 587) server.starttls() server.login(sender, "Qwer123@") text = msg.as_string() server.sendmail(sender, receiver, text) print("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%") loginVO.loginId = loginId loginVO.loginPassword = password loginDAO.forgotPassword(loginVO) return render_template('user/login.html') except Exception as ex: print(ex)
def usernewPassword(): try: userOTP = request.form['userOtp'] if userOTP == session['session_OTP']: loginVO = LoginVO() loginDAO = LoginDAO() loginPassword = ''.join( (random.choice(string.ascii_letters + string.digits)) for x in range(8)) print("loginPassword= "******"dkppwd1998@") text = msg.as_string() server.sendmail(sender, receiver, text) loginVO.loginUsername = receiver loginVO.loginId = session['session_loginId'] loginVO.loginPassword = loginPassword loginDAO.updatePassword(loginVO) return render_template( "admin/login.html", error="Your new password is sent to your email address!") else: return render_template('admin/login.html', error="Invalid OTP,Please ty again!") except Exception as ex: print(ex)
def adminBlockUser(): try: if adminLoginSession() == 'admin': loginId = request.args.get('loginId') loginStatus = 'unactive' loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginId = loginId loginVO.loginStatus = loginStatus loginDAO.updateLogin(loginVO) return redirect(url_for('adminViewUser')) else: return redirect(url_for('adminLogoutSession')) except Exception as ex: print(ex)
def adminUserUnblock(): try: if adminLoginSession() == 'admin': loginVO = LoginVO() loginDAO = LoginDAO() loginId = request.args.get('loginId') loginVO.loginId = loginId loginVO.loginStatus = 'active' loginDAO.userBlock(loginVO) return redirect(url_for('adminViewRegister')) else: return adminLogoutSession() except Exception as ex: print(ex)
def userResetPassword(): try: if adminLoginSession() == 'user': oldLoginPassword = request.form['oldLoginPassword'] newLoginPassword = request.form['newLoginPassword'] confirmNewLoginPassword = request.form['confirmNewLoginPassword'] loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginId = session['session_loginId'] print(loginVO.loginId) loginVO.loginUsername = session['session_loginUsername'] print(loginVO.loginUsername) loginVO.loginPassword = oldLoginPassword print(loginVO.loginPassword) loginDictList = [ i.as_dict() for i in loginDAO.validateLogin(loginVO) ] print(loginDictList) if len(loginDictList) != 0: print([i.as_dict() for i in loginDAO.validateLogin(loginVO)]) if newLoginPassword == confirmNewLoginPassword: loginVO.loginPassword = newLoginPassword loginDAO.adminUpdateUser(loginVO) return render_template("user/index.html") else: return render_template( 'user/resetPassword.html', error= "Invalid confirmation of new password,Please try again!" ) else: return render_template( 'user/resetPassword.html', error="Invalid old password,please enter valid Password!") else: return redirect(url_for("adminLogoutSession")) except Exception as ex: print(ex)
def adminResetPassword(): try: loginDAO = LoginDAO() loginVO = LoginVO() oldPassword = request.form["oldPassword"] newPassword = request.form["newPassword"] conformPassword = request.form["conformPassword"] loginUsername = session['session_loginUsername'] loginVOList = loginDAO.findUser(loginUsername) print(loginVOList) loginDictList = [i.as_dict() for i in loginVOList] print(loginDictList) if loginDictList[0]['loginPassword'] != oldPassword: msg = "PASSWORD IS NOT MATCHED" return render_template('bloodbank/resetPassword.html', error=msg) else: if newPassword == conformPassword: loginId = session['session_loginId'] loginVO.loginId = loginId loginVO.loginPassword = newPassword loginDAO.forgotPassword(loginVO) if adminLoginSession() == 'bloodbank': return render_template('bloodbank/index.html') elif adminLoginSession() == 'user': return render_template('user/index.html') else: msg = "NEWPASSWORD AND CONFORMPASSWORD IS NOT MATCHED" return render_template('bloodbank/resetPassword.html', error=msg) except Exception as ex: print(ex)
def userCheckPassword(): if adminLoginSession() == 'user': oldPassword = request.form['oldPassword'] newPassword1 = request.form['newPassword1'] newPassword2 = request.form['newPassword2'] loginVO = LoginVO() loginDAO = LoginDAO() if oldPassword == session['session_LoginPassword']: if newPassword1 == newPassword2: loginVO.loginId = session['session_LoginId'] loginVO.loginPassword = newPassword1 loginDAO.updateLogin(loginVO) return render_template('admin/login.html', msg="Password Reset") else: return render_template('user/resetPassword.html', msg="Password Mismatch") else: return render_template('user/resetPassword.html', msg="Current Password not Valid") else: adminLogoutSession()
def loadEditprofile(): try: if session['loginRole'] == 'user': loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginId = session['loginId'] getdataDict = loginDAO.getdata(loginVO) if "error" in session: error = session['error'] session.pop('error') return render_template('user/editProfile.html', getdataDict=getdataDict, error=error) else: return render_template('user/editProfile.html', getdataDict=getdataDict) else: return render_template('admin/login.html') except: return render_template('admin/login.html')
def adminUnblockUser(): try: if adminLoginSession() == 'admin': loginDAO = LoginDAO() loginVO = LoginVO() loginId = request.args.get('loginId') loginStatus = 'active' loginVO.loginId = loginId loginVO.loginStatus = loginStatus loginDAO.UnblockUser(loginVO) return adminViewUser() else: return adminLogoutSession() except Exception as ex: print(ex)
def adminInsertNewPassword(): try: loginDAO = LoginDAO() loginVO = LoginVO() loginPassword = request.form["loginPassword"] sender = "*****@*****.**" receiver = session["session_loginUsername"] msg = MIMEMultipart() msg['From'] = sender msg['To'] = receiver msg['Subject'] = "New Password" msg.attach(MIMEText(loginPassword, 'plain')) server = smtplib.SMTP('smtp.gmail.com', 587) server.starttls() server.login(sender, "keval12345") text = msg.as_string() server.sendmail(sender, receiver, text) server.quit() loginVO.loginId = session['session_loginId'] loginVO.loginPassword = loginPassword loginDAO.loginUpdateUser(loginVO) return render_template("admin/login.html") except Exception as ex: print(ex)
def updatePassword(): try: if session['loginRole'] == 'user': loginDAO = LoginDAO() loginVO = LoginVO() loginVO.loginId = session['loginId'] loginpassword = request.form['loginpassword'] loginVO.loginPassword = request.form['loginPassword'] loginDict = loginDAO.searchLoginIddata(loginVO) # print loginDict if loginpassword == loginDict[0]['loginPassword']: loginDAO.changePassword(loginVO) return redirect(url_for('loadProfile')) else: session['error'] = "*wrong password Please enter again" return redirect(url_for('loadChangepassword')) else: return render_template('admin/login.html') except: return render_template('admin/login.html')
def adminUpdateTrafficPoliceStation(): try: if adminLoginSession() == 'admin': loginVO = LoginVO() loginDAO = LoginDAO() trafficPoliceStationVO = TrafficPoliceStationVO() trafficPoliceStationDAO = TrafficPoliceStationDAO() trafficPoliceStationId = request.form['trafficPoliceStationId'] trafficPoliceStationName = request.form['trafficPoliceStationName'] trafficPoliceStationContact = request.form['trafficPoliceStationContact'] trafficPoliceStation_AreaId = request.form['trafficPoliceStation_AreaId'] trafficPoliceStationAddress = request.form['trafficPoliceStationAddress'] loginId = request.form['loginId'] loginUsername = request.form['loginUsername'] loginVO.loginId = loginId loginVO.loginUsername = loginUsername loginDAO.updateLogin(loginVO) trafficPoliceStationVO.trafficPoliceStationId = trafficPoliceStationId trafficPoliceStationVO.trafficPoliceStationName = trafficPoliceStationName trafficPoliceStationVO.trafficPoliceStationContact = trafficPoliceStationContact trafficPoliceStationVO.trafficPoliceStation_AreaId = trafficPoliceStation_AreaId trafficPoliceStationVO.trafficPoliceStationAddress = trafficPoliceStationAddress trafficPoliceStationVO.trafficPoliceStation_LoginId = loginId trafficPoliceStationDAO.updateTrafficPoliceStation(trafficPoliceStationVO) return redirect(url_for('adminViewTrafficPoliceStation')) else: return adminLogoutSession() except Exception as ex: print(ex)
def userUpdateRegister(): try: if adminLoginSession() == 'user': registerVO = RegisterVO() registerDAO = RegisterDAO() loginId = request.form['loginId'] loginUsername = request.form['loginUsername'] registerId = request.form['registerId'] registerFirstName = request.form['registerFirstName'] registerLastName = request.form['registerLastName'] registerAddress = request.form['registerAddress'] registerContact = request.form['registerContact'] loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginId = loginId loginList = loginDAO.viewLogin(loginVO) if loginList[0].loginUsername == loginUsername: pass else: loginPassword = ''.join( (random.choice(string.ascii_letters + string.digits)) for x in range(8)) sender = "*****@*****.**" receiver = loginUsername msg = MIMEMultipart() msg['From'] = sender msg['To'] = receiver msg['Subject'] = "ACCOUNT PASSWORD" msg.attach(MIMEText(loginPassword, 'plain')) server = smtplib.SMTP('smtp.gmail.com', 587) server.starttls() server.login(sender, "parents123eye123") text = msg.as_string() server.sendmail(sender, receiver, text) server.quit() loginVO.loginUsername = loginUsername loginVO.loginPassword = loginPassword loginDAO.updateLogin(loginVO) registerVO.registerId = registerId registerVO.registerFirstName = registerFirstName registerVO.registerLastName = registerLastName registerVO.registerAddress = registerAddress registerVO.registerContact = registerContact registerDAO.updateRegister(registerVO) return redirect(url_for('userLoadDashboard')) else: return adminLogoutSession() except Exception as ex: print(ex)
def userupdateProfile(): try: if adminLoginSession() == 'user': registerId = request.form['registerId'] companyName = request.form['companyName'] registerFirstname = request.form['registerFirstname'] registerLastname = request.form['registerLastname'] registerGender = request.form['registerGender'] registerAddress = request.form['registerAddress'] registerContact = request.form['registerContact'] loginId = request.form['loginId'] loginUsername = request.form['loginUsername'] registerVO = RegisterVO() registerDAO = RegisterDAO() loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginId = loginId loginList = loginDAO.getLoginDetails(loginVO) if loginUsername != loginList[0].loginUsername: loginPassword = ''.join( (random.choice(string.ascii_letters + string.digits)) for x in range(8)) print("loginPassword= "******"dkppwd1998@") text = msg.as_string() server.sendmail(sender, receiver, text) server.quit() loginVO.loginUsername = loginUsername loginVO.loginPassword = loginPassword loginDAO.updatePassword(loginVO) registerVO.registerId = registerId registerVO.companyName = companyName registerVO.registerFirstname = registerFirstname registerVO.registerLastname = registerLastname registerVO.registerAddress = registerAddress registerVO.registerGender = registerGender registerVO.registerContact = registerContact registerDAO.updateProfile(registerVO) return redirect(url_for('userLoadDashboard')) else: return adminLogoutSession() except Exception as ex: print(ex)