def checkLogin():
loginDAO = LoginDAO()
loginVO = LoginVO()
loginEmail = request.form['loginEmail']
loginPassword = request.form['loginPassword']
loginVO.loginEmail = loginEmail
loginVO.loginPassword = loginPassword
loginDict = loginDAO.searchLogin(loginVO)
print(loginDict)
if len(loginDict) == 0:
flash('Invalid Email !', 'danger')
return redirect(url_for('loadLogin'))
elif loginDict[0]["loginPassword"] != loginVO.loginPassword:
flash('Invalid Password !', 'danger')
return redirect(url_for('loadLogin'))
elif loginDict[0]["loginRole"] == 'admin':
session['sessionloginDict'] = loginDict[0]
# flash('Login Success for Admin', 'success')
return redirect(url_for('adminHome'))
elif loginDict[0]["loginRole"] == 'user':
session['sessionloginDict'] = loginDict[0]
# flash('Login Success for User', 'success')
return redirect(url_for('userHome'))
def updateProfile():
try:
registerDAO = RegisterDAO()
registerVO = RegisterVO()
loginDAO = LoginDAO()
loginVO = LoginVO()
registerVO.registerFirstName = request.form['registerFirstName']
registerVO.registerLastName = request.form['registerLastName']
registerVO.registerGender = request.form['registerGender']
registerVO.registerAddress = request.form['registerAddress']
registerVO.registerPincode = request.form['registerPincode']
registerVO.registerContact = request.form['registerContact']
loginVO.loginEmailId = request.form['registerEmailId']
loginVO.loginPassword = request.form['loginPassword']
loginVO.loginId = registerVO.register_LoginId = request.form['loginId']
loginDict = loginDAO.searchLoginIddata(loginVO)
if loginVO.loginPassword == loginDict[0]['loginPassword']:
loginDAO.updateProfile(loginVO)
registerDAO.updateProfile(registerVO)
return redirect(url_for('loadProfile'))
else:
session['error'] = "*wrong password Please enter again"
return redirect(url_for('loadEditprofile'))
except:
return render_template('admin/login.html')
def insertRegister():
try:
firstname = request.form['firstname']
lastname = request.form['lastname']
username = request.form['username']
password = request.form['password']
registerVO = RegisterVO()
registerDAO = RegisterDAO()
loginVO = LoginVO()
loginDAO = LoginDAO()
registerVO.registerFirstname = firstname
registerVO.registerLastname = lastname
registerVO.registerUsername = username
registerVO.registerPassword = password
loginVO.loginUsername = username
loginVO.loginPassword = password
registerDAO.insertRegister(registerVO)
loginDAO.insertRegister(loginVO)
return render_template('Login.html')
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
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'] == 'unactive':
msg = 'You are BLOCKED.'
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 = True
if loginRole == 'admin':
return redirect(url_for('adminLoadDashboard'))
elif loginRole == 'user':
return redirect(url_for('userLoadDashboard'))
except Exception as ex:
print(ex)
def resetPPassword():
loginDAO = LoginDAO()
loginVO = LoginVO()
forgotPassword = request.form['forgotPassword']
loginVO.forgotPassword = forgotPassword
searchPasswordDict = loginDAO.searchForgotPassword(loginVO)
# if len(searchPasswordDict)==0:
# flash('Invalid Email !','danger')
# return redirect(url_for('forgotPassword'))
# else:
loginVO.loginPassword = ''.join((random.choice(string.ascii_letters + string.digits)) for x in range(8))
print(loginVO.pwdDict)
print(searchPasswordDict)
print("registerPassword="******"*****@*****.**"
toaddr = loginVO.forgotPassword
msg = MIMEMultipart()
msg['From'] = fromaddr
msg['To'] = toaddr
msg['Subject'] = "PYTHON PASSWORD"
msg.attach(MIMEText(loginVO.loginPassword, 'plain'))
try:
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(fromaddr, "BHAIbhai4725")
text = msg.as_string()
server.sendmail(fromaddr, toaddr, text)
server.quit()
except:
return
loginDAO.resetPassword(loginVO)
flash('Password Sent,Check Your Email','success')
return redirect(url_for('loadLogin'))
# return render_template('admin/forgotPassword.html')
def checkLogin():
loginVO = LoginVO()
loginDAO = LoginDAO()
loginVO.loginEmailId = request.form['loginEmailId']
loginVO.loginPassword = request.form['loginPassword']
loginDict = loginDAO.searchLogin(loginVO)
if len(loginDict) == 0:
return render_template('admin/login.html',
loginemailIderror="*you are not registered")
elif loginVO.loginPassword != loginDict[0]['loginPassword']:
return render_template(
'admin/login.html',
loginPassworderror="*Incorrect email or password")
elif loginDict[0]['loginRole'] == 'admin':
session['loginRole'] = loginDict[0]['loginRole']
session['loginId'] = loginDict[0]['loginId']
return redirect(url_for('loadIndex'))
else:
registerVO = RegisterVO()
registerDAO = RegisterDAO()
session['loginRole'] = loginDict[0]['loginRole']
session['loginId'] = registerVO.register_LoginId = loginDict[0][
'loginId']
firstnameDict = registerDAO.findFirstName(registerVO)
session['registerFirstname'] = firstnameDict[0]['registerFirstname']
return redirect(url_for("loadIndex"))
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 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 checkOTP():
loginVO = LoginVO()
otpVo = OtpVO()
otpDAO = OtpDAO()
otpVo.otp = request.form['otp']
otpVo.emailId = session['emailid']
otpVo.otpActiveStatus = 'deactive'
otpDict = otpDAO.searchOtp(otpVo)
print otpDict
if len(otpDict) == 0:
return render_template('admin/getOTP.html', otperror="*incorrect otp")
else:
if (otpDict[0]['otp'] == otpVo.otp
and otpDict[0]['emailId'] == otpVo.emailId):
loginVO.loginPassword = ''.join(
(random.choice(string.ascii_letters + string.digits))
for x in range(8))
loginVO.loginEmailId = otpVo.emailId = session['emailid']
fromaddr = "*****@*****.**"
toaddr = loginVO.loginEmailId
msg = MIMEMultipart()
msg['From'] = fromaddr
msg['To'] = toaddr
msg['Subject'] = "your password"
msg.attach(MIMEText(loginVO.loginPassword, 'plain'))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(fromaddr, "iamdarshil")
text = msg.as_string()
server.sendmail(fromaddr, toaddr, text)
server.quit()
otpDAO.updatePassword(loginVO)
otpDAO.updateOtpstatus(otpVo)
else:
return render_template('admin/getOTP.html',
incorrectotp="incorrect otp")
return redirect(url_for('loadLogin'))
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 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 insertRegister():
registerDAO = RegisterDAO()
registerVO = RegisterVO()
loginDAO = LoginDAO()
loginVO = LoginVO()
loginVO.loginEmailId = request.form['registerEmailId']
loginDict = loginDAO.searchLoginByEmailId(loginVO)
if loginDict:
flash('EmailAddress Is Already Taken', 'success')
return render_template('admin/register.html')
registerVO.registerFirstName = request.form['registerFirstName']
registerVO.registerLastName = request.form['registerLastName']
registerVO.registerContact = request.form['registerContact']
registerVO.registerDate, registerVO.registerTime = str(
datetime.now()).split(' ')
registerVO.registerActiveStatus = 'active'
loginVO.loginRole = 'user'
loginVO.loginActiveStatus = 'active'
loginVO.loginPassword = '******'
loginDAO.insertLogin(loginVO)
loginDict = loginDAO.getMaxId()
registerVO.register_LoginId = loginDict[0]['MAX(loginId)']
registerDAO.insertRegister(registerVO)
loginDict = loginDAO.searchLoginByEmailId(loginVO)
session['loginRole'] = loginDict[0]['loginRole']
session['loginId'] = loginDict[0]['loginId']
fromaddr = "*****@*****.**"
toaddr = loginVO.loginEmailId
msg = MIMEMultipart()
msg['From'] = fromaddr
msg['To'] = toaddr
msg['Subject'] = "welcome to lemanhouse"
msg.attach(MIMEText(loginVO.loginPassword, 'plain'))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login("*****@*****.**", "HeisenBerg_1102008")
text = msg.as_string()
server.sendmail(fromaddr, toaddr, text)
server.quit()
return redirect(url_for('home'))
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 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 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 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 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 validateLogin():
try:
print("*******************")
loginVO = LoginVO()
loginDAO = LoginDAO()
username = request.form['username']
password = request.form['password']
print(username)
print(password)
loginVO.loginUsername = username
loginVO.loginPassword = password
loginVOList = loginDAO.validateLogin(loginVO)
loginDictList = [i.as_dict() for i in loginVOList]
lenLoginDictList = len(loginDictList)
print(loginDictList)
if lenLoginDictList == 0:
msg = 'Username and Password is Incorrect !'
return render_template('Login.html', error=msg)
else:
for i in loginDictList:
if i['loginUsername'] == username and i[
'loginPassword'] == password:
return render_template('index.html')
else:
msg1 = 'You are Inactive user !'
return render_template('Login.html', error=msg1)
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 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 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 insertRegister():
registerDAO=RegisterDAO()
registerVO=RegisterVO()
loginDAO=LoginDAO()
loginVO=LoginVO()
registerVO.registerOrganizationname=request.form['registerOrganizatonname']
registerVO.registerContact=request.form['registerContact']
registerVO.registerCategory=request.form['registerCategory']
registerVO.registerAddress=request.form['registerAddress']
registerVO.register_LoginId = str(loginDAO.searchLoginId(loginVO)[0].values()[0])
loginVO.loginEmail = request.form['registerEmail']
loginVO.loginPassword = ''.join((random.choice(string.ascii_letters + string.digits)) for x in range(8))
loginVO.loginRole='user'
print(loginVO.loginEmail)
loginDict = loginDAO.searchLogin(loginVO)
if len(loginDict) == 0:
print("registerPassword="******"*****@*****.**"
toaddr = loginVO.loginEmail
msg = MIMEMultipart()
msg['From'] = fromaddr
msg['To'] = toaddr
msg['Subject'] = "PYTHON PASSWORD"
msg.attach(MIMEText(loginVO.loginPassword, 'plain'))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(fromaddr, "BHAIbhai4725")
text = msg.as_string()
server.sendmail(fromaddr, toaddr, text)
server.quit()
loginDAO.insertLogin(loginVO)
registerDAO.insertRegister(registerVO)
return redirect(url_for('loadLogin'))
else:
flash('Email already exist !', 'danger')
return redirect(url_for('loadRegister'))
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)
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:
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 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 insertRegister():
registerVO = RegisterVO()
registerDAO = RegisterDAO()
loginVO = LoginVO()
loginDAO = LoginDAO()
alphabet = string.ascii_letters + string.digits
password = ''.join(choice(alphabet) for i in range(8))
registerVO.registerName = request.form['registerName']
registerVO.registerAddress = request.form['registerAddress']
registerVO.registerGender = request.form['registerGender']
registerVO.registerArea = request.form['registerArea']
registerVO.registerCity = request.form['registerCity']
registerVO.registerPincode = request.form['registerPincode']
registerVO.registerMobileno = request.form['registerMobileno']
registerVO.registerEmail = request.form['registerEmail']
registerVO.registerActivestatus = 'active'
print("Hello i am Seller")
loginVO.loginEmail = request.form['registerEmail']
loginVO.loginPassword = password
loginVO.loginRole = 'seller'
loginVO.loginActivestatus = 'active'
print('EMAIL', loginVO.loginEmail)
print("password", loginVO.loginPassword)
print("role", loginVO.loginRole)
print("status", loginVO.loginActivestatus)
loginDict = loginDAO.loadlogin(loginVO)
print(loginDict)
fromaddr = "*****@*****.**" #email
msg = MIMEMultipart()
msg['From'] = fromaddr
msg['To'] = loginVO.loginEmail
msg['Subject'] = "PASSWORD FOR YOUR LOGIN"
msg.attach(MIMEText(loginVO.loginPassword, 'plain'))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
passw = "hardik@4693" #password
server.login(fromaddr, passw)
text = msg.as_string()
server.sendmail(fromaddr, loginVO.loginEmail, text)
server.quit()
loginDict = loginDAO.searchloginId()
print(loginDict)
registerVO.register_loginId = str(loginDict)
registerDAO.insertRegister(registerVO)
return render_template('admin/login.html')
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 insertRegister():
registerDAO = RegisterDAO()
registerVO = RegisterVO()
loginDAO = LoginDAO()
loginVO = LoginVO()
loginVO.loginEmailId = request.form['registerEmailId']
registerDict = loginDAO.searchLogin(loginVO)
if len(registerDict) > 0:
return render_template('user/register.html',
errorreg="*already registered")
else:
registerVO.registerFirstName = request.form['registerFirstName']
registerVO.registerLastName = request.form['registerLastName']
registerVO.registerGender = request.form['registerGender']
registerVO.registerAddress = request.form['registerAddress']
registerVO.registerPincode = request.form['registerPincode']
registerVO.registerContact = request.form['registerContact']
registerVO.registerDate, registerVO.registerTime = str(
datetime.now()).split(' ')
registerVO.registerActiveStatus = 'active'
loginVO.loginRole = 'user'
loginVO.loginActiveStatus = 'active'
loginVO.loginPassword = ''.join(
(random.choice(string.ascii_letters + string.digits))
for x in range(8))
fromaddr = "*****@*****.**"
toaddr = loginVO.loginEmailId
msg = MIMEMultipart()
msg['From'] = fromaddr
msg['To'] = toaddr
msg['Subject'] = "your password"
msg.attach(MIMEText(loginVO.loginPassword, 'plain'))
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(fromaddr, "iamdarshil")
text = msg.as_string()
server.sendmail(fromaddr, toaddr, text)
server.quit()
loginDAO.insertLogin(loginVO)
loginDict = loginDAO.searchLoginId()
registerVO.register_LoginId = loginDict[0]['max(loginId)']
registerDAO.insertRegister(registerVO)
return redirect(url_for('loadLogin'))
return redirect(url_for('loadLogin'))