public async Task <ActionResult> BalanceChart(string month)
{
var calculator = new SumCalculator(Db, await GetCurrentClient());
var monthParam = new Month(month);
var incomes = new Dictionary <Month, decimal>();
var spendings = new Dictionary <Month, decimal>();
var months = new List <Month>
{
monthParam.IsCurrentMonth?monthParam.PreviousMonth.PreviousMonth.PreviousMonth.PreviousMonth : monthParam.PreviousMonth.PreviousMonth.PreviousMonth,
monthParam.IsCurrentMonth ? monthParam.PreviousMonth.PreviousMonth.PreviousMonth : monthParam.PreviousMonth.PreviousMonth,
monthParam.IsCurrentMonth ? monthParam.PreviousMonth.PreviousMonth : monthParam.PreviousMonth,
monthParam.IsCurrentMonth ? monthParam.PreviousMonth : monthParam,
monthParam.IsCurrentMonth ? monthParam : monthParam.NextMonth
};
foreach (var m in months)
{
var calcResult = (await calculator.CalculateForMonth(m)).ToList();
incomes[m] = calcResult.Where(x => x.Key == Constants.IncomeCategory).Select(x => x.Value).Sum();
spendings[m] = calcResult.Where(x => x.Key != Constants.IncomeCategory).Select(x => x.Value).Sum();
}
var result = from x in months
orderby x.Date
select new
{
month = x.Date.ToString("MMM yyyy"),
income = incomes[x],
spendings = -spendings[x]
};
return(Json(result, JsonRequestBehavior.AllowGet));
}
public async Task <ActionResult> SpendingsChart(string month)
{
var calculator = new SumCalculator(Db, await GetCurrentClient());
var result = from x in await calculator.CalculateForMonth(new Month(month))
where x.Key != Constants.IncomeCategory
orderby x.Value
select new
{
amount = -x.Value,
category = x.Key
};
return(Json(result, JsonRequestBehavior.AllowGet));
}