public ActionResult AllotmentOfPlanes(PlanesAllotments hangar) { AllDbContext db = new AllDbContext(); var user = db.Hangars.Where(n => n.HangerName == hangar.HangarName); var planeUser = db.Planes.Where(n => n.PlaneID == hangar.PlaneID); if (ModelState.IsValid) { foreach (var i in user) { i.isPlaneAllocated = true; } foreach (var j in planeUser) { j.isAllotted = true; } hangar.isPlaneAllocated = true; hangar.ManagerID = User.Identity.GetUserName().ToString(); db.Entry(hangar).State = EntityState.Added; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.HangarName = new SelectList(db.Hangars.Where(n => n.isPlaneAllocated == false && n.isActive == true), "HangerName", "HangerName"); ViewBag.PlaneID = new SelectList(db.Planes.Where(n => n.isAllotted == false), "PlaneID", "planeID"); return(View(hangar)); }
public ActionResult FlightDetailsUpdate(FlightPlanDetails flight) { if (ModelState.IsValid) { AllDbContext context = new AllDbContext(); PlanesDbContext db = new PlanesDbContext(); ViewBag.PlaneID = new SelectList(db.Planes.Where(n => n.isAllotted == false), "PlaneID", "PlaneID"); var items = context.Planes.Where(n => n.isAllotted == false); ViewBag.PlaneId = items; if (items != null) { ViewBag.data = items; } var pilot = db.Planes.Where(n => n.PlaneID == flight.PlaneID); foreach (var i in pilot) { i.isAllotted = true; } flight.isActive = true; flight.PilotID = User.Identity.GetUserName(); context.Flights.Add(flight); db.SaveChanges(); context.SaveChanges(); TempData["savedFlight"] = "Flight Details Added to Database Sucessfull!"; return(RedirectToAction("Index", "Pilot")); } return(View()); }
public ActionResult AddHangar(HangarDetails hangar) { if (ModelState.IsValid) { AllDbContext context = new AllDbContext(); var isUnique = context.Hangars.Where(n => n.HangerName == hangar.HangerName); AdminDbContext db = new AdminDbContext(); foreach (var i in isUnique) { if (i.HangerName == hangar.HangerName) { ViewData["HError"] = "Hangar Name Already Exists"; return(View(hangar)); } } ViewBag.AdminID = new SelectList(db.Admin, "AdminID", "AdminID"); var items = context.Admins.Select(n => n.AdminID); if (items != null) { ViewBag.data = items; } hangar.AdminID = User.Identity.GetUserName(); context.Hangars.Add(hangar); context.SaveChanges(); TempData["hangarSaved"] = "Hangar Details Added to Database Successfully"; return(RedirectToAction("Hangars", "Admin")); } return(View()); }
public ActionResult AddSchedule(PilotSchedule ps) { var db = new AllDbContext(); if (ModelState.IsValid) { db.Entry(ps).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.PilotID = new SelectList(db.Pilots, "PilotID", "PilotID", ps.PilotID); return(View(ps)); }
public ActionResult UpdateHangar(HangarDetails hangar) { var db = new AllDbContext(); var entry = db.Entry(hangar); if (ModelState.IsValid) { entry.State = EntityState.Modified; db.SaveChanges(); TempData["HangarUpdate"] = "Hangar Details Updated Successfully"; return(RedirectToAction("Hangars", "Admin")); } return(View(entry)); }