private static DeptWiseAttendanceDTO CreateAttendanceDTO(IGrouping<int, ActivityLogDTO> grp, IEnumerable<Employee> allEmployees)
{
var deptMembers = allEmployees.Where(e => e.Deprtment.Id == grp.First().Department.Id);
var dto = new DeptWiseAttendanceDTO
{
DepartmentName = grp.First().Department.Name,
Attendance = grp.GroupBy(gd => gd.Employee.Id)
.Select(empGroup => new AttendanceDTO
{
EmployeeName = empGroup.First().Employee.Name,
EmployeeId = empGroup.First().Employee.Id,
Attended = true,
Date = empGroup.First().TimeStamp.ToString("yyyy-MM-dd")
})
.ToList()
};
var absents = deptMembers.Where(m => !dto.Attendance.Any(a => a.EmployeeId == m.Id));
var date = dto.Attendance.First().Date;
dto.Attendance.AddRange(absents.Select(a => new AttendanceDTO
{
EmployeeName = a.Name,
EmployeeId = a.Id,
Attended = false,
Date = date
}));
return dto;
}
//to be mailed in real
void DispatchDepartmentAttendenceReport(DeptWiseAttendanceDTO logs)
{
var filename = string.Format("AttendenceReport_{0}_{1}.txt", logs.DepartmentName, DateTime.Now.ToString("yyyyMMdd_hhmmss"));
var logfilepath = Path.Combine(ConfigHelper.GetHRSharedDrivePath(), filename);
var report = new List<string>();
report.Add("Department : " + logs.DepartmentName);
report.Add("Date : " + DateTime.Now.ToLongDateString());
report.Add("==========================================");
foreach (var log in logs.Attendance)
{
report.Add(log.ToString());
}
File.WriteAllLines(logfilepath, report);
}