public Task <IEnumerable <Currency> > GetAsync(CurrencySearch option, CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT *
FROM Currency c
WHERE c.Id = c.Id";
if (option.CompanyId.HasValue)
{
query += @"
AND c.CompanyId = @CompanyId";
}
if (!string.IsNullOrWhiteSpace(option.Name))
{
option.Name = Sql.GetWrappedValue(option.Name);
query += @"
AND c.Name LIKE @Name";
}
if (option.Ids?.Any() ?? false)
{
query += @"
AND c.Id IN (SELECT Id FROM @Ids)";
}
if (option.Codes?.Any() ?? false)
{
query += @"
AND c.Code IN (SELECT Code FROM @Codes)";
}
query += @"
ORDER BY c.DisplayOrder ASC
, c.CompanyId ASC
, c.Code ASC";
return(dbHelper.GetItemsAsync <Currency>(query, new {
option.CompanyId,
option.Name,
Ids = option.Ids.GetTableParameter(),
Codes = option.Codes.GetTableParameter(),
}, token));
}
public async Task <CurrenciesResult> GetItemsAsync(string SessionKey, int CompanyId, CurrencySearch CurrencySearch)
{
return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token =>
{
CurrencySearch.CompanyId = CompanyId;
var result = (await currencyProcessor.GetAsync(CurrencySearch, token)).ToList();
return new CurrenciesResult
{
ProcessResult = new ProcessResult {
Result = true
},
Currencies = result,
};
}, logger));
}
public async Task <IEnumerable <Currency> > GetAsync(CurrencySearch option, CancellationToken token = default(CancellationToken)) => await currencyQueryProcessor.GetAsync(option, token);
public async Task <ActionResult <IEnumerable <Currency> > > GetItems(CurrencySearch option, CancellationToken token) => (await currencyProcess.GetAsync(option, token)).ToArray();
