public void GetPayrollNextStartDate3()
{
Initialize();
DeleteInfo();
//Test Data
var employee = new Employee
{
EmployeeCode = "11001",
FirstName = "Jona",
LastName = "Pereira",
MiddleName = "Aprecio",
BirthDate = DateTime.Parse("02/02/1991"),
Gender = 1,
IsActive = true
};
var employeePayroll = new EmployeePayroll()
{
CutOffEndDate = DateTime.Parse("05/17/2016"),
CutOffStartDate = DateTime.Parse("05/11/2016"),
PayrollDate = DateTime.Parse("05/18/2016"),
PayrollGeneratedDate = DateTime.Parse("05/18/2016"),
Employee = employee
};
var employeePayroll2 = new EmployeePayroll()
{
CutOffEndDate = DateTime.Parse("05/10/2016"),
CutOffStartDate = DateTime.Parse("05/04/2016"),
PayrollDate = DateTime.Parse("05/11/2016"),
PayrollGeneratedDate = DateTime.Parse("05/11/2016"),
Employee = employee
};
_employeePayrollRepository.Add(employeePayroll);
_employeePayrollRepository.Add(employeePayroll2);
_unitOfWork.Commit();
DateTime payrollStartDate = _employeePayrollService
.GetNextPayrollStartDate();
Assert.AreEqual(DateTime.Parse("05/18/2016"), payrollStartDate);
DateTime payrollEndDate = _employeePayrollService
.GetNextPayrollEndDate(payrollStartDate);
Assert.AreEqual(DateTime.Parse("05/24/2016"), payrollEndDate);
DateTime payrollReleaseDate = _employeePayrollService
.GetNextPayrollReleaseDate(payrollEndDate);
Assert.AreEqual(DateTime.Parse("05/25/2016"), payrollReleaseDate);
}
public void GenerateDeduction()
{
Initialize();
DeleteInfo();
//Initialize Data
var employee = new Employee
{
EmployeeCode = "11001",
FirstName = "Jona",
LastName = "Pereira",
MiddleName = "Aprecio",
BirthDate = DateTime.Parse("02/02/1991"),
Gender = 1,
IsActive = true
};
var employee2 = new Employee
{
EmployeeCode = "11002",
FirstName = "Cornelio Jr.",
LastName = "Cawicaan",
MiddleName = "Bue",
BirthDate = DateTime.Parse("10/30/1981"),
Gender = 1,
IsActive = true
};
var employeeInfo = new EmployeeInfo
{
Employee = employee,
SalaryFrequency = FrequencyType.Weekly,
Salary = 1000
};
var employeeInfo2 = new EmployeeInfo
{
Employee = employee2,
SalaryFrequency = FrequencyType.Weekly,
Salary = 900
};
_employeeInfoRepository.Add(employeeInfo);
_employeeInfoRepository.Add(employeeInfo2);
var employeeDeduction = new EmployeeDeduction
{
EmployeeId = 1,
DeductionId = HDMF_DEDUCTION_ID,
Amount = 100.10M
};
var employeeDeduction2 = new EmployeeDeduction
{
EmployeeId = 1,
DeductionId = SSS_DEDUCTION_ID,
Amount = 50.25M
};
var employeeDeduction3 = new EmployeeDeduction
{
EmployeeId = 1,
DeductionId = PHILHEALTH_DEDUCTION_ID,
Amount = 50.25M
};
var employeeDeduction4 = new EmployeeDeduction
{
EmployeeId = 2,
DeductionId = HDMF_DEDUCTION_ID,
Amount = 100.20M
};
var employeeDeduction5 = new EmployeeDeduction
{
EmployeeId = 2,
DeductionId = SSS_DEDUCTION_ID,
Amount = 45.5M
};
var employeeDeduction6 = new EmployeeDeduction
{
EmployeeId = 2,
DeductionId = PHILHEALTH_DEDUCTION_ID,
Amount = 55.90M
};
_employeeDeductionRepository.Add(employeeDeduction);
_employeeDeductionRepository.Add(employeeDeduction2);
_employeeDeductionRepository.Add(employeeDeduction3);
_employeeDeductionRepository.Add(employeeDeduction4);
_employeeDeductionRepository.Add(employeeDeduction5);
_employeeDeductionRepository.Add(employeeDeduction6);
var employeePayroll = new EmployeePayroll
{
EmployeeId = 1,
IsTaxed = false,
TaxableIncome = 1500,
TotalNet = 1500,
CutOffStartDate = DateTime.Parse("05/04/2016"),
CutOffEndDate = DateTime.Parse("05/10/2016"),
PayrollDate = DateTime.Parse("05/11/2016"),
TotalGross = 1500
};
var employeePayroll2 = new EmployeePayroll
{
EmployeeId = 1,
IsTaxed = false,
TaxableIncome = 1300.25M,
TotalNet = 1300.25M,
CutOffStartDate = DateTime.Parse("05/11/2016"),
CutOffEndDate = DateTime.Parse("05/17/2016"),
PayrollDate = DateTime.Parse("05/18/2016"),
TotalGross = 1300.25M
};
var employeePayroll3 = new EmployeePayroll
{
EmployeeId = 1,
IsTaxed = false,
TaxableIncome = 1500.25M,
TotalNet = 1500.25M,
CutOffStartDate = DateTime.Parse("05/18/2016"),
CutOffEndDate = DateTime.Parse("05/24/2016"),
PayrollDate = DateTime.Parse("05/25/2016"),
TotalGross = 1500.25M
};
var employeePayroll4 = new EmployeePayroll
{
EmployeeId = 1,
IsTaxed = false,
TaxableIncome = 950.50M,
TotalNet = 950.50M,
CutOffStartDate = DateTime.Parse("05/25/2016"),
CutOffEndDate = DateTime.Parse("05/31/2016"),
PayrollDate = DateTime.Parse("06/01/2016"),
TotalGross = 950.50M
};
var employeePayroll5 = new EmployeePayroll
{
EmployeeId = 2,
IsTaxed = false,
TaxableIncome = 2000.05M,
TotalNet = 2000.05M,
CutOffStartDate = DateTime.Parse("05/04/2016"),
CutOffEndDate = DateTime.Parse("05/10/2016"),
PayrollDate = DateTime.Parse("05/11/2016"),
TotalGross = 2000.05M
};
var employeePayroll6 = new EmployeePayroll
{
EmployeeId = 2,
IsTaxed = false,
TaxableIncome = 2100,
TotalNet = 2100,
CutOffStartDate = DateTime.Parse("05/11/2016"),
CutOffEndDate = DateTime.Parse("05/17/2016"),
PayrollDate = DateTime.Parse("05/18/2016"),
TotalGross = 2100
};
var employeePayroll7 = new EmployeePayroll
{
EmployeeId = 2,
IsTaxed = false,
TaxableIncome = 2200.50M,
TotalNet = 2200.50M,
CutOffStartDate = DateTime.Parse("05/18/2016"),
CutOffEndDate = DateTime.Parse("05/24/2016"),
PayrollDate = DateTime.Parse("05/25/2016"),
TotalGross = 2200.50M
};
var employeePayroll8 = new EmployeePayroll
{
EmployeeId = 2,
IsTaxed = false,
TaxableIncome = 750.50M,
TotalNet = 750.50M,
CutOffStartDate = DateTime.Parse("05/25/2016"),
CutOffEndDate = DateTime.Parse("05/31/2016"),
PayrollDate = DateTime.Parse("06/01/2016"),
TotalGross = 750.50M
};
_employeePayrollRepository.Add(employeePayroll);
_employeePayrollRepository.Add(employeePayroll2);
_employeePayrollRepository.Add(employeePayroll3);
_employeePayrollRepository.Add(employeePayroll4);
_employeePayrollRepository.Add(employeePayroll5);
_employeePayrollRepository.Add(employeePayroll6);
_employeePayrollRepository.Add(employeePayroll7);
_employeePayrollRepository.Add(employeePayroll8);
_unitOfWork.Commit();
//Current payroll
IList <EmployeePayroll> payrollList = new List <EmployeePayroll>();
payrollList.Add(employeePayroll4);
payrollList.Add(employeePayroll8);
decimal[] results = { 200.6m, 201.6m };
//Test
var counter = 0;
foreach (EmployeePayroll payroll in payrollList)
{
var totalDeductions = _employeePayrollDeductionService
.GenerateDeductionsByPayroll(payroll);
Assert.AreEqual(results[counter], totalDeductions);
counter++;
}
_unitOfWork.Commit();
//Verify
var startDate = DateTime.Parse("06/01/2016");
var endDate = DateTime.Parse("06/01/2016");
/*IList<EmployeePayroll> finalizedPayroll = _employeePayrollService.GetByDateRange(startDate, endDate);
*
* Assert.IsNotNull(finalizedPayroll);
*
* Assert.AreEqual(2, finalizedPayroll.Count());
* Assert.AreEqual(1, finalizedPayroll[0].EmployeeId);
* Assert.AreEqual(false, finalizedPayroll[0].IsTaxed);
* Assert.AreEqual(DateTime.Parse("05/25/2016"), finalizedPayroll[0].CutOffStartDate);
* Assert.AreEqual(DateTime.Parse("05/31/2016"), finalizedPayroll[0].CutOffEndDate);
* Assert.AreEqual(DateTime.Parse("06/01/2016"), finalizedPayroll[0].PayrollDate);
* Assert.AreEqual(749.9M, finalizedPayroll[0].TaxableIncome);
* Assert.AreEqual(950.50M, finalizedPayroll[0].TotalGross);*/
//Get all deductions
IList <EmployeePayrollDeduction> employeePayrollDeduction
= _employeePayrollDeductionService.GetByPayroll(4);
Assert.AreEqual(3, employeePayrollDeduction.Count());
Assert.AreEqual(employeePayrollDeduction[0].EmployeeId, 1);
Assert.AreEqual(employeePayrollDeduction[0].EmployeePayrollId, 4);
Assert.AreEqual(employeePayrollDeduction[0].Amount, 100.10M);
Assert.AreEqual(employeePayrollDeduction[0].DeductionId, HDMF_DEDUCTION_ID);
Assert.AreEqual(employeePayrollDeduction[1].EmployeeId, 1);
Assert.AreEqual(employeePayrollDeduction[1].EmployeePayrollId, 4);
Assert.AreEqual(employeePayrollDeduction[1].Amount, 50.25M);
Assert.AreEqual(employeePayrollDeduction[1].DeductionId, SSS_DEDUCTION_ID);
Assert.AreEqual(employeePayrollDeduction[2].EmployeeId, 1);
Assert.AreEqual(employeePayrollDeduction[2].EmployeePayrollId, 4);
Assert.AreEqual(employeePayrollDeduction[2].Amount, 50.25M);
Assert.AreEqual(employeePayrollDeduction[2].DeductionId, PHILHEALTH_DEDUCTION_ID);
//Check Tax
/*Assert.AreEqual(employeePayrollDeduction[3].EmployeeId, 1);
* Assert.AreEqual(employeePayrollDeduction[3].EmployeePayrollId, 4);
* Assert.AreEqual(employeePayrollDeduction[3].Amount, 46.71M);
* Assert.AreEqual(employeePayrollDeduction[3].DeductionId, TAX_DEDUCTION_ID);*/
/*Assert.AreEqual(2, finalizedPayroll[1].EmployeeId);
* Assert.AreEqual(true, finalizedPayroll[1].IsTaxed);
* Assert.AreEqual(DateTime.Parse("05/25/2016"), finalizedPayroll[1].CutOffStartDate);
* Assert.AreEqual(DateTime.Parse("05/31/2016"), finalizedPayroll[1].CutOffEndDate);
* Assert.AreEqual(DateTime.Parse("06/01/2016"), finalizedPayroll[1].PayrollDate);
* Assert.AreEqual(548.90M, finalizedPayroll[1].TaxableIncome);
* Assert.AreEqual(750.50M, finalizedPayroll[1].TotalGross);
* Assert.AreEqual(437.2975M, finalizedPayroll[1].TotalDeduction);
* Assert.AreEqual(313.2025M, finalizedPayroll[1].TotalNet);*/
employeePayrollDeduction
= _employeePayrollDeductionService.GetByPayroll(8);
Assert.AreEqual(3, employeePayrollDeduction.Count());
Assert.AreEqual(employeePayrollDeduction[0].EmployeeId, 2);
Assert.AreEqual(employeePayrollDeduction[0].EmployeePayrollId, 8);
Assert.AreEqual(employeePayrollDeduction[0].Amount, 100.20M);
Assert.AreEqual(employeePayrollDeduction[0].DeductionId, HDMF_DEDUCTION_ID);
Assert.AreEqual(employeePayrollDeduction[1].EmployeeId, 2);
Assert.AreEqual(employeePayrollDeduction[1].EmployeePayrollId, 8);
Assert.AreEqual(employeePayrollDeduction[1].Amount, 45.5M);
Assert.AreEqual(employeePayrollDeduction[1].DeductionId, SSS_DEDUCTION_ID);
Assert.AreEqual(employeePayrollDeduction[2].EmployeeId, 2);
Assert.AreEqual(employeePayrollDeduction[2].EmployeePayrollId, 8);
Assert.AreEqual(employeePayrollDeduction[2].Amount, 55.90M);
Assert.AreEqual(employeePayrollDeduction[2].DeductionId, PHILHEALTH_DEDUCTION_ID);
//Check Tax
/*Assert.AreEqual(employeePayrollDeduction[3].EmployeeId, 2);
* Assert.AreEqual(employeePayrollDeduction[3].EmployeePayrollId, 8);
* Assert.AreEqual(employeePayrollDeduction[3].Amount, 235.6975M);
* Assert.AreEqual(employeePayrollDeduction[3].DeductionId, TAX_DEDUCTION_ID);*/
}
public IList <EmployeePayroll> GeneratePayrollGrossPayByDateRange(DateTime payrollDate, DateTime payrollStartDate, DateTime payrollEndDate)
{
var employeePayrollItems = _employeePayrollItemService.GetByDateRange(payrollDate, payrollDate);
var employeePayrollList = new List <EmployeePayroll>();
if (employeePayrollItems != null && employeePayrollItems.Count() > 0)
{
//Hold last payroll processed
EmployeePayroll tempEmployeePayroll = null;
DateTime today = DateTime.Now;
EmployeePayrollItem lastPayrollItem = employeePayrollItems.Last();
foreach (EmployeePayrollItem item in employeePayrollItems)
{
//If should create new entry
if (tempEmployeePayroll == null ||
(tempEmployeePayroll.Employee.EmployeeId != item.EmployeeId))
{
if (tempEmployeePayroll != null)
{
//Save last employeePayrollAllowanceServiceentry if for different employee
_employeePayrollRepository.Add(tempEmployeePayroll);
employeePayrollList.Add(tempEmployeePayroll);
}
Employee employee = _employeeService.GetById(item.EmployeeId);
EmployeePayroll employeePayroll = new EmployeePayroll
{
Employee = employee,
CutOffStartDate = payrollStartDate,
CutOffEndDate = payrollEndDate,
PayrollGeneratedDate = today,
PayrollDate = payrollDate,
TotalGross = item.TotalAmount,
TotalNet = item.TotalAmount,
TaxableIncome = item.TotalAmount
};
tempEmployeePayroll = employeePayroll;
}
else
{
//Update last entry
tempEmployeePayroll.TotalGross += item.TotalAmount;
tempEmployeePayroll.TotalNet += item.TotalAmount;
tempEmployeePayroll.TaxableIncome += item.TotalAmount;
}
//If last iteration save
if (item.Equals(lastPayrollItem))
{
_employeePayrollRepository.Add(tempEmployeePayroll);
employeePayrollList.Add(tempEmployeePayroll);
}
}
//Commit
_unitOfWork.Commit();
}
MapItemsToPayroll(employeePayrollItems, employeePayrollList);
return(employeePayrollList);
/*foreach (EmployeeDailyPayroll dailyPayroll in employeeDailyPayroll)
* {
* //If should create new entry
* if (tempEmployeePayroll == null ||
* (tempEmployeePayroll.Employee.EmployeeId != dailyPayroll.EmployeeId))
* {
* if (tempEmployeePayroll != null)
* {
* //Save last entry if for different employee
* _employeePayrollRepository.Add(tempEmployeePayroll);
* employeePayrollList.Add(tempEmployeePayroll);
* }
* Employee employee = _employeeService.GetById(dailyPayroll.EmployeeId);
*
* EmployeePayroll employeePayroll = new EmployeePayroll
* {
* Employee = employee,
* CutOffStartDate = dateFrom,
* CutOffEndDate = dateTo,
* PayrollGeneratedDate = today,
* PayrollDate = payrollDate,
* TotalGross = dailyPayroll.TotalPay,
* TotalNet = dailyPayroll.TotalPay,
* TaxableIncome = dailyPayroll.TotalPay
* };
*
* tempEmployeePayroll = employeePayroll;
* createNewPayrollItem = true;
*
* }
* else
* {
* //Update last entry
* tempEmployeePayroll.TotalGross += dailyPayroll.TotalPay;
* tempEmployeePayroll.TotalNet += dailyPayroll.TotalPay;
* tempEmployeePayroll.TaxableIncome += dailyPayroll.TotalPay;
*
* if (tempEmployeePayrollItem.RateType != dailyPayroll.RateType)
* {
* createNewPayrollItem = true;
* }
* else
* {
* createNewPayrollItem = false;
* }
* }
*
* //Payroll Item
* var totalEmployeeHours = _totalEmployeeHoursService.GetById(dailyPayroll.TotalEmployeeHoursId.Value);
* //If should create new item
* if (createNewPayrollItem)
* {
* //Save last item
* if (tempEmployeePayrollItem != null)
* {
* _employeePayrollItemService.Add(tempEmployeePayrollItem);
* tempEmployeePayrollItem = null;
* }
*
* /*tempEmployeePayrollItem = new EmployeePayrollItem
* {
* EmployeePayroll = tempEmployeePayroll,
* RateType = dailyPayroll.RateType,
* TotalAmount = dailyPayroll.TotalPay,
* TotalHours = totalEmployeeHours.Hours
* };
*
* }
* else
* {
* //Update last entry
* tempEmployeePayrollItem.TotalHours += totalEmployeeHours.Hours;
* tempEmployeePayrollItem.TotalAmount += dailyPayroll.TotalPay;
*
* }
*
*
* //If last iteration save
* if (dailyPayroll.Equals(last))
* {
* _employeePayrollRepository.Add(tempEmployeePayroll);
* _employeePayrollItemService.Add(tempEmployeePayrollItem);
* employeePayrollList.Add(tempEmployeePayroll);
* }
* })*/
}
