// 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())); }