public async Task <ActionResult <CollectionViewModel <Commodity> > > Get( string company, [FromQuery] PagingOptions pagingOptions, [FromQuery] CommoditySearchTerm commoditySearchTerm, [FromQuery] string code = null, [FromQuery] string description = null, [FromQuery] bool includeDeactivated = false, [FromQuery] string viewMode = MasterDataViewMode.Local) { if (!string.IsNullOrEmpty(code)) { commoditySearchTerm.PrincipalCommodity = code; } var commodities = await _commodityRepository.GetAllAsync(viewMode == MasterDataViewMode.Local?company : null, commoditySearchTerm, pagingOptions.Offset, null /*pagingOptions.Limit*/, includeDeactivated, description); var response = new PaginatedCollectionViewModel <Commodity>(pagingOptions.Offset.Value, pagingOptions.Limit.Value, commodities.ToList()); return(Ok(response)); }