public ActionResult DeleteConfirmed(int id) { FlightCrew flightCrew = db.FlightCrews.Find(id); db.FlightCrews.Remove(flightCrew); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "FlightCrewID,Pilot,CoPilot,CabinCrew")] FlightCrew flightCrew) { if (ModelState.IsValid) { db.Entry(flightCrew).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(flightCrew)); }
// GET: FlightCrews/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } FlightCrew flightCrew = db.FlightCrews.Find(id); if (flightCrew == null) { return(HttpNotFound()); } return(View(flightCrew)); }
public SelectList GetAllFlights(FlightCrew flight) //COMMITTEE ALREADY CHOSEN { //populate list of committees var query = from c in db.Flights orderby c.FlightID select c; //create list and execute query List <Flight> allFlights = query.ToList(); //convert to select list SelectList list = new SelectList(allFlights, "FLightID", "FlightNumberDate", flight.Flight.FlightID); return(list); }
public ActionResult Create([Bind(Include = "FlightCrewID,Pilot,CoPilot,CabinCrew")] FlightCrew flightCrew, Int32 FlightID) { Flight SelectedFlight = db.Flights.Find(FlightID); flightCrew.Flight = SelectedFlight; if (ModelState.IsValid) { db.FlightCrews.Add(flightCrew); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AllFlights = GetAllFlights(flightCrew); return(View(flightCrew)); }
public SelectList GetAllCabin(FlightCrew cabin) //COMMITTEE ALREADY CHOSEN { //populate list of committees var query = from c in db.Users where c.EmployeeType == EmpType.Cabin orderby c.Email select c; //create list and execute query List <AppUser> allCabins = query.ToList(); //convert to select list SelectList list = new SelectList(allCabins, "Email", "Email", cabin.CabinCrew); return(list); }
public ActionResult Assign(FlightCrewID crewid) { if (ModelState.IsValid) { List <FlightCrew> fcList = new List <FlightCrew>(); List <int> idlist = crewid.fcID(); List <String> Roles = new List <String>() { "Flight Captain", "Second Pilot", "Flight Crew Leader", "Flight Attendant" }; for (int i = 0; i < idlist.Count(); i++) { FlightCrew fc = new FlightCrew(); int index = i; if (i > 2) { index = 3; } fc.Role = Roles[index]; fc.StaffID = idlist[i]; fc.ScheduleID = (int)TempData.Peek("scheduleid"); fcList.Add(fc); Debug.WriteLine(Roles[index]); Debug.WriteLine(idlist[i]); Debug.WriteLine(TempData["scheduleid"]); Debug.WriteLine(fc.StaffID); } int rows = crewContext.Assign(fcList, idlist); System.Diagnostics.Debug.WriteLine("Rows Affected:" + rows); if (rows > 0) { return(RedirectToAction("Index")); } else if (rows == -1) { TempData["ErrorMessage"] = "You entered the same staff twice!"; return(RedirectToAction("Assign")); } } return(RedirectToAction("Assign")); }