public Task <IEnumerable <BillingDivisionContract> > GetItemsAsync(
BillingDivisionContractSearch option,
CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT *
FROM BillingDivisionContract c
WHERE c.Id = c.Id";
if (option.CompanyId.HasValue)
{
query += @"
AND c.CompanyId = @CompanyId";
}
if (option.CustomerId.HasValue)
{
query += @"
AND c.CustomerId = @CustomerId";
}
if (!string.IsNullOrWhiteSpace(option.ContractNumber))
{
query += @"
AND c.ContractNumber = @ContractNumber";
}
if (option.CustomerIds?.Any() ?? false)
{
query += @"
AND c.CustomerId IN (SELECT Id FROM @CustomerIds)";
}
if (option.BillingIds?.Any() ?? false)
{
query += @"
AND c.BillingId IN (SELECT Id FROM @BillingIds)";
}
query += @"
ORDER BY c.CompanyId ASC
, c.CustomerId ASC
, c.ContractNumber ASC";
return(dbHelper.GetItemsAsync <BillingDivisionContract>(query, new {
option.CompanyId,
option.CustomerId,
option.ContractNumber,
CustomerIds = option.CustomerIds.GetTableParameter(),
BillingIds = option.BillingIds.GetTableParameter(),
}, token));
}
public async Task <ActionResult <IEnumerable <BillingDivisionContract> > > GetItems(BillingDivisionContractSearch option, CancellationToken token) => (await billingDivisionContractProcessor.GetAsync(option, token)).ToArray();
public async Task <IEnumerable <BillingDivisionContract> > GetAsync(BillingDivisionContractSearch option, CancellationToken token = default(CancellationToken)) => await billingDivisionContractQueryProcessor.GetItemsAsync(option, token);
