public ActionResult Search(AccountBalanceSearch search) { IEnumerable <ViewAccountBalance> accountbalances = _Db.ViewAccountBalances; if (search.Year != null && search.Year > 2000) { accountbalances = accountbalances.Where(n => n.Dated.Year == search.Year); } if (search.Month >= 1 && search.Month <= 12) { accountbalances = accountbalances.Where(n => n.Dated.Month == search.Month); } if (!string.IsNullOrWhiteSpace(search.ByUser)) { search.ByUser = search.ByUser.ToLower(); accountbalances = accountbalances.Where(n => n.AccountOfLog.ToLower() .Contains(search.ByUser) || n.AccountOfName.ToLower() .Contains(search.ByUser)); } DbSet <ViewSummaryAccountBalance> summary = _Db.ViewSummaryAccountBalances; double?sum = summary.Sum(n => n.Balance); ViewBag.Summary = summary; ViewBag.Sum = sum; var accounts = new AccountBalanceMultiple(); accounts.ViewAccountBalance = accountbalances.ToList(); return(View("List", accounts)); }
public ActionResult List() { List <ViewAccountBalance> accountbalances = _Db.ViewAccountBalances.ToList(); DbSet <ViewSummaryAccountBalance> summary = _Db.ViewSummaryAccountBalances; double?sum = summary.Sum(n => n.Balance); ViewBag.Summary = summary; ViewBag.Sum = sum; var accounts = new AccountBalanceMultiple(); accounts.ViewAccountBalance = accountbalances; return(View(accounts)); }
public ActionResult CurrentMonth() { IEnumerable <ViewAccountBalance> accountbalances = _Db.ViewAccountBalances; accountbalances = accountbalances.Where(n => n.Dated.Year == DateTime.Now.Year && n.Dated.Month == DateTime.Now.Month); DbSet <ViewSummaryAccountBalance> summary = _Db.ViewSummaryAccountBalances; double?sum = summary.Sum(n => n.Balance); ViewBag.Summary = summary; ViewBag.Sum = sum; var accounts = new AccountBalanceMultiple(); accounts.ViewAccountBalance = accountbalances.ToList(); return(View("List", accounts)); }
public ActionResult FilterBy(int id) { if (id > -1) { User user = _Db.Users.Find(id); if (user != null) { IQueryable <ViewAccountBalance> accountbalances = _Db.ViewAccountBalances.Where(n => n.AccountOf == id); ViewBag.Summary = null; ViewBag.Sum = null; ViewBag.Name = user.Name; var accounts = new AccountBalanceMultiple(); accounts.ViewAccountBalance = accountbalances.ToList(); return(View("List", accounts)); } } return(View("Error")); }