public ActionResult DeleteConfirmed(int id)
        {
            ALQUILER aLQUILER = db.ALQUILER.Find(id);

            db.ALQUILER.Remove(aLQUILER);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "ALQ_ID,SOC_ID,PEL_ID,ALQ_FECHA_DESDE,ALQ_FECHA_HASTA,ALQ_VALOR,ALQ_FECHA_ENTREGA")] ALQUILER aLQUILER)
 {
     if (ModelState.IsValid)
     {
         db.Entry(aLQUILER).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.PEL_ID = new SelectList(db.PELICULA, "PEL_ID", "PEL_NOMBRE", aLQUILER.PEL_ID);
     ViewBag.SOC_ID = new SelectList(db.SOCIO, "SOC_ID", "SOC_CEDULA", aLQUILER.SOC_ID);
     return(View(aLQUILER));
 }
        // GET: ALQUILERs/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ALQUILER aLQUILER = db.ALQUILER.Find(id);

            if (aLQUILER == null)
            {
                return(HttpNotFound());
            }
            return(View(aLQUILER));
        }
        // GET: ALQUILERs/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ALQUILER aLQUILER = db.ALQUILER.Find(id);

            if (aLQUILER == null)
            {
                return(HttpNotFound());
            }
            ViewBag.PEL_ID = new SelectList(db.PELICULA, "PEL_ID", "PEL_NOMBRE", aLQUILER.PEL_ID);
            ViewBag.SOC_ID = new SelectList(db.SOCIO, "SOC_ID", "SOC_CEDULA", aLQUILER.SOC_ID);
            return(View(aLQUILER));
        }
        public bool guardar(int usuario_id, String vehiculo_id, DateTime fecha_alquiler)
        {
            try
            {
                ALQUILER alq = new ALQUILER();

                alq.USUARIO_CEDULA = usuario_id;
                alq.VEHICULO_PLACA = vehiculo_id;
                alq.FECHA_ALQUILER = fecha_alquiler;
                db.ALQUILER.InsertOnSubmit(alq);
                db.SubmitChanges();

                return(true);
            }
            catch (Exception ex)
            {
                Console.WriteLine("EROR" + ex);
                return(false);
            }
        }