def add_employee():
name = request.form['name']
email = request.form['email']
addr = request.form['addr']
cmpy = request.form['cmpy']
Employee.add_employee(name, email, addr, cmpy)
flash("Employee added successfully!!")
return redirect(url_for('Index'))
def update_employee():
id = request.form.get('id')
name = request.form['name']
email = request.form['email']
addr = request.form['addr']
cmpy = request.form['cmpy']
Employee.update_employee(id, name, email, addr, cmpy)
flash("Employee Updated Successfully!!")
return redirect(url_for('Index'))
def employee_search(form):
ssn, firstname, lastname = form.ssn.data, form.firstname.data, form.lastname.data
if ssn == '':
ssn = '%'
if firstname == '':
firstname = '%'
if lastname == '':
lastname = '%'
# query parameters:
conn = mysql.connect()
cursor = conn.cursor()
cursor.execute(
'select E.employeeid, E.startdate, E.ssn, E.firstname, E.lastname, E.address, E.city, E.state, E.zipcode, E.telephone, E.email from Employee E where E.ssn like %s and E.firstname like %s and E.lastname like %s',
(ssn, firstname, lastname))
data = cursor.fetchall()
employees = []
for d in data:
employee = Employee(employeeid=d[0],
startdate=d[1],
ssn=d[2],
firstname=d[3],
lastname=d[4],
address=d[5],
city=d[6],
state=d[7],
zipcode=d[8],
telephone=d[9],
email=d[10])
employees.append(employee)
return employees
def Index():
all_employees = Employee.get_all_employees()
print(all_employees)
all_employees_salaries = EmployeeSal.get_all_employees_salaries()
return render_template("index.html",
employees=all_employees,
employees_salary=all_employees_salaries)
def add_emp_salary():
emp_id = request.form['emp_id']
salary = request.form['salary']
currency = request.form['currency']
pay_type = request.form['pay_type']
pay_cycle = request.form['pay_cycle']
if Employee.exists(emp_id):
EmployeeSal.add_employee_salary(emp_id, salary, currency, pay_type,
pay_cycle)
flash("Employee Salary added successfully!!")
else:
flash("Employee Id doesn't exists")
return redirect(url_for('Index'))
def employeeid_to_object(employeeid):
conn = mysql.connect()
cursor = conn.cursor()
cursor.execute(
'Select E.EmployeeId, E.SSN, E.Firstname, E.Lastname, E.Address, E.City, E.State, E.ZipCode, E.Telephone, E.email, E.startdate, E.HourlyRate from Employee E where E.employeeid =%s',
(employeeid))
data = cursor.fetchone()
print(data)
if data is None:
return None
employee = Employee(employeeid=data[0],
ssn=data[1],
firstname=data[2],
lastname=data[3],
address=data[4],
city=data[5],
state=data[6],
zipcode=data[7],
telephone=data[8],
email=data[9],
startdate=data[10],
hourlyrate=data[11])
return employee
from Models.Employee import *
from Models.Manager import *
# Test file used to test my methods as I go along
emp_000 = Employee('Alejandro', 'Penaloza', 'Software', 100000)
print(emp_000.firstName)
# manager_000 = Manager('Alex', 'Penaloza', 'Software', 120000, 'Software', [emp_000])
# manager_000.add_employee(emp_000)
# manager_000.print_employees()
def delete_employee(id):
Employee.delete_employee(id)
if EmployeeSal.exists(id):
EmployeeSal.delete_employee_salary(id)
flash("Employee Deleted Successfully!!")
return redirect(url_for('Index'))
def get_employee(id):
employee = Employee.exists(id)
return employee
def get_employees():
all_employees = Employee.get_all_employees()
return render_template("index.html", employees=all_employees)
def delete_all_records():
Employee.delete_all_records()
EmployeeSal.delete_all_salary_records()
# flash("Employee added successfully!!")
return redirect(url_for('Index'))