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