def facultyadd():
try:
if session['type']!="admin":
return redirect(url_for("logout"))
except:
return redirect(url_for("logout"))
res=request.form
id,name,address,phone,date=res['FacultyID'],res["FacultyName"],res['Address'],res['FacultyPhone'],res['date']
email,pwd,rpwd=res['email'],res['password'],res['repassword']
error,success="",""
if pwd!=rpwd:
error="Passwords Didn't Match"
else:
db_conn=mysql.connector.connect(host = "localhost", port = 3306, user = "******",password="******", database = "pesuapp")
cur=db_conn.cursor()
A1=Admin(db_conn,session['email'])
k=A1.AddFaculty(db_conn,email,id,name,address,phone,date)
if k[0]:
success=k[1]
acct_type="faculty"
passw=sha256_crypt.hash(pwd)
query="INSERT INTO users(`password`,account_type,email) VALUES(%s,%s,%s)"
cur.execute(query,(passw,acct_type,email,))
db_conn.commit()
else:
error=k[1]
db_conn=mysql.connector.connect(host = "localhost", port = 3306, user = "******",password="******", database = "pesuapp")
cur=db_conn.cursor()
query="SELECT FacultyID,`Name` FROM faculty"
cur.execute(query)
res=cur.fetchall()
if success:
return render_template("admin_faculty.html",faculty=res,success="Faculty Successfully Added")
return render_template("admin_faculty.html",faculty=res,error=error)
