public IList <TimeSheetList> GetTimeSheetList(GetTimeSheetList model)
{
var list = new List <TimeSheetList>();
try
{
int departmentId = _dbContext.Employee.FirstOrDefault(e => e.Id == model.ManagerId && e.IsActive == true && e.IsDelete == false).DepartmentId;
list = (from e in _dbContext.Employee
join t in _dbContext.TimeSheet on e.Id equals t.EmployeeId
where e.Id == model.EmployeeId && e.DepartmentId == departmentId && e.IsDelete == false && t.Date.Month == model.Month && t.Date.Year == model.Year
orderby t.Date descending
select new TimeSheetList
{
EmployeeId = e.Id,
ManagerId = t.ManagerId,
FullName = e.FullName,
Status = t.Status == 1 ? "Có mặt" :
(t.Status == 2 ? "Trễ" :
(t.Status == 3 ? "Vắng không phép" :
(t.Status == 4 ? "Vắng có phép" :
(t.Status == 5 ? "Vắng không lương" : ""
)))),
Date = t.Date.ToString()
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public async Task <List <TimeSheetList> > GetTimeSheetListss(GetTimeSheetList model)
{
var getsTimSheet = new List <TimeSheetList>();
try
{
//var departmentId = _context.Employee.FirstOrDefault(e => e.Id == model.EmployeeId && e.IsActive == true && e.IsDelete == false).DepartmentId;
getsTimSheet = await(from e in _context.Employee
join t in _context.TimeSheet on e.Id equals t.EmployeeId
where e.Id == model.EmployeeId && e.IsDelete == false &&
t.Date.Month == model.Month && t.Date.Year == model.Year
orderby t.Date descending
select new TimeSheetList
{
EmployeeId = e.Id,
ManagerId = t.ManagerId,
FullName = e.FullName,
Status = t.Status == 1 ? "Có Mặt" :
(t.Status == 2 ? "Trễ" :
(t.Status == 3 ? "Vắng không phép" :
(t.Status == 4 ? "Vắng có phép" :
(t.Status == 5 ? "Vắng không lương" : ""
)))),
Date = t.Date.ToString("ddd dd/MM/yyyy")
}).ToListAsync();
return(getsTimSheet);
}
catch (Exception ex)
{
throw ex;
}
}
public IActionResult TimeSheetList([FromBody] GetTimeSheetList model)
{
model.ManagerId = 1;
var responseData = _managerRepository.GetTimeSheetList(model);
return(Json(new { response = responseData, code = 1 }));
}
public IActionResult DetailsStatistic([FromBody] GetTimeSheetList model)
{
model.EmployeeId = employeeId;
var statistics = Task.Run(async() => await _emprepository.GetTimeSheetListss(model)).Result;
if (statistics == null)
{
return(NotFound());
}
return(Json(new { response = statistics, code = 1 }));
}
