// returns list of credits and sum of credits public ActionResult AddCredit(Credit credit) { if (!User.Identity.IsAuthenticated) { return(RedirectToAction("login", "Home")); } var UserRepo = new UserRepository(Properties.Settings.Default._connectionString); var budgetRepo = new BudgetRepository(Properties.Settings.Default._connectionString); credit.UserId = UserRepo.GetUserByEmail(User.Identity.Name).Id; budgetRepo.AddCredit(credit); List <Credit> Credits = budgetRepo.GetCreditsByMonthId(credit.UserId, credit.MonthId); return(Json(new { credits = Credits.Select(C => new { Id = C.Id, Amount = C.Amount.ToString("C"), Date = C.Date, Source = C.Source }), creditTotal = Credits.Sum(C => C.Amount).ToString("C") })); }