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());
        }
Пример #3
0
        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());
        }
Пример #4
0
        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));
        }
Пример #5
0
        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));
        }