public Payslip fetchPayslipById(int payslipId)
{
Payslip payslip = new Payslip();
Employee employee = new Employee();
sqlCon.Open();
sqlCmd.CommandText = "SELECT * From Payroll WHERE id = @payslipId";
sqlCmd.Parameters.AddWithValue("@payslipId", payslipId);
sqlDataReader = sqlCmd.ExecuteReader();
if (sqlDataReader.HasRows)
{
while (sqlDataReader.Read())
{
payslip.id = Int32.Parse(sqlDataReader["id"].ToString());
employee.id = Int32.Parse(sqlDataReader["employeeId"].ToString());
payslip.employee = employee;
payslip.dateCreated = Convert.ToDateTime(sqlDataReader["dateCreated"].ToString());
payslip.startDatePeriod = Convert.ToDateTime(sqlDataReader["startDate"].ToString());
payslip.endDatePeriod = Convert.ToDateTime(sqlDataReader["endDate"].ToString());
payslip.basePay = Convert.ToDecimal(sqlDataReader["basePay"].ToString());
payslip.taxDeduction = Convert.ToDecimal(sqlDataReader["taxDeduction"].ToString());
payslip.totalBenefits = Convert.ToDecimal(sqlDataReader["totalBenefits"].ToString());
payslip.totalDeduction = Convert.ToDecimal(sqlDataReader["totalDeduction"].ToString());
payslip.netPay = Convert.ToDecimal(sqlDataReader["netPay"].ToString());
payslip.sssDeduction = Convert.ToDecimal(sqlDataReader["sssDeduction"].ToString());
payslip.pagIbigDeduction = Convert.ToDecimal(sqlDataReader["pagIbigDeduction"].ToString());
payslip.philHealthDeduction = Convert.ToDecimal(sqlDataReader["philHealthDeduction"].ToString());
}
}
sqlCmd.Parameters.Clear();
sqlCon.Close();
List <int> requestIds = fetchRequestIdsByPayslipId(payslip.id);
List <int> miscellaneousIds = fetchMiscellaneousIdsByPayslipId(payslip.id);
payslip.miscellaneous = new List <Miscellaneous>();
payslip.requests = new List <Request>();
RequestServiceInterface requestService = new RequestService();
foreach (int requestId in requestIds)
{
payslip.requests.Add(requestService.fetchById(requestId));
}
MiscellaneousServiceInterface miscellaneousService = new MiscellaneousService();
foreach (int miscellaneousId in miscellaneousIds)
{
payslip.miscellaneous.Add(miscellaneousService.fetchById(miscellaneousId));
}
//payslip.requests = requestService.
return(payslip);
}
