public async Task <AccountTitlesResult> GetItemsAsync(string SessionKey, AccountTitleSearch searchOption) { return(await authorizationProcessor.DoAuthorizeAsync(SessionKey, async token => { var result = (await accountTitleProcessor.GetAsync(searchOption, token)).ToList(); return new AccountTitlesResult { ProcessResult = new ProcessResult { Result = true }, AccountTitles = result, }; }, logger)); }
public Task <IEnumerable <AccountTitle> > GetAsync(AccountTitleSearch option, CancellationToken token = default(CancellationToken)) { var query = @" SELECT * FROM AccountTitle at WHERE at.Id = at.Id"; if (option.CompanyId.HasValue) { query += @" AND at.CompanyId = @CompanyId"; } if (option.Ids?.Any() ?? false) { query += @" AND at.Id IN (SELECT Id FROM @Ids)"; } if (option.Codes?.Any() ?? false) { query += @" AND at.Code IN (SELECT Code FROM @Codes)"; } if (!string.IsNullOrWhiteSpace(option.Name)) { option.Name = Sql.GetWrappedValue(option.Name); query += @" AND at.Name LIKE @Name"; } query += @" ORDER BY at.CompanyId ASC , at.Code ASC"; return(dbHelper.GetItemsAsync <AccountTitle>(query, new { option.CompanyId, Ids = option.Ids.GetTableParameter(), Codes = option.Codes.GetTableParameter(), option.Name, }, token)); }
public Task <IEnumerable <AccountTitle> > GetAsync(AccountTitleSearch option, CancellationToken token = default(CancellationToken)) => accountTitleQueryProcessor.GetAsync(option, token);
public async Task <ActionResult <IEnumerable <AccountTitle> > > Get(AccountTitleSearch option, CancellationToken token) => (await accountTitleProcessor.GetAsync(option, token)).ToArray();