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 adminValidateLogin(): try: loginUsername = request.form['loginUsername'] loginPassword = request.form['loginPassword'] loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginUsername = loginUsername loginVO.loginPassword = loginPassword loginVO.loginStatus = "active" loginVOList = loginDAO.validateLogin(loginVO) loginDictList = [i.as_dict() for i in loginVOList] print(loginDictList) lenLoginDictList = len(loginDictList) if lenLoginDictList == 0: msg = 'Username Or Password is Incorrect !' return render_template('admin/login.html', error=msg) elif loginDictList[0]['loginStatus'] == "inactive": blockmsg = 'User is temporary blocked by Website Admin !' return render_template('admin/login.html', errorblock=blockmsg) else: for row1 in loginDictList: loginId = row1['loginId'] loginUsername = row1['loginUsername'] loginRole = row1['loginRole'] session['session_loginId'] = loginId session['session_loginUsername'] = loginUsername session['session_loginRole'] = loginRole session.permanent = True if loginRole == 'admin': return redirect(url_for('adminLoadDashboard')) elif loginRole == 'user': return redirect(url_for('userLoadDashboard')) else: return render_template('admin/login.html') 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 adminValidateLogin(): loginUsername = request.form['loginUsername'] loginPassword = request.form['loginPassword'] loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginUsername = loginUsername loginVO.loginPassword = loginPassword loginVO.loginStatus = "active" loginVOList = loginDAO.validateLogin(loginVO) loginDictList = [i.as_dict() for i in loginVOList] print(loginDictList) lenLoginDictList = len(loginDictList) if lenLoginDictList == 0: msg = 'Username Or Password is Incorrect !' return render_template('admin/Login.html', error=msg) else: for row1 in loginDictList: loginId = row1['loginId'] loginUsername = row1['loginUsername'] loginRole = row1['loginRole'] session['session_loginId'] = loginId session['session_loginUsername'] = loginUsername session['session_loginRole'] = loginRole session.permanent = False if loginRole == 'admin': return redirect(url_for('adminLoadDashboard')) else: return render_template('user/Index.html ')
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 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 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 adminValidateLogin(): try: loginUsername = request.form['loginUsername'] loginPassword = request.form['loginPassword'] loginVO = LoginVO() loginDAO = LoginDAO() loginVO.loginUsername = loginUsername loginVO.loginPassword = loginPassword loginVO.loginStatus = 'active' loginVOList = loginDAO.validateLogin(loginVO) loginDictList = [i.as_dict() for i in loginVOList] if len(loginDictList) == 0: msg = 'username or password is incorrent !' return render_template('admin/login.html', msg=msg) else: for row in loginDictList: loginId = row['loginId'] loginUsername = row['loginUsername'] loginRole = row['loginRole'] session['session_LoginId'] = loginId session['session_LoginUsername'] = loginUsername session['session_LoginRole'] = loginRole session['session_LoginPassword'] = loginPassword session.permenent = True if loginRole == 'user': return redirect(url_for('userLoadDashboard')) if loginRole == 'admin': return redirect(url_for('adminLoadDashboard')) except Exception as ex: print(ex)
def userInsertRegister(): try: loginVO = LoginVO() loginDAO = LoginDAO() registerVO = RegisterVO() registerDAO = RegisterDAO() loginUsername = request.form['loginUsername'] companyName = request.form['companyName'] registerFirstname = request.form['registerFirstname'] registerLastname = request.form['registerLastname'] registerGender = request.form['registerGender'] registerAddress = request.form['registerAddress'] registerContact = request.form['registerContact'] 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 = loginUsername loginVO.loginPassword = loginPassword loginVO.loginRole = 'user' loginVO.loginStatus = 'active' loginDAO.insertLogin(loginVO) registerVO.companyName = companyName registerVO.registerFirstname = registerFirstname registerVO.registerLastname = registerLastname registerVO.registerAddress = registerAddress registerVO.registerGender = registerGender registerVO.registerContact = registerContact registerVO.register_LoginId = loginVO.loginId registerDAO.insertRegister(registerVO) server.quit() return render_template('admin/login.html') except Exception as ex: print(ex)
def bloodbankInsertBloodBank(): try: loginVO = LoginVO() loginDAO = LoginDAO() bloodBankVO = BloodBankVO() bloodBankDAO = BloodBankDAO() loginUsername = request.form['loginUsername'] bloodBankName = request.form['bloodBankName'] bloodBank_CityId = request.form['bloodBank_CityId'] bloodBank_AreaId = request.form['bloodBank_AreaId'] bloodBankAddress = request.form['bloodBankAddress'] bloodBankContact = request.form['bloodBankContact'] bloodBankLicense = request.form['bloodBankLicense'] print("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!") loginPassword = ''.join( (random.choice(string.ascii_letters + string.digits)) for x in range(8)) print("@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@") print("loginPassword="******"*****@*****.**" receiver = loginUsername msg = MIMEMultipart() msg['From'] = sender msg['To'] = receiver msg['Subject'] = "LOGIN PASSWORD" msg.attach(MIMEText('Your Password is:' + loginPassword, 'plain')) server = smtplib.SMTP('smtp.gmail.com', 587) server.starttls() server.login(sender, "Qwer123@") text = msg.as_string() server.sendmail(sender, receiver, text) loginVO.loginUsername = loginUsername loginVO.loginPassword = loginPassword loginVO.loginRole = "bloodbank" loginVO.loginStatus = "active" loginVO.loginFileName = "None" print("###############################################") loginDAO.insertLogin(loginVO) print("$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$") bloodBankVO.bloodBankName = bloodBankName bloodBankVO.bloodBank_CityId = bloodBank_CityId bloodBankVO.bloodBank_AreaId = bloodBank_AreaId bloodBankVO.bloodBankAddress = bloodBankAddress bloodBankVO.bloodBankContact = bloodBankContact bloodBankVO.bloodBankLicense = bloodBankLicense bloodBankVO.bloodBank_LoginId = loginVO.loginId print("%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%") bloodBankDAO.insertBloodBank(bloodBankVO) print("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^") server.quit() return render_template("admin/takePicture.html", loginUsername=loginUsername) except Exception as ex: print(ex)
def adminInsertRegister(): try: if adminLoginSession() == 'admin': loginVO = LoginVO() loginDAO = LoginDAO() trafficPoliceStationVO = TrafficPoliceStationVO() trafficPoliceStationDAO = TrafficPoliceStationDAO() trafficPoliceStationUsername = request.form[ 'trafficPoliceStationUsername'] trafficPoliceStationName = request.form['trafficPoliceStationName'] trafficPoliceStation_AreaId = request.form[ 'trafficPoliceStation_AreaId'] trafficPoliceStationAddress = request.form[ 'trafficPoliceStationAddress'] trafficPoliceStationContact = request.form[ 'trafficPoliceStationContact'] loginPassword = ''.join( (random.choice(string.ascii_letters + string.digits)) for x in range(8)) sender = "*****@*****.**" receiver = trafficPoliceStationUsername msg = MIMEMultipart() msg['From'] = sender msg['To'] = receiver msg['Subject'] = "TRAFFIC POLICE STATION LOGIN PASSWORD" msg.attach(MIMEText(loginPassword, 'plain')) server = smtplib.SMTP('smtp.gmail.com', 587) server.starttls() server.login(sender, "harshil3632") text = msg.as_string() server.sendmail(sender, receiver, text) loginVO.loginUsername = trafficPoliceStationUsername loginVO.loginPassword = loginPassword loginVO.loginRole = "user" loginVO.loginStatus = "active" loginVOList = loginDAO.insertLogin(loginVO) loginDictList = [i.as_dict() for i in loginVOList] trafficPoliceStationVO.trafficPoliceStationName = trafficPoliceStationName trafficPoliceStationVO.trafficPoliceStationContact = trafficPoliceStationContact trafficPoliceStationVO.trafficPoliceStationAddress = trafficPoliceStationAddress trafficPoliceStationVO.trafficPoliceStation_AreaId = int( trafficPoliceStation_AreaId) trafficPoliceStationVO.trafficPoliceStation_LoginId = loginDictList[ 0]['loginId'] trafficPoliceStationDAO.insertTrafficPoliceStation( trafficPoliceStationVO) server.quit() return redirect(url_for('adminViewTrafficPoliceStation')) else: adminLogoutSession() except Exception as ex: print(ex)
def userInsertUser(): try: loginVO = LoginVO() loginDAO = LoginDAO() userVO = UserVO() userDAO = UserDAO() loginUsername = request.form['loginUsername'] userFirstName = request.form['userFirstName'] userLastName = request.form['userLastName'] userBirthDate = request.form['userBirthDate'] user_BloodGroupId = request.form['user_BloodGroupId'] userGender = request.form['userGender'] userWeight = request.form['userWeight'] userHeight = request.form['userHeight'] user_CityId = request.form['user_CityId'] userDiseases = request.form['userDiseases'] user_AreaId = request.form['user_AreaId'] userAddress = request.form['userAddress'] userContact = request.form['userContact'] userFile = request.files['userFile'] print(userFile) userFileName = secure_filename(userFile.filename) print(userFileName) userFilePath = os.path.join(app.config['UPLOAD_FOLDER']) print(userFilePath) userFile.save(os.path.join(userFilePath, userFileName)) userVO.userFileName = userFileName userVO.userFilePath = userFilePath.replace("project", "..") print("!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!") loginPassword = ''.join( (random.choice(string.ascii_letters + string.digits)) for x in range(8)) print("loginPassword="******"*****@*****.**" sender = "*****@*****.**" receiver = loginUsername msg = MIMEMultipart() msg['From'] = sender msg['To'] = receiver msg['Subject'] = "LOGIN PASSWORD" msg.attach(MIMEText('Your Password is:' + loginPassword, 'plain')) server = smtplib.SMTP('smtp.gmail.com', 587) server.starttls() #server.login(sender, "qazwsxedcrfvtgb1234567890") server.login(sender, "Qwer123@") text = msg.as_string() server.sendmail(sender, receiver, text) loginVO.loginUsername = loginUsername loginVO.loginPassword = loginPassword loginVO.loginRole = "user" loginVO.loginStatus = "active" loginVO.loginFileName = "None" loginDAO.insertLogin(loginVO) userVO.user_CityId = user_CityId userVO.user_BloodGroupId = user_BloodGroupId userVO.userFirstName = userFirstName userVO.userLastName = userLastName userVO.userBirthDate = userBirthDate userVO.userGender = userGender userVO.userWeight = userWeight userVO.userHeight = userHeight userVO.userDiseases = userDiseases userVO.user_AreaId = user_AreaId userVO.userAddress = userAddress userVO.userContact = userContact userVO.user_LoginId = loginVO.loginId userDAO.insertUser(userVO) server.quit() return render_template("admin/takePicture.html", loginUsername=loginUsername) except Exception as ex: print(ex)
def userInsertRegister(): try: loginUsername = request.form['loginUsername'] loginPassword = ''.join( (random.choice(string.ascii_letters + string.digits)) for x in range(8)) print("password="******"user" loginVO.loginStatus = "active" sender = "*****@*****.**" receiver = loginUsername msg = MIMEMultipart() msg['From'] = sender msg['To'] = receiver msg['Subject'] = "LOGIN 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) loginDAO.insertLogin(loginVO) registerFirstName = request.form['registerFirstName'] registerLastName = request.form['registerLastName'] registerAddress = request.form['registerAddress'] registerContact = request.form['registerContact'] registerVO = RegisterVO() registerDAO = RegisterDAO() registerVO.registerFirstName = registerFirstName registerVO.registerLastName = registerLastName registerVO.registerAddress = registerAddress registerVO.registerContact = registerContact registerVO.register_LoginId = loginVO.loginId registerDAO.insertRegister(registerVO) server.quit() return render_template("admin/login.html") except Exception as ex: print(ex)
def adminInsertRegister(): try: loginVO = LoginVO() loginDAO = LoginDAO() registerVO = RegisterVO() registerDAO = RegisterDAO() loginUsername = request.form['loginUsername'] registertrafficPoliceStationName = request.form[ 'registertrafficPoliceStationName'] registertrafficPoliceStationAreaName = request.form[ 'registertrafficPoliceStationAreaName'] registertrafficPoliceStationAddress = request.form[ 'registertrafficPoliceStationAddress'] registertrafficPoliceStationContact = request.form[ 'registertrafficPoliceStationContact'] loginPassword = ''.join( (random.choice(string.ascii_letters + string.digits)) for x in range(8)) print("loginPassword="******"*****@*****.**" receiver = loginUsername msg = MIMEMultipart() msg['From'] = sender msg['To'] = receiver msg['Subject'] = "TRAFFIC POLICE STATION LOGIN PASSWORD" msg.attach(MIMEText(loginPassword, 'plain')) server = smtplib.SMTP('smtp.gmail.com', 587) server.starttls() server.login(sender, "trafficease123") text = msg.as_string() server.sendmail(sender, receiver, text) loginVO.loginUsername = loginUsername loginVO.loginPassword = loginPassword loginVO.loginRole = "user" loginVO.loginStatus = "active" print('hello') loginDAO.insertLogin(loginVO) registerVO.registertrafficPoliceStationName = registertrafficPoliceStationName registerVO.registertrafficPoliceStationAreaName = registertrafficPoliceStationAreaName registerVO.registertrafficPoliceStationAddress = registertrafficPoliceStationAddress registerVO.registertrafficPoliceStationContact = registertrafficPoliceStationContact registerVO.register_LoginId = loginVO.loginId registerDAO.insertRegister(registerVO) server.quit() return render_template("admin/login.html") except Exception as ex: print(ex)
def userInsertRegister(): try: loginVO = LoginVO() loginDAO = LoginDAO() registerVO = RegisterVO() registerDAO = RegisterDAO() loginUsername = request.form["loginUsername"] loginVOList = loginDAO.findUser(loginUsername) print("check-----", loginVOList) loginDictList = [i.as_dict() for i in loginVOList] print(loginDictList) lenLoginDictList = len(loginDictList) if lenLoginDictList != 0: msg = "This Username Already Exist." return render_template('user/register.html', error=msg) else: loginPassword = ''.join( (random.choice(string.ascii_letters + string.digits)) for x in range(8)) registerFirstName = request.form['registerFirstName'] registerLastName = request.form['registerLastName'] registerMobileNumber = request.form['registerMobileNumber'] registerGender = request.form['registerGender'] print("loginPassword="******"*****@*****.**" receiver = loginUsername msg = MIMEMultipart() msg['From'] = sender msg['To'] = receiver msg['Subject'] = "YOUR AGRI-PEDIA PASSWORD" msg.attach( MIMEText( "Welcome To AGRI-PEDIA Family. ------------------ " + registerFirstName + " " + registerLastName + "\n \n ", 'plain')) msg.attach( MIMEText("Your Username is " + loginUsername + "\n", 'plain')) msg.attach( MIMEText("Your Password is " + loginPassword + "\n \n \n ", 'plain')) msg.attach( MIMEText( "Please Login to Website. Enter Username & Password And enjoy AGRI-PEDIA \n \n \n \n", 'plain')) msg.attach(MIMEText(" ~ ADMIN AGRI-PEDIA")) server = smtplib.SMTP('smtp.gmail.com', 587) server.starttls() server.login(sender, "aimfs@12345") text = msg.as_string() server.sendmail(sender, receiver, text) loginVO.loginUsername = loginUsername loginVO.loginPassword = loginPassword loginVO.loginRole = "user" loginVO.loginStatus = "active" loginDAO.insertLogin(loginVO) registerVO.registerFirstName = registerFirstName registerVO.registerLastName = registerLastName registerVO.registerMobileNumber = registerMobileNumber registerVO.registerGender = registerGender registerVO.register_LoginId = loginVO.loginId registerDAO.insertRegister(registerVO) server.quit() return render_template("admin/Login.html") except Exception as ex: print(ex)