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