public async Task <Action[]> FindActionsByAccountsAsync(ActionQuery query, int[] accounts)
{
if (accounts.Length == 0)
{
return(new Action[0]);
}
using (var connection = new SqlConnection("Data Source=.;Integrated Security=true;Initial Catalog=dbTrackAction"))
{
var actions = await connection.QueryAsync <Action>(
" SELECT " +
(query.Top.HasValue ? $" TOP {query.Top.Value} " : "") +
" action_id as ActionId, action_dtm as ActionDateTime" +
" FROM [fn_ActionSearchByAccountsColumnStore](@Accounts, @CompanyId, @DateMin, @DateMax)" +
" ORDER BY action_dtm DESC",
new
{
Accounts = AsTableValuedParameter(accounts),
query.CompanyId,
DateMin = query.Min,
DateMax = query.Max
});
return(actions.ToArray());
}
}
public async Task <Action[]> FindActionsAsync(ActionQuery query)
{
var i = _counter++;
Console.WriteLine($"[{_sw.Elapsed}] [{i}] FindActionsAsync invoking");
try
{
return(await _searchServices.FindActionsAsync(query));
}
finally
{
Console.WriteLine($"[{_sw.Elapsed}] [{i}] FindActionsAsync invoked");
}
}
public async Task <Action[]> FindActionsAsync(ActionQuery query)
{
using (var connection = new SqlConnection("Data Source=.;Integrated Security=true;Initial Catalog=dbTrackAction"))
{
var actions = await connection.QueryAsync <Action>(
" SELECT " +
(query.Top.HasValue ? $" TOP {query.Top.Value} " : "") +
" action_id as ActionId, action_dtm as ActionDateTime" +
" FROM [fn_ActionSearch](@CompanyId, @DateMin, @DateMax)" +
" ORDER BY action_dtm DESC",
new
{
query.CompanyId,
DateMin = query.Min,
DateMax = query.Max
});
return(actions.ToArray());
}
}