private Expression <Func <SiteService, bool> > FilterSiteService(SiteServiceCriteria criteria) { Expression <Func <SiteService, bool> > result = t => true; if (!string.IsNullOrWhiteSpace(criteria.Keyword)) { result = result.And(t => EF.Functions.Like(t.SiteName, $"%{criteria.Keyword}%")); } return(result); }
public SearchResult <SiteServiceModel> SearchSiteService(SiteServiceCriteria criteria) { var result = new SearchResult <SiteServiceModel>(); var query = siteServiceRepository.GetAll().Include(t => t.AuthenUser).Include(t => t.Connection).AsQueryable(); result.ItemCount = query.Count(); query = query.Sort(criteria.Sorting, new Sorting("SiteName", SortDirection.Ascending)); query = query.Page(criteria.Paging); result.ResultData = query.Select(siteServiceToModel).ToList(); return(result); }
public IActionResult SearchSiteService(SiteServiceCriteria criteria) { var result = siteServiceService.SearchSiteService(criteria); return(Ok(new SuccessResult(result))); }