public async Task <ActionResult <InsurancesCertificate> > Update([FromBody] InsurancesCertificate _InsurancesCertificateP)
{
InsurancesCertificate _InsurancesCertificateq = _InsurancesCertificateP;
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_InsurancesCertificateq = await(from c in _context.InsurancesCertificate
.Where(q => q.InsurancesCertificateId == _InsurancesCertificateP.InsurancesCertificateId)
select c
).FirstOrDefaultAsync();
_context.Entry(_InsurancesCertificateq).CurrentValues.SetValues((_InsurancesCertificateP));
//_context.Alert.Update(_Alertq);
await _context.SaveChangesAsync();
BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = _InsurancesCertificateq.InsurancesCertificateId,
DocType = "Insurances",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(_InsurancesCertificateq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
ResultadoSerializado = Newtonsoft.Json.JsonConvert.SerializeObject(_InsurancesCertificateq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "Actualizar",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = _InsurancesCertificateP.CreatedUser,
UsuarioModificacion = _InsurancesCertificateP.ModifiedUser,
UsuarioEjecucion = _InsurancesCertificateP.ModifiedUser,
});
await _context.SaveChangesAsync();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
throw ex;
// return BadRequest($"Ocurrio un error:{ex.Message}");
}
}
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}")));
}
return(await Task.Run(() => Ok(_InsurancesCertificateq)));
}
public async Task <ActionResult <InsurancesCertificate> > Insert([FromBody] InsurancesCertificate _InsurancesCertificateP)
{
InsurancesCertificate _InsurancesCertificateq = new InsurancesCertificate();
// Alert _Alertq = new Alert();
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
_InsurancesCertificateq = _InsurancesCertificateP;
_context.InsurancesCertificate.Add(_InsurancesCertificateq);
await _context.SaveChangesAsync();
BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora
{
IdOperacion = _InsurancesCertificateq.InsurancesCertificateId,
DocType = "InsurancesCertificate",
ClaseInicial =
Newtonsoft.Json.JsonConvert.SerializeObject(_InsurancesCertificateq, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
}),
Accion = "Insertar",
FechaCreacion = DateTime.Now,
FechaModificacion = DateTime.Now,
UsuarioCreacion = _InsurancesCertificateP.CreatedUser,
UsuarioModificacion = _InsurancesCertificateP.ModifiedUser,
UsuarioEjecucion = _InsurancesCertificateP.ModifiedUser,
});
await _context.SaveChangesAsync();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
throw ex;
// return BadRequest($"Ocurrio un error:{ex.Message}");
}
}
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(_InsurancesCertificateq)));
}
public async Task <IActionResult> GetInsurancesCertificateByFecha([FromBody] InsurancesCertificate _InsurancesCertificateP)
{
InsurancesCertificate Items = new InsurancesCertificate();
try
{//_ExchangeRate.DayofRate.ToString("yyyy-MM-dd")
Items = await _context.InsurancesCertificate.Where(q => q.BeginDateofInsurance.ToString("yyyy-MM-dd") == _InsurancesCertificateP.BeginDateofInsurance.ToString("yyyy-MM-dd")).FirstOrDefaultAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(Items)));
}
public async Task <IActionResult> GetInsurancesCertificateById(Int64 InsurancesCertificateId)
{
InsurancesCertificate Items = new InsurancesCertificate();
try
{
Items = await _context.InsurancesCertificate.Where(q => q.InsurancesCertificateId == InsurancesCertificateId).FirstOrDefaultAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(Items)));
}
public async Task <IActionResult> Delete([FromBody] InsurancesCertificate _InsurancesCertificateP)
{
InsurancesCertificate _InsurancesCertificateq = new InsurancesCertificate();
try
{
_InsurancesCertificateq = _context.InsurancesCertificate
.Where(x => x.InsurancesCertificateId == (Int64)_InsurancesCertificateP.InsurancesCertificateId)
.FirstOrDefault();
_context.InsurancesCertificate.Remove(_InsurancesCertificateq);
await _context.SaveChangesAsync();
}
catch (Exception ex)
{
_logger.LogError($"Ocurrio un error: { ex.ToString() }");
return(BadRequest($"Ocurrio un error:{ex.Message}"));
}
return(await Task.Run(() => Ok(_InsurancesCertificateq)));
}
