public async Task<ActionResult> ProjectTotalHoursPerPeriod(SetPeriodViewModel model)
{
var m = (await db.Projects.SelectMany(p=>p.Activities).Finished().OnInterval(model.FinalDate, model.InitialDate).GroupBy(p => p.Project.Name).Select(p => new
{
Name = p.Key,
WorkTimes = p.Select(a1 => a1.WorkingTime)
}).ToListAsync());
var result = m.Where(x => x.WorkTimes.Count() > 0).Select(a => new ProjectTotalHoursViewModel()
{
Name = a.Name,
TotalHours = a.WorkTimes.Sum(t => t.TotalHours)
}).ToList();
model.ResultProjects = result;
return View(model);
}
public async Task<ActionResult> UserProductivityPerPeriod(SetPeriodViewModel model)
{
var m = (await db.Projects.SelectMany(p => p.Activities).Finished().OnInterval(model.FinalDate, model.InitialDate).GroupBy(a => a.AssignedUser)
.Select(ag => new
{
WorkingTimes = ag.Select(a1 => a1.WorkingTime),
UserName = ag.Key.UserName
})
.ToListAsync());
model.ResultUsers = m.Select(u => new UserTotalHoursViewModel()
{
Name = u.UserName,
TotalHours = u.WorkingTimes.Sum(w => w.TotalHours)
}).OrderByDescending(u => u.TotalHours).ToList();
return View(model);
}