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():
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 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'))
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 userInsertRegister():
try:
loginVO = LoginVO()
loginDAO = LoginDAO()
registerVO = RegisterVO()
registerDAO = RegisterDAO()
loginUsername = request.form['loginUsername']
loginPassword = ''.join(
(random.choice(string.ascii_letters + string.digits))
for x in range(8))
registerFirstname = request.form['registerFirstname']
registerLastname = request.form['registerLastname']
registerGender = request.form['registerGender']
registerAddress = request.form['registerAddress']
registerContactNumber = request.form['registerContactNumber']
print("loginPassword="******"*****@*****.**"
receiver = loginUsername
msg = MIMEMultipart()
msg['From'] = sender
msg['To'] = receiver
msg['Subject'] = "PYTHON PASSWORD"
msg.attach(MIMEText(loginPassword, 'plain'))
print(loginPassword, "loginpassword")
server = smtplib.SMTP('smtp.gmail.com', 587)
server.starttls()
server.login(sender, "9925646618")
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.registerGender = registerGender
registerVO.registerAddress = registerAddress
registerVO.registerContactNumber = registerContactNumber
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']
registerGender = request.form['registerGender']
registerAddress = request.form['registerAddress']
registerContactNumber = request.form['registerContactNumber']
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, "9925646618")
text = msg.as_string()
server.sendmail(sender, receiver, text)
server.quit()
loginVO.loginUsername = loginUsername
loginVO.loginPassword = loginPassword
loginDAO.adminUpdateUser(loginVO)
registerVO.registerId = registerId
registerVO.registerFirstname = registerFirstname
registerVO.registerLastname = registerLastname
registerVO.registerGender = registerGender
registerVO.registerAddress = registerAddress
registerVO.registerContactNumber = registerContactNumber
registerDAO.updateRegister(registerVO)
return redirect(url_for('userLoadDashboard'))
else:
return adminLogoutSession()
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 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)
