public PagedResultDto <CityDto> GetAll(CityPagedSortedAndFilteredDto input) { var query = _cityRepository.GetAll(); var total = query.Count(); var result = input.Sorting != null ? query.OrderBy(input.Sorting).AsNoTracking().PageBy(input).ToList() : query.PageBy(input).ToList(); return(new PagedResultDto <CityDto>(total, ObjectMapper.Map <List <CityDto> >(result))); }
public PagedResultDto <CityDto> GetAll(CityPagedSortedAndFilteredDto input) { var query = _cityRepository.GetAll().Where(c => c.IsDeleted == false).WhereIf(!input.FilterText.IsNullOrEmpty(), c => c.CityName.Contains(input.FilterText)); var total = query.Count(); var result = input.Sorting != null ? query.OrderBy(input.Sorting).AsNoTracking().PageBy(input).ToList() : query.PageBy(input).ToList(); return(new PagedResultDto <CityDto>(total, ObjectMapper.Map <List <CityDto> >(result))); }