public IEnumerable <ReportExcuseDTO> GetExcusesForReport()
{
List <ReportExcuseDTO> lstexcusesDTO = new List <ReportExcuseDTO>();
//var lstEmployees = _context.Employees.ToList();
//foreach (var item in lstEmployees)
//{
// ReportExcuseDTO excuseObj = new ReportExcuseDTO();
// excuseObj.EmployeeName = item.Name;
// excuseObj.ProfessionName= _context.Employees.Where(a => a.Profession.ID == item.ProfessionID).ToList().FirstOrDefault().Name;
// var lstExecuses = _context.Excuses.Where(a => a.EmployeeID == item.ID).ToList();
// if (lstExecuses.Count > 0)
// {
// excuseObj.lstExcuse = lstExecuses;
// }
// lstexcusesDTO.Add(excuseObj);
//}
// var listex = _context.Excuses.ToList();
var ExcusesList = (from ex in _context.Excuses.Include(ex => ex.Employee.Profession).ToList()
select ex).GroupBy(grp => grp.EmployeeID).ToList();
foreach (var item in ExcusesList)
{
ReportExcuseDTO excuseObj = new ReportExcuseDTO();
excuseObj.ProfessionName = item.FirstOrDefault().Employee.Profession.Name;
excuseObj.ProfessionId = item.FirstOrDefault().Employee.ProfessionID;
excuseObj.EmployeeId = item.FirstOrDefault().EmployeeID;
excuseObj.EmployeeName = item.FirstOrDefault().Employee.Name;
excuseObj.lstExcuse = item.ToList();
lstexcusesDTO.Add(excuseObj);
}
return(lstexcusesDTO);
}
public IEnumerable <ReportExcuseDTO> GetExcusesForReport()
{
List <ReportExcuseDTO> lstexcusesDTO = new List <ReportExcuseDTO>();
var ExcusesList = (from ex in _context.Excuses.Include(ex => ex.Employee.Profession).ToList()
select ex).GroupBy(grp => grp.EmployeeID).ToList();
foreach (var item in ExcusesList)
{
ReportExcuseDTO excuseObj = new ReportExcuseDTO();
excuseObj.ProfessionName = item.FirstOrDefault().Employee.Profession.Name;
excuseObj.ProfessionId = item.FirstOrDefault().Employee.ProfessionID;
excuseObj.EmployeeId = item.FirstOrDefault().EmployeeID;
excuseObj.EmployeeName = item.FirstOrDefault().Employee.Name;
excuseObj.lstExcuse = item.ToList();
lstexcusesDTO.Add(excuseObj);
}
return(lstexcusesDTO);
}
public ActionResult <IEnumerable <ReportExcuseDTO> > GetExcusesByProfessionIdAndEmployeeId(int ProfessionId, int EmployeeId)
{
List <ReportExcuseDTO> lstexcusesDTO = new List <ReportExcuseDTO>();
var ExcusesList = (from ex in _context.Excuses.Include(ex => ex.Employee.Profession).Where(e => e.Employee.ProfessionID == ProfessionId && e.EmployeeID == EmployeeId).ToList()
select ex).GroupBy(grp => grp.EmployeeID).ToList();
foreach (var item in ExcusesList)
{
ReportExcuseDTO excuseObj = new ReportExcuseDTO();
excuseObj.ProfessionName = item.FirstOrDefault().Employee.Profession.Name;
excuseObj.ProfessionId = item.FirstOrDefault().Employee.ProfessionID;
excuseObj.EmployeeId = item.FirstOrDefault().EmployeeID;
excuseObj.EmployeeName = item.FirstOrDefault().Employee.Name;
excuseObj.lstExcuse = item.ToList();
lstexcusesDTO.Add(excuseObj);
}
return(lstexcusesDTO);
}
