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")); }