public ActionResult Index() { if (TempData["Message"] != null) { ViewBag.Message = TempData["Message"]; } var vm = new ContributorsIndexViewModel(); var mgr = new SimchaFundManager(Properties.Settings.Default.ConStr); vm.Contributors = mgr.GetContributors(); return(View(vm)); }
public IActionResult Index() { if (TempData["Message"] != null) { ViewBag.Message = TempData["Message"]; } var vm = new ContributorsIndexViewModel(); var mgr = new SimchaFundManager(_connectionString); vm.Contributors = mgr.GetContributors(); return(View(vm)); }
public ActionResult History(int contribId) { var mgr = new SimchaFundManager(Properties.Settings.Default.ConStr); IEnumerable <Deposit> deposits = mgr.GetDepositsById(contribId); IEnumerable <Contribution> contributions = mgr.GetContributionsById(contribId); #region list way without select //List<Transaction> transactions2 = new List<Transaction>(); //foreach (Deposit deposit in deposits) //{ // transactions2.Add(new Transaction // { // Action = "Deposit", // Amount = deposit.Amount, // Date = deposit.Date // }); //} //foreach (Contribution c in contributions) //{ // transactions2.Add(new Transaction // { // Action = "Contribution for the " + c.SimchaName + " simcha", // Amount = -c.Amount, // Date = c.Date // }); //} //transactions2.OrderByDescending(t => t.Date); #endregion IEnumerable <Transaction> transactions = deposits.Select(d => new Transaction { Action = "Deposit", Amount = d.Amount, Date = d.Date }).Concat(contributions.Select(c => new Transaction { Action = "Contribution for the " + c.SimchaName + " simcha", Amount = -c.Amount, Date = c.Date })).OrderByDescending(t => t.Date); var vm = new HistoryViewModel(); vm.Transactions = transactions; Contributor contributor = mgr.GetContributors().First(c => c.Id == contribId); vm.ContributorBalance = contributor.Balance; vm.ContributorName = contributor.FirstName + " " + contributor.LastName; return(View(vm)); }