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