public EmployeeLeaveCredits updateEmployeeLeaveCredits(Employee employee, LeaveCredits leaveCredits)
{
sqlCon.Open();
sqlCmd.CommandText = "UPDATE LeaveCredits SET vacationLeaveCredit = @vacationLeaveCredit, "
+ "sickLeaveCredit =@sickLeaveCredit , paternityLeaveCredit =@paternityLeaveCredit, "
+ "emergencyLeaveCredit =@emergencyLeaveCredit , birthdayLeaveCredit =@birthdayLeaveCredit , "
+ "bereavementLeaveCredit =@bereavementLeaveCredit FROM EmployeeLeaveCredits INNER JOIN "
+ "LeaveCredits ON EmployeeLeaveCredits.leaveCreditsId = LeaveCredits.id "
+ "WHERE EmployeeLeaveCredits.employeeId = @employeeNumber";
sqlCmd.Parameters.AddWithValue("@employeeNumber", employee.id);
sqlCmd.Parameters.AddWithValue("@vacationLeaveCredit", leaveCredits.vacationLeaveCredits);
sqlCmd.Parameters.AddWithValue("@sickLeaveCredit", leaveCredits.sickLeaveCredits);
sqlCmd.Parameters.AddWithValue("@paternityLeaveCredit", leaveCredits.paternityLeaveCredits);
sqlCmd.Parameters.AddWithValue("@emergencyLeaveCredit", leaveCredits.emergencyLeaveCredits);
sqlCmd.Parameters.AddWithValue("@birthdayLeaveCredit", leaveCredits.birthdayLeaveCredits);
sqlCmd.Parameters.AddWithValue("@bereavementLeaveCredit", leaveCredits.bereavementLeaveCredits);
sqlCmd.ExecuteNonQuery();
sqlCon.Close();
EmployeeLeaveCredits employeeLeaveCredits = new EmployeeLeaveCredits();
employeeLeaveCredits.employee = employee;
employeeLeaveCredits.leaveCredits = leaveCredits;
return(employeeLeaveCredits);
}
public EmployeeLeaveCredits createEmployeeLeaveCredits(Employee employee)
{
LeaveCredits leaveCredits = new LeaveCredits();
leaveCredits.vacationLeaveCredits = VACATION_LEAVE_CREDITS;
leaveCredits.sickLeaveCredits = SICK_LEAVE_CREDITS;
leaveCredits.paternityLeaveCredits = PATERNITY_LEAVE_CREDITS;
leaveCredits.emergencyLeaveCredits = EMERGENCY_LEAVE_CREDITS;
leaveCredits.birthdayLeaveCredits = BIRTHDAY_LEAVE_CREDITS;
leaveCredits.bereavementLeaveCredits = BEREAVEMENT_LEAVE_CREDITS;
sqlCon.Open();
sqlCmd.CommandText = "INSERT INTO LeaveCredits (vacationLeaveCredit, sickLeaveCredit, "
+ "paternityLeaveCredit, emergencyLeaveCredit, birthdayLeaveCredit, bereavementLeaveCredit) "
+ "VALUES (@vacationLeaveCredit, @sickLeaveCredit, "
+ "@paternityLeaveCredit, @emergencyLeaveCredit, @birthdayLeaveCredit, @bereavementLeaveCredit); "
+ "SELECT CAST(scope_identity() AS int)";
sqlCmd.Parameters.AddWithValue("@vacationLeaveCredit", leaveCredits.vacationLeaveCredits);
sqlCmd.Parameters.AddWithValue("@sickLeaveCredit", leaveCredits.sickLeaveCredits);
sqlCmd.Parameters.AddWithValue("@paternityLeaveCredit", leaveCredits.paternityLeaveCredits);
sqlCmd.Parameters.AddWithValue("@emergencyLeaveCredit", leaveCredits.emergencyLeaveCredits);
sqlCmd.Parameters.AddWithValue("@birthdayLeaveCredit", leaveCredits.birthdayLeaveCredits);
sqlCmd.Parameters.AddWithValue("@bereavementLeaveCredit", leaveCredits.bereavementLeaveCredits);
leaveCredits.id = (int)sqlCmd.ExecuteScalar();
sqlCon.Close();
EmployeeLeaveCredits employeeLeaveCredits = createEmployeeLeaveCredits(employee, leaveCredits);
return(null);
}
private EmployeeLeaveCredits createEmployeeLeaveCredits(Employee employee, LeaveCredits leaveCredits)
{
EmployeeLeaveCredits employeeLeaveCredits = new EmployeeLeaveCredits();
sqlCon.Open();
sqlCmd.CommandText = "INSERT INTO EmployeeLeaveCredits (employeeId, leaveCreditsId) "
+ "VALUES (@employeeId, @leaveCreditsId);SELECT CAST(scope_identity() AS int)";
sqlCmd.Parameters.AddWithValue("@employeeId", employee.id);
sqlCmd.Parameters.AddWithValue("@leaveCreditsId", leaveCredits.id);
employeeLeaveCredits.id = (int)sqlCmd.ExecuteScalar();
employeeLeaveCredits.employee = employee;
employeeLeaveCredits.leaveCredits = leaveCredits;
sqlCon.Close();
return(employeeLeaveCredits);
}
public Request updateRequestStatusById(int requestId, string status)
{
Request request = fetchById(requestId);
sqlCon.Open();
sqlCmd.CommandText = "UPDATE Request SET status = @status WHERE (id = @id);";
sqlCmd.Parameters.AddWithValue("@status", status);
sqlCmd.Parameters.AddWithValue("@id", requestId);
sqlCmd.ExecuteNonQuery();
sqlCon.Close();
if (status == "approved")
{
EmployeeServiceInterface employeeService = new EmployeeService();
Employee employee = employeeService.fetchEmployeeById(request.employee.id);
LeaveCreditServiceInterface leaveCreditsService = new LeaveCreditService();
LeaveCredits leaveCredits = leaveCreditsService.fetchLeaveCreditsByEmployee(employee);
Console.WriteLine("leave" + request.name);
if (request.name.Equals("Vacation Leave"))
{
leaveCredits.vacationLeaveCredits -= 1;
}
else if (request.name.Equals("Sick Leave"))
{
leaveCredits.sickLeaveCredits -= 1;
}
else if (request.name.Equals("Bereavement Leave"))
{
leaveCredits.bereavementLeaveCredits -= 1;
}
else if (request.name.Equals("Paternity Leave"))
{
leaveCredits.paternityLeaveCredits -= 1;
}
else if (request.name.Equals("Emergency Leave"))
{
leaveCredits.emergencyLeaveCredits -= 1;
}
else if (request.name.Equals("Birthday Leave"))
{
leaveCredits.birthdayLeaveCredits -= 1;
}
EmployeeLeaveCredits employeeLeaveRequest = leaveCreditsService.updateEmployeeLeaveCredits(employee, leaveCredits);
}
return(request);
}
public Employee saveEmployee(Employee employee)
{
UserServiceInterface userService = new UserService();
User user = userService.createUser(employee.userAccount);
if (user.id > 0)
{
sqlCon.Open();
sqlCmd.CommandText = "INSERT into [Employee] (employeeId, userAccountId, fullName, "
+ "birthDate, gender, civilStatus, dependents, address, contactNumber, tin, "
+ "sssId, philHealthId, pagIbigId, dateEmployed, jobPositionId) "
+ "values(@employeeId, @userAccountId, @fullName, "
+ "@birthDate, @gender, @civilStatus, @dependents, "
+ "@address, @contactNumber, @tin, @sssId, @philHealthId, @pagIbigId, "
+ "@dateEmployed, @jobPositionId);SELECT CAST(scope_identity() AS int)";
sqlCmd.Parameters.AddWithValue("@employeeId", employee.employeeId);
sqlCmd.Parameters.AddWithValue("@userAccountId", user.id);
sqlCmd.Parameters.AddWithValue("@fullName", employee.fullName);
sqlCmd.Parameters.AddWithValue("@birthDate", employee.birthDate);
sqlCmd.Parameters.AddWithValue("@gender", employee.gender);
sqlCmd.Parameters.AddWithValue("@civilStatus", employee.civilStatus);
sqlCmd.Parameters.AddWithValue("@dependents", employee.dependents);
sqlCmd.Parameters.AddWithValue("@address", employee.address);
sqlCmd.Parameters.AddWithValue("@contactNumber", employee.contactNumber);
sqlCmd.Parameters.AddWithValue("@tin", employee.tin);
sqlCmd.Parameters.AddWithValue("@sssId", employee.sssId);
sqlCmd.Parameters.AddWithValue("@philHealthId", employee.philHealthId);
sqlCmd.Parameters.AddWithValue("@pagIbigId", employee.pagIbigId);
sqlCmd.Parameters.AddWithValue("@dateEmployed", employee.dateEmployed);
sqlCmd.Parameters.AddWithValue("@jobPositionId", employee.jobPosition.id);
employee.id = (int)sqlCmd.ExecuteScalar();
sqlCon.Close();
LeaveCreditServiceInterface leaveCreditsService = new LeaveCreditService();
EmployeeLeaveCredits employeeLeaveCredits = leaveCreditsService.createEmployeeLeaveCredits(employee);
MiscellaneousServiceInterface miscellaneousService = new MiscellaneousService();
Miscellaneous thirteenMonthBenefit = miscellaneousService.createThirteenMonthBenefit(employee);
return(employee);
}
return(null);
}
private void resetLeaveCreditsButton_Click(object sender, EventArgs e)
{
hideErrorMessage();
if (!selectAllCheckBox.Checked)
{
EmployeeControllerInterface employeeController = new EmployeeController();
Employee employee = employeeController.fetchEmployeeByUsername(usernameOrEmployeeId.Text);
if (employee == null || employee.Equals(""))
{
showErrorMessage("Please input a valid username.");
return;
}
LeaveCreditsControllerInteface leaveCreditsController = new LeaveCreditsController();
EmployeeLeaveCredits employeeLeaveCredits = leaveCreditsController.resetEmployeeLeaveCredits(employee);
showErrorMessage("Successfully created payroll to user: "******"admin")
{
EmployeeControllerInterface employeeController = new EmployeeController();
Employee employee = employeeController.fetchEmployeeByUsername(user.username);
if (employee == null || employee.Equals(""))
{
showErrorMessage("Please input a valid username.");
return;
}
PayrollControllerInterface payslipController = new PayrollController();
payslipController.createPayslip(startDatePeriod.Value, endDatePeriod.Value, employee);
}
}
selectAllCheckBox.Checked = false;
showErrorMessage("Successfully create payroll to all users");
}
}
