public ActionResult GetAmountForCategory(int MonthId) { var budgetRepo = new BudgetRepository(Properties.Settings.Default._connectionString); var List = budgetRepo.CategoryListWithAmounts(MonthId); var CategoryList = budgetRepo.GetAllCategories(); List <CategoryWithAmountForMonth> CategoriesWithAMount = new List <CategoryWithAmountForMonth>(); foreach (Category C in CategoryList) { CategoryWithAmountForMonth CategoryWithSum = new CategoryWithAmountForMonth(); CategoryWithSum.CategoryName = C.CategoryName; CategoryWithSum.Sum = List.Where(D => D.Category.CategoryName == C.CategoryName).Select(D => D.Amount).Sum(); CategoriesWithAMount.Add(CategoryWithSum); // CategoryWithSum.Sum = List.Select((D => D.Amount)).Where (D => D.am) } return(Json(CategoriesWithAMount.Select(C => new { categoryName = C.CategoryName, amount = C.Sum }), JsonRequestBehavior.AllowGet)); }
// GET: Budget public ActionResult Budget() { if (!User.Identity.IsAuthenticated) { return(RedirectToAction("login", "Home")); } UserRepository UserRepo = new UserRepository(Properties.Settings.Default._connectionString); User CurrentUser = UserRepo.GetUserByEmail(User.Identity.Name); BudgetRepository BudgetRepo = new BudgetRepository(Properties.Settings.Default._connectionString); var BudgetModel = new BudgetViewModel(); BudgetModel.CurrentUser = BudgetRepo.UserWithHistory(CurrentUser.Id); BudgetModel.MonthsBudgeted = BudgetRepo.MonthYearForUser(CurrentUser.Id); BudgetModel.AllCategories = BudgetRepo.GetAllCategories(); if (BudgetModel.MonthsBudgeted.Count != 0) { //gets debits for last month budgeted BudgetModel.DebitsForLatestMonth = BudgetRepo.GetDebitsByMonthId(CurrentUser.Id, BudgetModel.MonthsBudgeted[BudgetModel.MonthsBudgeted.Count - 1].Id); BudgetModel.CreditsForLastMonth = BudgetRepo.GetCreditsByMonthId(CurrentUser.Id, BudgetModel.MonthsBudgeted[BudgetModel.MonthsBudgeted.Count - 1].Id); BudgetModel.LatestMonth = BudgetRepo.GetMonthInfo(BudgetModel.MonthsBudgeted[BudgetModel.MonthsBudgeted.Count - 1].Id); } return(View(BudgetModel)); }