public IEnumerable <AttendanceGroupedDTO> GetAttendancesByProfessionId(int ProfessionId)
{
List <AttendanceGroupedDTO> list = new List <AttendanceGroupedDTO>();
var lstEmployees = _context.Employees.Where(e => e.ProfessionID == ProfessionId).ToList();
foreach (var emp in lstEmployees)
{
AttendanceGroupedDTO attendanceGrouped = new AttendanceGroupedDTO();
attendanceGrouped.EmployeeId = emp.ID;
attendanceGrouped.EmployeeName = emp.Name;
attendanceGrouped.lstAttendance = _context.Attendance.Where(att => att.EmployeeID == emp.ID).ToList();
list.Add(attendanceGrouped);
}
return(list);
}
public IEnumerable <AttendanceGroupedDTO> GetAttendancesByDate(DateTime startDate, DateTime endDate)
{
List <AttendanceGroupedDTO> list = new List <AttendanceGroupedDTO>();
var lstEmployees = _context.Employees.ToList();
foreach (var emp in lstEmployees)
{
AttendanceGroupedDTO attendanceGrouped = new AttendanceGroupedDTO();
attendanceGrouped.EmployeeId = emp.ID;
attendanceGrouped.EmployeeName = emp.Name;
attendanceGrouped.lstAttendance = _context.Attendance.Where(att => att.Arrival >= startDate && att.Departure <= endDate && att.EmployeeID == emp.ID).ToList();
list.Add(attendanceGrouped);
}
return(list);
}
