public async Task <IList <DepartmentWiseEmployeeStatisticsVM> > GetDepartmertStat()
{
var employee = _context.Set <Employee>().ToList();
var t = from dept in _innerDB.ToList()
join emp in employee on dept.Id equals emp.Department.Id
select new { dept.Id, dept.Name } into x
group x by new { x.Id, x.Name } into g
select new DepartmentWiseEmployeeStatisticsVM
{
Total = g.Count(),
DepartmentName = g.Key.Name,
//Time = g.Sum(i => i.Zeit)
};
return(await Task.FromResult(t.ToList()));// await t.ToList();
}
internal BaseRepository(OfficeAttendenceSystemDbContext DbContext)
{
_DbContext = DbContext;
_innerDB = _DbContext.Set <TEntity>();
}