public ActionResult _LoadProduct(SearchDealModel model) { model.PageIndex = model.PageIndex == 0 ? 1 : model.PageIndex; var query = _dealRepository.GetDealList(); if (!string.IsNullOrEmpty(model.DealType)) { } if (!string.IsNullOrEmpty(model.Sort)) { } if (!string.IsNullOrEmpty(model.Search)) { query = query.Where(x => x.ProductName.Contains(model.Search)); } model.TotalRecordCount = query.Count(); var _getList = query.OrderBy(a => a.DealId).Skip(((model.PageIndex - 1) * model.PageSize)).Take(model.PageSize).ToList(); int pageCount = (model.TotalRecordCount / model.PageSize) + ((model.TotalRecordCount % model.PageSize) > 0 ? 1 : 0); model.TotalPageCount = pageCount; // bind schemes foreach (var item in _getList) { item.lstSchemes = _schemeRepository.FindBy(x => x.DealId == item.DealId).ToList(); } model.getDealModels = _getList; return(PartialView(model)); }