def employees():

    all_records = DepartmentModel.fetch_department_records()
    all_employee_records = EmployeeModel.fetch_employee_records()

    if request.method == 'POST':
        employee_name = request.form['fullName']
        department_name = request.form['department']
        gender_name = request.form['gender']
        email_name = request.form['email']
        phoneNumber_name = request.form['phoneNumber']
        idNumber_name = request.form['idNumber']
        KRApin_name = request.form['KRApin']
        salary_name = request.form['salary']
        benefits_name = request.form['benefits']

        if EmployeeModel.check_employee_exist(idNumber_name):
            print('existing record')
        else:
            try:
                employee_record = EmployeeModel(full_name=employee_name,
                                                gender=gender_name,
                                                email=email_name,
                                                phone_number=phoneNumber_name,
                                                national_id=idNumber_name,
                                                kra_pin=KRApin_name,
                                                salary=salary_name,
                                                benefits=benefits_name,
                                                department_id=department_name)
                employee_record.create_record()
                print('Successfully added')
                return redirect(url_for('employees'))

            except Exception as e:
                print("Unable to add record")

    return render_template("employees.html",
                           mydepartments=all_records,
                           myemployees=all_employee_records)
Exemple #2
0
def employees():
    allDepts = DepartmentModel.fetch_all_departments()
    if request.method == 'POST':
        name = request.form['empName']
        email = request.form['email']
        phone = request.form['phonenum']
        natId = request.form['nationalId']
        krapin = request.form['kra']
        deptname = request.form['department']
        if EmployeeModel.check_employee_exist(natId):
            print('Employee already exist')
        else:
            emp = EmployeeModel(fullName=name,
                                email=email,
                                phoneNumber=phone,
                                nationalId=natId,
                                KRAPin=krapin,
                                dept_id=deptname)
            emp.create()
            print('added')
            return redirect(url_for('employees'))

    return render_template('employees.html', depts=allDepts)