public async Task <HttpResponseMessage> PutEventosGuiaInspeccion(EventoGuiaInspeccion EventosGuiaInspeccion)
        {
            using (db = new DBConnection())
            {
                try
                {
                    _eventosGuiaInspeccion = await db.EventosGuiaInspeccion.FindAsync(EventosGuiaInspeccion.IdEventosGuiaInspeccion);

                    if (_eventosGuiaInspeccion == null)
                    {
                        return(new HttpResponseMessage(HttpStatusCode.NoContent));
                    }
                    else
                    {
                        DateTime initialDate = DateTime.ParseExact(_eventosGuiaInspeccion.FechaInicio.ToString("yyyy-MM-dd ") + EventosGuiaInspeccion.FechaInicio, "yyyy-MM-dd HH:mm", null);
                        DateTime finalDate   = DateTime.ParseExact(_eventosGuiaInspeccion.FechaInicio.ToString("yyyy-MM-dd ") + EventosGuiaInspeccion.FechaFin, "yyyy-MM-dd HH:mm", null);

                        _eventosGuiaInspeccion.FechaInicio      = initialDate;
                        _eventosGuiaInspeccion.FechaFin         = finalDate;
                        _eventosGuiaInspeccion.IdCatalogoEvento = EventosGuiaInspeccion.IdCatalogoEvento;

                        await db.SaveChangesAsync();

                        return(new HttpResponseMessage(HttpStatusCode.OK));
                    }
                }
                catch (Exception ex)
                {
                    return(new HttpResponseMessage(HttpStatusCode.InternalServerError)
                    {
                        Content = new StringContent(ex.Message)
                    });
                }
            }
        }
        public async Task <HttpResponseMessage> DeleteEventosGuiaInspeccion(IdModelEventosGuiaInspeccion id)
        {
            using (db = new DBConnection())
            {
                try
                {
                    _eventosGuiaInspeccion = await db.EventosGuiaInspeccion.FindAsync(id.IdEventosGuiaInspeccion);

                    if (_eventosGuiaInspeccion == null)
                    {
                        return(new HttpResponseMessage(HttpStatusCode.NoContent));
                    }
                    else
                    {
                        _eventosGuiaInspeccion.Activo_Inactivo = false;
                        db.Entry(_eventosGuiaInspeccion).State = EntityState.Modified;
                        await db.SaveChangesAsync();

                        return(new HttpResponseMessage(HttpStatusCode.OK));
                    }
                }
                catch (Exception ex)
                {
                    return(new HttpResponseMessage(HttpStatusCode.InternalServerError)
                    {
                        Content = new StringContent(ex.Message)
                    });
                }
            }
        }
        public async Task <HttpResponseMessage> GetEventosGuiaInspeccion(IdModelEventosGuiaInspeccion id)
        {
            using (db = new DBConnection())
            {
                try
                {
                    _eventosGuiaInspeccion = await db.EventosGuiaInspeccion.FindAsync(id.IdEventosGuiaInspeccion);

                    if (_eventosGuiaInspeccion == null)
                    {
                        return(new HttpResponseMessage(HttpStatusCode.NoContent));
                    }
                    else
                    {
                        return(new HttpResponseMessage(HttpStatusCode.OK)
                        {
                            Content = new StringContent(JsonConvert.SerializeObject(_eventosGuiaInspeccion))
                        });
                    }
                }
                catch (Exception ex)
                {
                    return(new HttpResponseMessage(HttpStatusCode.InternalServerError)
                    {
                        Content = new StringContent(ex.Message)
                    });
                }
            }
        }
        public async Task <HttpResponseMessage> PostEventosGuiaInspeccion(EventoGuiaInspeccion EventosGuiaInspeccion)
        {
            using (db = new DBConnection())
            {
                try
                {
                    var guiHeader = await db.GuiaInspeccion.FindAsync(EventosGuiaInspeccion.IdGuiaInspeccion).ConfigureAwait(false);

                    if (guiHeader != null)
                    {
                        DateTime initialDate = DateTime.ParseExact(guiHeader.FechaHora_GuiaInpeccion.ToString("yyyy-MM-dd ") + EventosGuiaInspeccion.FechaInicio, "yyyy-MM-dd HH:mm", null);
                        DateTime finalDate   = DateTime.ParseExact(guiHeader.FechaHora_GuiaInpeccion.ToString("yyyy-MM-dd ") + EventosGuiaInspeccion.FechaFin, "yyyy-MM-dd HH:mm", null);

                        EventosGuiaInspeccion _eventosGuia = new EventosGuiaInspeccion();
                        _eventosGuia.Activo_Inactivo  = true;
                        _eventosGuia.FechaFin         = finalDate;
                        _eventosGuia.FechaInicio      = initialDate;
                        _eventosGuia.IdCatalogoEvento = EventosGuiaInspeccion.IdCatalogoEvento;
                        _eventosGuia.IdGuiaInspeccion = EventosGuiaInspeccion.IdGuiaInspeccion;

                        EventosGuiaInspeccion.Activo_Inactivo = true;
                        db.EventosGuiaInspeccion.Add(_eventosGuia);
                        await db.SaveChangesAsync();

                        return(new HttpResponseMessage(HttpStatusCode.OK));
                    }
                    else
                    {
                        return(new HttpResponseMessage(HttpStatusCode.InternalServerError)
                        {
                            Content = new StringContent("Guia de inspección no encontrada.")
                        });
                    }
                }
                catch (Exception ex)
                {
                    return(new HttpResponseMessage(HttpStatusCode.InternalServerError)
                    {
                        Content = new StringContent(ex.Message)
                    });
                }
            }
        }