// GET: Monthly
public async Task <IActionResult> Index()
{
var model = new MonthlyIndexViewModel();
var applicationDbContext = _context.UserCategories.Include(u => u.Category).Include(u => u.User);
return(View(model));
}
public async Task <IActionResult> IndexMonth1(MonthlyIndexViewModel viewModel)
{
var user = await GetCurrentUserAsync();
var applicationDbContext = _context.UserCategories
.Include(u => u.Category)
.Include(u => u.User)
.Where(u => u.UserId == user.Id)
.Where(u => u.DatePicked.Month == viewModel.MonthId)
.Where(u => u.DatePicked.Year == viewModel.YearId)
.GroupBy(u => u.Category)
.Select(g => new UserCategory
{
User = user,
Category = g.Key,
MinutesSpent = g.Sum(uc => uc.MinutesSpent)
});
return(View(await applicationDbContext.OrderByDescending(uc => uc.MinutesSpent).ToListAsync()));
}
