예제 #1
0
        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));
        }
예제 #2
0
        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));
        }