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);
}
