public async Task <ActionResult <ConfigurationVendor> > Update([FromBody] ConfigurationVendor _ConfigurationVendor) { ConfigurationVendor _ConfigurationVendorq = _ConfigurationVendor; try { using (var transaction = _context.Database.BeginTransaction()) { try { _ConfigurationVendorq = await(from c in _context.ConfigurationVendor .Where(q => q.ConfigurationVendorId == _ConfigurationVendor.ConfigurationVendorId) select c ).FirstOrDefaultAsync(); _context.Entry(_ConfigurationVendorq).CurrentValues.SetValues((_ConfigurationVendor)); //_context.Alert.Update(_Alertq); await _context.SaveChangesAsync(); BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora { IdOperacion = _ConfigurationVendor.ConfigurationVendorId, DocType = "ConfigurationVendor", ClaseInicial = Newtonsoft.Json.JsonConvert.SerializeObject(_ConfigurationVendorq, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }), ResultadoSerializado = Newtonsoft.Json.JsonConvert.SerializeObject(_ConfigurationVendor, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }), Accion = "Actualizar", FechaCreacion = DateTime.Now, FechaModificacion = DateTime.Now, UsuarioCreacion = _ConfigurationVendor.CreatedUser, UsuarioModificacion = _ConfigurationVendor.ModifiedUser, UsuarioEjecucion = _ConfigurationVendor.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(_ConfigurationVendorq))); }
public async Task <ActionResult <ConfigurationVendor> > Insert([FromBody] ConfigurationVendor _ConfigurationVendor) { ConfigurationVendor _ConfigurationVendorq = new ConfigurationVendor(); // Alert _Alertq = new Alert(); try { using (var transaction = _context.Database.BeginTransaction()) { try { _ConfigurationVendorq = _ConfigurationVendor; _context.ConfigurationVendor.Add(_ConfigurationVendorq); await _context.SaveChangesAsync(); BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora { IdOperacion = _ConfigurationVendor.ConfigurationVendorId, DocType = "ConfigurationVendor", ClaseInicial = Newtonsoft.Json.JsonConvert.SerializeObject(_ConfigurationVendor, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }), Accion = "Insertar", FechaCreacion = DateTime.Now, FechaModificacion = DateTime.Now, UsuarioCreacion = _ConfigurationVendor.CreatedUser, UsuarioModificacion = _ConfigurationVendor.ModifiedUser, UsuarioEjecucion = _ConfigurationVendor.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(_ConfigurationVendorq))); }
public async Task <IActionResult> GetConfigurationVendorById(Int64 ConfigurationVendorId) { ConfigurationVendor Items = new ConfigurationVendor(); try { Items = await _context.ConfigurationVendor.Where(q => q.ConfigurationVendorId == ConfigurationVendorId).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> GetConfigurationVendorActive() { ConfigurationVendor Items = new ConfigurationVendor(); try { Items = await _context.ConfigurationVendor.Where(p => p.Estado == "Activo").FirstOrDefaultAsync(); } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(BadRequest($"Ocurrio un error:{ex.Message}")); } // int Count = Items.Count(); return(await Task.Run(() => Ok(Items))); }
public async Task <IActionResult> Delete([FromBody] ConfigurationVendor _ConfigurationVendor) { ConfigurationVendor _ConfigurationVendorq = new ConfigurationVendor(); try { _ConfigurationVendorq = _context.ConfigurationVendor .Where(x => x.ConfigurationVendorId == (Int64)_ConfigurationVendor.ConfigurationVendorId) .FirstOrDefault(); _context.ConfigurationVendor.Remove(_ConfigurationVendorq); 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(_ConfigurationVendorq))); }