public async Task OnGetAsync() { var requestCulture = HttpContext.Features.Get <IRequestCultureFeature>(); var culture = requestCulture.RequestCulture.UICulture; LabelCharts = MiscHelpers.GetDaysOfWeekFromNow(culture).ToArray(); var dates = MiscHelpers.GetDateTimesFromBack(); IQueryable <Earn> queryEarnsBase = _context.Earn .Where(x => x.UserId == HttpContext.User.GetUserId()); IQueryable <Expense> queryExpensesBase = _context.Expense .Where(x => x.UserId == HttpContext.User.GetUserId()); TotalIncomes = new decimal[7]; TotalExpense = new decimal[7]; int index = 0; foreach (DateTime current in dates) { TotalIncomes[index] = await queryEarnsBase .Where(x => x.AtCreated.Day == current.Day) .SumAsync(j => j.Amount); TotalExpense[index] = await queryExpensesBase .Where(x => x.AtCreated.Day == current.Day) .SumAsync(j => j.Amount); index++; } }