public async Task <ActionResult <ScheduleSubservices> > Update([FromBody] ScheduleSubservices _ScheduleSubservices) { ScheduleSubservices _ScheduleSubservicesq = _ScheduleSubservices; try { using (var transaction = _context.Database.BeginTransaction()) { try { _ScheduleSubservicesq = await(from c in _context.ScheduleSubservices .Where(q => q.ScheduleSubservicesId == _ScheduleSubservices.ScheduleSubservicesId) select c ).FirstOrDefaultAsync(); _context.Entry(_ScheduleSubservicesq).CurrentValues.SetValues((_ScheduleSubservices)); //_context.ScheduleSubservices.Update(_ScheduleSubservicesq); await _context.SaveChangesAsync(); BitacoraWrite _write = new BitacoraWrite(_context, new Bitacora { IdOperacion = _ScheduleSubservicesq.ScheduleSubservicesId, DocType = "ScheduleSubservices", ClaseInicial = Newtonsoft.Json.JsonConvert.SerializeObject(_ScheduleSubservicesq, new JsonSerializerSettings { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }), Accion = "Update", FechaCreacion = DateTime.Now, FechaModificacion = DateTime.Now, UsuarioCreacion = _ScheduleSubservicesq.UsuarioCreacion, UsuarioModificacion = _ScheduleSubservicesq.UsuarioModificacion, UsuarioEjecucion = _ScheduleSubservicesq.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(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}"))); } return(await Task.Run(() => Ok(_ScheduleSubservicesq))); }
public async Task <IActionResult> GetScheduleSubservicesById(Int64 ScheduleSubservicesId) { ScheduleSubservices Items = new ScheduleSubservices(); try { Items = await _context.ScheduleSubservices.Where(q => q.ScheduleSubservicesId == ScheduleSubservicesId).FirstOrDefaultAsync(); } 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(Items))); }