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();