protected override IQueryable <FoodMaterialCategory> CreateFilteredQuery(SortSearchPagedResultRequestDto input) { var query = base.CreateFilteredQuery(input); if (input.Search.IsNotNullOrEmpty()) { query = from c in query where EF.Functions.Like(c.Name, $"%{input.Search}%") select c; } return(query); }
public async Task <IActionResult> Index(int pageNumber = 1, int pageSize = PagedResultVM.DEFAULT_PAGE_SIZE, CancellationToken cancellationToken = default(CancellationToken)) { var reqestDto = new SortSearchPagedResultRequestDto() { Sorting = "Name", MaxResultCount = pageSize, SkipCount = (pageNumber * pageSize) - pageSize }; var vm = (await _appService.GetAll(reqestDto)) .ToPagedResultVM(pageNumber, pageSize); return(View(vm)); }
protected override IQueryable <SixMan.ChiMa.Domain.Dish.Dish> CreateFilteredQuery(SortSearchPagedResultRequestDto input) { var query = base.CreateFilteredQuery(input); if (input.Search.IsNotNullOrEmpty()) { query = from c in query where EF.Functions.Like(c.Description, $"%{input.Search}%") select c; } return(query); }