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