public async Task Execute(RefilterObservations command)
{
//delete from XBOX
var connection = writeContext.Database
.GetDbConnection()
.EnsureOpen();
using (var transaction = connection.BeginTransaction())
{
foreach (var observationKey in command.ObservationKeys)
{
string sql = @"Execute [sp_ElrReFilter] @observationKey, @userId";
await connection.ExecuteAsync(sql, new { observationKey, userId = usernameProvider.GetUsername() }, transaction);
}
transaction.Commit();
}
}
public async Task <IActionResult> ExecuteRefilter([FromBody] RefilterObservations command)
{
await elrService.Execute(command);
return(Ok());
}
