public async Task <IActionResult> GetProductGroupFilter([FromQuery] ProductGroupFilterDto filter) { return(Ok(await _productGroupService.GetProductGroupFilter(filter))); }
public async Task <ServiceResponseWithPagination <List <GetProductGroupDto> > > GetProductGroupFilter(ProductGroupFilterDto filter) { var queryable = _dbContext.ProductGroups.Include(x => x.User).AsQueryable(); //Filter if (!string.IsNullOrWhiteSpace(filter.Name) && filter.Name != "") { queryable = queryable.Where(x => x.Name.Contains(filter.Name)); } if (filter.IsActive != null) { queryable = queryable.Where(x => x.IsActive.Equals(filter.IsActive)); } //Ordering if (!string.IsNullOrWhiteSpace(filter.OrderingField)) { try { queryable = queryable.OrderBy($"{filter.OrderingField} {(filter.AscendingOrder ? "ascending" : "descending")}"); } catch { return(ResponseResultWithPagination.Failure <List <GetProductGroupDto> >($"Could not order by field: {filter.OrderingField}")); } } var paginationResult = await _httpContext.HttpContext .InsertPaginationParametersInResponse(queryable, filter.RecordsPerPage, filter.Page); var ProductGroup = await queryable.Paginate(filter).ToListAsync(); var dto = _mapper.Map <List <GetProductGroupDto> >(ProductGroup); return(ResponseResultWithPagination.Success(dto, paginationResult)); }