public SparePartListViewModel Search(string category, int page, string search, int pageSize) { SparePartListViewModel temp = new SparePartListViewModel(); Run(db => { if (search != null) { search = search.ToUpper(); } temp.SpareParts = db.SpareParts .Where(p => category == null || p.Category == category) .Where(p => search == null || p.Mark.ToUpper().Contains(search) || p.Model.ToUpper().Contains(search)) .OrderBy(x => x.Id). ToArray(); temp.CurrentCategory = category; temp.Search = search; }); return temp; }
public ActionResult List(string category = "Двигатель", int page = 1) { SparePartListViewModel model = new SparePartListViewModel { SpareParts = db.SpareParts .Where(p=>category == null||p.Category==category) .OrderBy(x => x.Id) .Skip((page - 1) * pageSize) .Take(pageSize), PagingInfo = new PagingInfo { CurrentPage = page, ItemsPerPage = pageSize, TotalSpare = category == null ? db.SpareParts.Count() : db.SpareParts.Where(game => game.Category == category).Count() }, CurrentCategory = category }; return View(model); }