public ActionResult DeleteConfirmed(int id)
        {
            Route_Reservation route_Reservation = db.Route_Reservation.Find(id);

            db.Route_Reservation.Remove(route_Reservation);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "recordID,resID,flightID,type,customer")] Route_Reservation route_Reservation)
 {
     if (ModelState.IsValid)
     {
         db.Entry(route_Reservation).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.customer = new SelectList(db.Customers, "custID", "firstName", route_Reservation.customer);
     ViewBag.flightID = new SelectList(db.Flights, "flightID", "aircID", route_Reservation.flightID);
     return(View(route_Reservation));
 }
        // GET: Route_Reservation/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Route_Reservation route_Reservation = db.Route_Reservation.Find(id);

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

            if (route_Reservation == null)
            {
                return(HttpNotFound());
            }
            ViewBag.customer = new SelectList(db.Customers, "custID", "firstName", route_Reservation.customer);
            ViewBag.flightID = new SelectList(db.Flights, "flightID", "aircID", route_Reservation.flightID);
            return(View(route_Reservation));
        }
        // GET: Flights/Details/5
        public ActionResult Book(string id)
        {
            if (UIA_FlightBookingWebApplication.Models.Customer.loginCustomer[0] == null)
            {
                TempData["HasLoginUser"] = false;
                return(RedirectToAction("ViewAvailableFlight", "Flights"));
            }

            string resID = (from a in db.Route_Reservation
                            orderby a.resID descending
                            select a.resID).FirstOrDefault();

            string[] tokens     = null;
            string   finalResID = null;

            if (resID != null)
            {
                //tokens = resID.Split(new[] { "Res" }, StringSplitOptions.None);
                tokens = resID.Split(new [] { "Res" }, StringSplitOptions.None);
                int previousResID = Int32.Parse(tokens[1]);
                int currentResID  = previousResID + 1;
                finalResID = "Res" + currentResID;
            }

            string flightID = id;
            string type     = "Oneway";
            int    custID   = UIA_FlightBookingWebApplication.Models.Customer.loginCustomer[0].custID;
            string custIDs  = "" + custID;

            //TempData["ResID"] = finalResID;
            ////TempData["ResID"] = finalResID;
            //TempData["FlightID"] = flightID;
            //TempData["Type"] = type;
            //TempData["CustID"] = custIDs;

            Route_Reservation rr = new Route_Reservation();

            rr.resID    = finalResID;
            rr.flightID = flightID;
            rr.type     = type;
            rr.customer = custID;

            db.Route_Reservation.Add(rr);
            db.SaveChanges();

            return(RedirectToAction("ViewAvailableFlight", "Flights"));

            //db.Flights.Add(flight);
            //db.SaveChanges();
            //return RedirectToAction("Index");


            //if (id == null)
            //{
            //    return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
            //}
            //Flight flight = db.Flights.Find(id);
            //if (flight == null)
            //{
            //    return HttpNotFound();
            //}
            //return View(flight);
            return(RedirectToAction("ViewAvailableFlight", "Flights"));
        }