public void GenerateTotalByDateRange(DateTime dateFrom, DateTime dateTo)
{
//Delete existing data within date range
//DeleteByDateRange(dateFrom, dateTo);
var employeeHoursList = _employeeHoursService
.GetForProcessingByDateRange(false, dateFrom, dateTo);
GenerateTotal(employeeHoursList);
}
public void GenerateTotalByDateRange(DateTime dateFrom, DateTime dateTo)
{
//Delete existing data within date range
DeleteByDateRange(dateFrom, dateTo);
var employeeHoursList = _employeeHoursService
.GetForProcessingByDateRange(true, dateFrom, dateTo);
if (employeeHoursList != null && employeeHoursList.Count > 1)
{
int tempEmployeeId = 0;
DateTime?tempDate = null;
RateType?tempRate = null;
TotalEmployeeHours totalEmployeeHours = null;
EmployeeHours last = employeeHoursList.Last();
foreach (EmployeeHours hours in employeeHoursList)
{
// If not the same date, type and employee as the last entry should create new total employee hours
if (tempEmployeeId != hours.EmployeeId ||
tempDate != hours.Date || tempRate != hours.Type)
{
//Save previous entry if any
if (totalEmployeeHours != null)
{
//Check if there's an existing total entry for the employee, rate type and date
var existingTotalEmployeeHours = _totalEmployeeHoursRepository
.GetByEmployeeDateAndType(totalEmployeeHours.EmployeeId,
totalEmployeeHours.Date, totalEmployeeHours.Type);
//If yes update the value
if (existingTotalEmployeeHours != null)
{
_totalEmployeeHoursRepository.Update(existingTotalEmployeeHours);
existingTotalEmployeeHours.Hours = (existingTotalEmployeeHours.Hours + totalEmployeeHours.Hours);
}
else //Create new entry
{
totalEmployeeHours.Hours = (totalEmployeeHours.Hours);
_totalEmployeeHoursRepository.Add(totalEmployeeHours);
}
}
//Create new total employee hours obj
totalEmployeeHours = new TotalEmployeeHours
{
Date = hours.Date,
EmployeeId = hours.EmployeeId,
Type = hours.Type,
Hours = hours.Hours
};
}
else //Same Employee, Date and Rate, Update the total Employee hours data
{
totalEmployeeHours.Hours = totalEmployeeHours.Hours + hours.Hours;
}
//If Last Iteration and New entry
//Save
if (hours.Equals(last) && (totalEmployeeHours.TotalEmployeeHoursId == null ||
totalEmployeeHours.TotalEmployeeHoursId <= 0))
{
totalEmployeeHours.Hours = (totalEmployeeHours.Hours);
_totalEmployeeHoursRepository.Add(totalEmployeeHours);
}
//Set Reference data
tempDate = hours.Date;
tempEmployeeId = hours.EmployeeId;
tempRate = hours.Type;
//Update employee hours IsIncludedInTotal value
_employeeHoursService.Update(hours);
hours.IsIncludedInTotal = true;
}
//Commit all change
_unitOfWork.Commit();
}
}