public Dictionary <string, decimal> CalculateMonthlyExpense() { ExpensesDataAcessLayer objexpense = new ExpensesDataAcessLayer(); List <ExpenseReport> lstEmployee = new List <ExpenseReport>(); Dictionary <string, decimal> dictMonthlySum = new Dictionary <string, decimal>(); decimal foodSum = db.ExpenseReport.Where (cat => cat.Category == "На Еду" && (cat.ExpenseDate > DateTime.Now.AddMonths(-1))) .Select(cat => cat.Amount) .Sum(); decimal shoppingSum = db.ExpenseReport.Where (cat => cat.Category == "Переодические расходы" && (cat.ExpenseDate > DateTime.Now.AddMonths(-1))) .Select(cat => cat.Amount) .Sum(); decimal travelSum = db.ExpenseReport.Where (cat => cat.Category == "Постоянные расходы" && (cat.ExpenseDate > DateTime.Now.AddMonths(-1))) .Select(cat => cat.Amount) .Sum(); decimal healthSum = db.ExpenseReport.Where (cat => cat.Category == "Прочие расходы" && (cat.ExpenseDate > DateTime.Now.AddMonths(-1))) .Select(cat => cat.Amount) .Sum(); dictMonthlySum.Add("На Еду", foodSum); dictMonthlySum.Add("Переодические расходы", shoppingSum); dictMonthlySum.Add("Постоянные расходы", travelSum); dictMonthlySum.Add("Прочие расходы", healthSum); return(dictMonthlySum); }