public ActionResult Create(FlightScheduleViewModel vmFlightSchedule)
        {
            vmFlightSchedule.ListFlight = (from c in db.tblFlights.ToList()
                                           select new SelectListItem
            {
                Text = c.FlightNo,
                Value = c.ID.ToString()
            }).ToList();
            vmFlightSchedule.ListRoute = (from c in db.tblRoutes.ToList()
                                          select new SelectListItem
            {
                Text = c.Departure + '-' + c.Arrival,
                Value = c.ID.ToString()
            }).ToList();

            if (ModelState.IsValid)
            {
                if (IsValid(vmFlightSchedule))
                {
                    tblFlightSchedule schedule = new tblFlightSchedule();
                    schedule.FlightID          = vmFlightSchedule.FlightID;
                    schedule.RouteID           = vmFlightSchedule.RouteID;
                    schedule.ArrivalDateTime   = vmFlightSchedule.ArrivalDateTime.Value;
                    schedule.DepartureDateTime = vmFlightSchedule.DepartureDateTime.Value;

                    db.tblFlightSchedules.Add(schedule);
                    db.SaveChanges();

                    return(RedirectToAction("Index"));
                }
            }
            return(View(vmFlightSchedule));
        }
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tblFlightSchedule tblFlightSchedule = db.tblFlightSchedules.Find(id);

            db.tblFlightSchedules.Remove(tblFlightSchedule);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }