def edit_assigned_dept_role(role_email_id): if request.method == "POST": password = request.form['password'] employee_email_id = request.form['employee_email_id'] employee_assigned_post_date = request.form[ 'employee_assigned_post_date'] try: cur = conn.cursor() cur.execute( "Update employees_holding_post_associated_with_department set password = %s , employee_email_id = %s , employee_assigned_post_date = %s where role_email_id = %s", (password, employee_email_id, employee_assigned_post_date, role_email_id)) conn.commit() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return redirect(url_for('system_admin.show_assigned_dept_role')) try: cur = conn.cursor() cur.execute("SELECT * FROM employees") employees_data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return render_template('system_admin/edit_assigned_dept_role.html', role_email_id=role_email_id, employees_data=employees_data)
def add_non_dept_roles(): if request.method == "POST": role_name = request.form['role_name'] print(role_name) try: cur = conn.cursor() cur.execute( "INSERT INTO roles_not_associated_with_department (role_name) VALUES (%s);", (role_name, )) conn.commit() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() try: cur = conn.cursor() cur.execute("SELECT * FROM roles_not_associated_with_department") role_data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return render_template('system_admin/non_dept_roles.html', role_data=role_data)
def CRD_departments(): if request.method == "POST": department = request.form['department'] print(department) try: cur = conn.cursor() cur.execute( "INSERT INTO departments (department_name, start_date) VALUES (%s, CURRENT_DATE);", (department, )) conn.commit() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() try: cur = conn.cursor() cur.execute("SELECT * FROM departments") data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return render_template('system_admin/CRD_departments.html', data=data)
def RD_employees(): try: cur = conn.cursor() cur.execute("SELECT * FROM employees") data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return render_template('system_admin/RD_employees.html', data=data)
def delete_employee(username): print(username) try: cur = conn.cursor() cur.execute("DELETE FROM employees WHERE username = %s", [username]) except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return redirect(url_for('system_admin.RD_employees'))
def show_departments(): try: cur = conn.cursor() cur.execute("SELECT * FROM departments") data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return render_template('/system_admin/show_departments.html', data=data)
def assign_emp_non_dept_role(): if request.method == "POST": role_name = request.form['role_name'] post_email_id = request.form['post_email_id'] password = request.form['password'] username = request.form['username'] start_date = request.form['start_date'] print(username) print(password) print(post_email_id) try: cur = conn.cursor() cur.execute( "INSERT INTO employees_holding_post_not_associated_with_department (post_email_id, password, username, start_date, role_name) VALUES (%s, %s, %s, %s ,%s);", ( post_email_id, password, username, start_date, role_name, )) conn.commit() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() try: cur = conn.cursor() cur.execute("SELECT * FROM roles_not_associated_with_department") role_data = cur.fetchall() cur.execute("SELECT * FROM users") user_data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return render_template('system_admin/assign_emp_non_dept_role.html', role_data=role_data, user_data=user_data)
def delete_department(department_name): print(department_name) try: cur = conn.cursor() cur.execute("DELETE FROM departments WHERE department_name = %s", [department_name]) except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return redirect(url_for('system_admin.CRD_departments'))
def show_all_roles(): try: cur = conn.cursor() cur.execute("SELECT * FROM roles_not_associated_with_department") role_data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() try: cur = conn.cursor() cur.execute("SELECT * FROM roles_associated_with_department") department_role_data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return render_template('/system_admin/show_roles.html', role_data=role_data, department_role_data=department_role_data)
def assign_emp_dept_role(): if request.method == "POST": role_email_id = request.form['role_email_id'] employee_email_id = request.form['employee_email_id'] password = request.form['password'] department = request.form['department'] role_name = request.form['role_name'] employee_assigned_post_date = request.form[ 'employee_assigned_post_date'] print(employee_assigned_post_date) print(role_name) print(role_email_id) try: cur = conn.cursor() cur.execute( "INSERT INTO employees_holding_post_associated_with_department (role_email_id, password, employee_email_id, department, role_name, employee_assigned_post_date) VALUES (%s, %s, %s, %s, %s, %s);", (role_email_id, password, employee_email_id, department, role_name, employee_assigned_post_date)) conn.commit() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() try: cur = conn.cursor() cur.execute("SELECT * FROM roles_associated_with_department") role_data = cur.fetchall() cur.execute("SELECT * FROM employees") employees_data = cur.fetchall() cur.execute("SELECT * FROM departments") departments_data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return render_template('system_admin/assign_emp_dept_role.html', role_data=role_data, employees_data=employees_data, departments_data=departments_data)
def delete_dept_role(role_name): print(role_name) try: cur = conn.cursor() cur.execute( "DELETE FROM roles_associated_with_department WHERE role_name = %s", [role_name]) except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return redirect(url_for('system_admin.add_dept_roles'))
def show_assigned_dept_role(): try: cur = conn.cursor() cur.execute( "SELECT * FROM employees_holding_post_associated_with_department") assigned_role_data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return render_template('system_admin/show_assigned_dept_role.html', assigned_role_data=assigned_role_data)
def edit_assigned_role(post_email_id): if request.method == "POST": password = request.form['password'] username = request.form['username'] start_date = request.form['start_date'] print(username) print(password) print(post_email_id) print(start_date) print(type(start_date)) start_date = datetime.strptime(start_date, '%Y-%m-%d').date() print(start_date) print(type(start_date)) try: cur = conn.cursor() cur.execute( "Update employees_holding_post_not_associated_with_department set password = %s , username = %s , start_date = %s where post_email_id = %s", (password, username, start_date, post_email_id)) conn.commit() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return redirect(url_for('system_admin.show_assigned_role')) try: cur = conn.cursor() cur.execute("SELECT * FROM users") user_data = cur.fetchall() except (Exception, psycopg2.DatabaseError) as error: print(error) cur.execute('rollback') cur.close() return render_template('system_admin/edit_assigned_role.html', post_email_id=post_email_id, user_data=user_data)