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++;
}
}
