public async Task <IActionResult> SalvarAcomodacao([FromBody] AcomodacaoItem acomodacaoToSave) { //AREA DE VALIDACAO string msgRule = ""; if (!ruleValidaCodExternoAcomodacao(acomodacaoToSave.CodExterno_Acomodacao, ref msgRule)) { return(BadRequest(msgRule)); } if (!ruleValidaNomeAcomodacao(acomodacaoToSave.Nome_Acomodacao, ref msgRule)) { return(BadRequest(msgRule)); } //FIM AREA DE VALIDACAO if (_administrativoContext.Set <AcomodacaoItem>().Any(e => e.Id_Acomodacao == acomodacaoToSave.Id_Acomodacao)) { _administrativoContext.AcomodacaoItems.Update(acomodacaoToSave); } else { _administrativoContext.AcomodacaoItems.Add(acomodacaoToSave); } //Create Integration Event to be published through the Event Bus var acomodacaoSaveEvent = new AcomodacaoSaveIE(acomodacaoToSave.Nome_Acomodacao, acomodacaoToSave.Id_TipoAcomodacao, acomodacaoToSave.Id_Empresa, acomodacaoToSave.Id_Setor, acomodacaoToSave.CodExterno_Acomodacao, acomodacaoToSave.Cod_Isolamento); try { // Achieving atomicity between original Catalog database operation and the IntegrationEventLog thanks to a local transaction await _administrativoIntegrationEventService.SaveEventAndAcomodacaoContextChangesAsync(acomodacaoSaveEvent, acomodacaoToSave); } catch (Exception e) { //Validações das CONSTRAINTS do BANCO if (ruleValidaNomeAcomodacaoUnique(e.Message, ref msgRule)) { return(BadRequest(msgRule)); } else { return(BadRequest(e.Message)); } } // Publish through the Event Bus and mark the saved event as published await _administrativoIntegrationEventService.PublishThroughEventBusAsync(acomodacaoSaveEvent); return(CreatedAtAction(nameof(SalvarAcomodacao), acomodacaoToSave.Id_Acomodacao)); }
public async Task SaveEventAndAcomodacaoContextChangesAsync(IntegrationEvent evt, AcomodacaoItem acomodacaoToSave) { var strategy = _administrativoContext.Database.CreateExecutionStrategy(); await strategy.ExecuteAsync(async() => { using (var transaction = _administrativoContext.Database.BeginTransaction()) { try { await _administrativoContext.SaveChangesAsync(); //Tratamento de Identity ((Events.AcomodacaoSaveIE)evt).AcomodacaoId = acomodacaoToSave.Id_Acomodacao; await _eventLogService.SaveEventAsync(evt, _administrativoContext.Database.CurrentTransaction.GetDbTransaction()); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); var sqlException = ex.InnerException as System.Data.SqlClient.SqlException; throw new Exception(sqlException.Number + "::" + sqlException.Message); } } }); }