public async Task <ActionResult <CollectionViewModel <ContractToBeInvoicedSearchResultDto> > > FindContractsToInvoice(string company, [FromQuery] int type, [FromQuery] string filterParameter, [FromQuery] DateTime?periodFromDate, [FromQuery] DateTime?periodToDate) { InvoiceSearchDto invoiceSearch = new InvoiceSearchDto { Type = type, FilterParameter = filterParameter, PeriodFrom = periodFromDate, PeriodTo = periodToDate }; var result = await _invoiceQueries.FindContractToInvoiceByReferenceAsync(invoiceSearch, company); var response = new CollectionViewModel <ContractToBeInvoicedSearchResultDto>(result.ToList()); return(Ok(response)); }
public Task <IEnumerable <ContractToBeInvoicedSearchResultDto> > FindContractToInvoiceByReferenceAsync(InvoiceSearchDto invoiceSearch, string company) { var queryParameters = new DynamicParameters(); queryParameters.Add("@FilterParameter", invoiceSearch.FilterParameter); queryParameters.Add("@E_Type", invoiceSearch.Type); queryParameters.Add("@PeriodFrom", invoiceSearch.PeriodFrom); queryParameters.Add("@PeriodTo", invoiceSearch.PeriodTo); queryParameters.Add("@companyId", company); return(ExecuteQueryAsync <ContractToBeInvoicedSearchResultDto>( StoredProcedureNames.FindGoodsContractByContractIdToBeInvoiced, queryParameters)); }