public IPagedList <MSDS_Worker> Search(WorkerSearchModel searchModel)
{
var query = _context.MSDS_Worker.Where(x => string.IsNullOrEmpty(searchModel.KeyWord) ||
x.Worker_Name.ToLower().Contains(searchModel.KeyWord.ToLower()) ||
x.Worker_ID.Contains(searchModel.KeyWord))
.OrderBy(x => x.Worker_Name);
var count = query.Count();
var result = query.Skip((searchModel.PageIndex - 1) * searchModel.PageSize).Take(searchModel.PageSize).ToList();
return(new PagedList <MSDS_Worker>(result, searchModel.PageIndex, searchModel.PageSize, count));
}
private void SearchOrders(WorkerSearchViewModel model)
{
var searchModel = new WorkerSearchModel
{
PageIndex = model.PageIndex,
PageSize = model.PageSize,
KeyWord = model.KeyWord
};
model.ViewList = _workerService.Search(searchModel);
}
public IPagedList <MSDS_Worker> Search(WorkerSearchModel searchModel)
{
return(_repository.Search(searchModel));
}
