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