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)