public IActionResult EmployeeStatistics([FromBody] GetEmployeeStatistics model)
{
model.ManagerId = 1;
var responseData = _managerRepository.GetEmployeeStatistics(model);
return(Json(new { response = responseData, code = 1 }));
}
public IList <Statistic> GetEmployeeStatistics(GetEmployeeStatistics model)
{
var list = new List <Statistic>();
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 s in _dbContext.Statistics on e.Id equals s.EmployeeId
where e.Id == model.EmployeeId && e.DepartmentId == DepartmentId && e.IsDelete == false
orderby s.Year descending, s.Month descending
select new Statistic
{
EmployeeId = e.Id,
Month = s.Month,
Year = s.Year,
FullName = e.FullName,
Punctual = s.Punctual,
Late = s.Late,
Unauthorized = s.Unauthorized,
PaidLeave = s.PaidLeave,
UnpaidLeave = s.UnpaidLeave,
DaysLeaveRemaining = s.DaysLeaveRemaining
}).ToList();
}
catch (Exception ex)
{
throw ex;
}
return(list);
}
public List <PositionGradeStatistics> PositionGradeStatistics(DateTime dt, int departmentID, Account accountoperator, List <Employee> employeeSource)
{
GetEmployeeStatistics GetEmployeeStatistics = new GetEmployeeStatistics(dt, departmentID, accountoperator, employeeSource);
return(GetEmployeeStatistics.PositionGradeStatistics());
}
public EmployeeOtherStatistics VocationStatistics(DateTime dt, int departmentID, Account accountoperator, List <Employee> employeeSource)
{
GetEmployeeStatistics GetEmployeeStatistics = new GetEmployeeStatistics(dt, departmentID, accountoperator, employeeSource);
return(GetEmployeeStatistics.VocationStatistics());
}
