public async Task <ActionResult <ColorsDetailQuotation> > Update([FromBody] ColorsDetailQuotation _ColorsDetailQuotation) { ColorsDetailQuotation _ColorsDetailQuotationq = _ColorsDetailQuotation; try { using (var transaction = _context.Database.BeginTransaction()) { try { _ColorsDetailQuotationq = await(from c in _context.ColorsDetailQuotation .Where(q => q.ColorsDetailQuotationId == _ColorsDetailQuotation.ColorsDetailQuotationId) select c ).FirstOrDefaultAsync(); _context.Entry(_ColorsDetailQuotationq).CurrentValues.SetValues((_ColorsDetailQuotation)); await _context.SaveChangesAsync(); BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora { IdOperacion = _ColorsDetailQuotationq.ColorsDetailQuotationId, DocType = "ColorsDetailQuotation", ClaseInicial = Newtonsoft.Json.JsonConvert.SerializeObject(_ColorsDetailQuotationq, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }), Accion = "Actualizar", FechaCreacion = DateTime.Now, FechaModificacion = DateTime.Now, UsuarioCreacion = _ColorsDetailQuotationq.UsuarioCreacion, UsuarioModificacion = _ColorsDetailQuotationq.UsuarioModificacion, UsuarioEjecucion = _ColorsDetailQuotationq.UsuarioModificacion, }); await _context.SaveChangesAsync(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); _logger.LogError($"Ocurrio un error: { ex.ToString() }"); throw ex; } } } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(BadRequest($"Ocurrio un error:{ex.Message}")); } return(await Task.Run(() => Ok(_ColorsDetailQuotationq))); }
public async Task <IActionResult> GetColorsDetailQuotationById(Int64 ColorsDetailQuotationId) { ColorsDetailQuotation Items = new ColorsDetailQuotation(); try { Items = await _context.ColorsDetailQuotation.Where(q => q.ColorsDetailQuotationId == ColorsDetailQuotationId).FirstOrDefaultAsync(); } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(BadRequest($"Ocurrio un error:{ex.Message}")); } return(await Task.Run(() => Ok(Items))); }