public List <ob_hpeli> Todos_hpelis()
        {
            listahp.Clear();
            DataTable dt = cdusu.mostrar_hpelis();

            foreach (DataRow dr in dt.Rows)
            {
                ob_hpeli hpeli = new ob_hpeli();
                hpeli.pel_id = Convert.ToInt32(dr["ID Pelicula"].ToString());
                hpeli.hor_id = Convert.ToInt32(dr["ID Horario"].ToString());
                listahp.Add(hpeli);
            }
            return(listahp);
        }
 // metodo de ingreso
 public IHttpActionResult GetHpeli(string pel_id)
 {
     try
     {
         obs = cn_usu.buscarxhpeli(pel_id);
         ob_hpeli[] lisus2 = new ob_hpeli[] {
             new ob_hpeli {
                 pel_id = obs.pel_id, hor_id = obs.hor_id
             }
         };
         return(Ok(lisus2));
     }
     catch (Exception)
     {
         HttpResponseMessage mensaje = new HttpResponseMessage();
         return(Ok(mensaje));
     }
 }
        public ob_hpeli buscarxhpeli(string hpel)
        {
            ob_hpeli hp  = new ob_hpeli();
            cd_hpeli cda = new cd_hpeli();

            hp = cda.buscarxhpeli(hpel);
            if (hp.pel_id != 0)
            {
                return(hp);
            }
            else
            {
                ob_hpeli sinna = new ob_hpeli();
                sinna.pel_id = 0;
                sinna.hor_id = 0;
                return(sinna);
            }
        }