public Task <IEnumerable <LogData> > GetItemsAsync(LogDataSearch option, CancellationToken token = default(CancellationToken))
{
var query = @"
SELECT *
FROM LogData
WHERE CompanyId = @CompanyId ";
if (option.LoggedAtFrom.HasValue)
{
query += @"
AND LogData.LoggedAt >= @LoggedAtFrom";
}
if (option.LoggedAtTo.HasValue)
{
query += @"
AND LogData.LoggedAt <= @LoggedAtTo";
}
if (!string.IsNullOrEmpty(option.LoginUserCode))
{
query += @"
AND LogData.LoginUserCode = @LoginUserCode ";
}
query += @"
ORDER BY LoggedAt DESC";
return(dbHelper.GetItemsAsync <LogData>(query, option, token));
}
public async Task <ActionResult <IEnumerable <LogData> > > GetItems(LogDataSearch option, CancellationToken token) => (await logDataProcessor.GetItemsAsync(option, token)).ToArray();
public async Task <IEnumerable <LogData> > GetItemsAsync(LogDataSearch option, CancellationToken token = default(CancellationToken)) => await logdataByCompanyIdQueryProcessor.GetItemsAsync(option, token);
