public async Task <FileDto> GetAllToExcel(GetSupplierInput input) { input.MaxResultCount = 10000; var allList = await GetAll(input); var allListDtos = allList.Items.MapTo <List <SupplierListDto> >(); return(_supplierExporter.ExportToFile(allListDtos)); }
public async Task <PagedResultDto <SupplierListDto> > GetPagedSuppliersAsync(GetSupplierInput input) { var query = _supplierRepository.GetAll(); var customerCount = await query.CountAsync(); var list = await query.OrderBy(input.Sorting).PageBy(input.SkipCount, input.MaxResultCount).ToListAsync(); var dtos = list.MapTo <List <SupplierListDto> >(); return(new PagedResultDto <SupplierListDto>(customerCount, dtos)); }
public async Task <PagedResultOutput <SupplierListDto> > GetAll(GetSupplierInput input) { IQueryable <Supplier> allItems; if (!string.IsNullOrEmpty(input.Operation) && input.Operation.Equals("SEARCH")) { allItems = _supplierRepo .GetAll() .WhereIf( !input.Filter.IsNullOrEmpty(), p => p.SupplierName.Equals(input.Filter) ); } else { allItems = _supplierRepo .GetAll() .WhereIf( !input.Filter.IsNullOrEmpty(), p => p.SupplierName.Contains(input.Filter) ); } var sortMenuItems = await allItems .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var allListDtos = sortMenuItems.MapTo <List <SupplierListDto> >(); var allItemCount = await allItems.CountAsync(); return(new PagedResultOutput <SupplierListDto>( allItemCount, allListDtos )); }