public ActionResult Details(int id)
        {
            FMS_tbl_AirBusDetails obj = new FMS_tbl_AirBusDetails();

            obj = db.FMS_tbl_AirBusDetails.Find(id);
            return(View(obj));
        }
        public ActionResult DeleteAirBus(FormCollection fc, int id)
        {
            FMS_tbl_AirBusDetails obj = new FMS_tbl_AirBusDetails();

            obj = db.FMS_tbl_AirBusDetails.FirstOrDefault(x => x.AirBusId == id);
            db.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
            try
            {
                db.SaveChanges();
                TempData["Message"] = "Delete successful";
                return(RedirectToAction("ViewAllAirBuses"));
            }
            catch (Exception)
            {
                ViewBag.messag = "Could not delete.This flight is already scheduled.";
                return(View(obj));
            }
        }
        public ActionResult EditAirBus(FMS_tbl_AirBusDetails obj, string Edit)
        {
            if (db.FMS_tbl_AirBusDetails.Any(x => x.Name.Equals(obj.Name)))
            {
                ViewBag.Messag = String.Format("Sorry airbus details could not be added.Name already exists.");

                return(View(obj));
            }
            else
            {
                try
                {
                    db.Entry(obj).State = System.Data.Entity.EntityState.Modified;
                    db.SaveChanges();
                    ViewBag.Message = "Changes Saved Sucessfully";
                    return(View(obj));
                }
                catch (Exception)
                {
                    ViewBag.Messag = "Flight Already Scheduled.";
                    return(View(obj));
                }
            }
        }
        public ActionResult AddAirBus(FormCollection fc, string Create)
        {
            if (Create == null)
            {
                FMS_tbl_AirBusDetails obj = new FMS_tbl_AirBusDetails();
                obj.Name = fc["Name"].ToString();
                obj.RegistrstionNumber = fc["RegistrstionNumber"].ToString();

                obj.AirBusSeries = fc["AirBusSeries"].ToString();
                List <FMS_tbl_AirBusSeries> list = db.FMS_tbl_AirBusSeries.ToList();


                ViewBag.DropDownList = getSeriesDetails();


                List <FMS_tbl_AirBusSeries> lst = db.FMS_tbl_AirBusSeries.Where(e => e.Series == obj.AirBusSeries).ToList <FMS_tbl_AirBusSeries>();
                foreach (FMS_tbl_AirBusSeries li in lst)
                {
                    obj.PremiumClassSeatingCapacity = li.PremiumClassSeatingCapacity;
                    obj.FirstClassSeatingCapacity   = li.FirstClassSeatingCapacity;
                    obj.EconomyClassSeatingCapacity = li.EconomyClassSeatingCapacity;
                    obj.TakeOffWeight      = li.MaxTakeOffWeight;
                    obj.MaximumFlightRange = li.MaxSpeed;
                }
                return(View(obj));
            }
            else
            {
                if (ModelState.IsValid)
                {
                    FMS_tbl_AirBusDetails obj = new FMS_tbl_AirBusDetails();
                    obj.Name = fc["Name"].ToString();
                    obj.RegistrstionNumber = fc["RegistrstionNumber"].ToString();

                    if (db.FMS_tbl_AirBusDetails.Any(x => x.RegistrstionNumber.Equals(obj.RegistrstionNumber)))
                    {
                        ViewBag.Messag       = String.Format("Sorry airbus details could not be added.Registration number already exists.");
                        ViewBag.DropDownList = getSeriesDetails();
                        return(View());
                    }
                    else
                    {
                        obj.DateOfCommencement          = DateTime.Parse(fc["DateOfCommencement"].ToString());
                        obj.ManufacturingDate           = DateTime.Parse(fc["ManufacturingDate"].ToString());
                        obj.AirBusSeries                = fc["AirBusSeries"].ToString();
                        obj.PremiumClassSeatingCapacity = int.Parse(fc["PremiumClassSeatingCapacity"].ToString());
                        obj.FirstClassSeatingCapacity   = int.Parse(fc["FirstClassSeatingCapacity"].ToString());
                        obj.EconomyClassSeatingCapacity = int.Parse(fc["EconomyClassSeatingCapacity"].ToString());
                        obj.TakeOffWeight               = decimal.Parse(fc["TakeOffWeight"].ToString());
                        obj.MaximumFlightRange          = decimal.Parse(fc["MaximumFlightRange"].ToString());
                        if (obj.ManufacturingDate > obj.DateOfCommencement)
                        {
                            ViewBag.Messag       = String.Format("Commencement Date Should not be below the Manufacturing date.");
                            ViewBag.DropDownList = getSeriesDetails();
                            return(View(obj));
                        }
                        else
                        {
                            db.FMS_tbl_AirBusDetails.Add(obj);
                            try
                            {
                                db.SaveChanges();
                                int AirBusId = obj.AirBusId;

                                if (AirBusId > 1)
                                {
                                    ViewBag.Message      = String.Format("Airbus details added successfully. AirBus Id is {0}", AirBusId);
                                    ViewBag.DropDownList = getSeriesDetails();
                                    return(View());
                                }
                                else
                                {
                                    ViewBag.Messag       = "Error while adding airbus. Please try again.";
                                    ViewBag.DropDownList = getSeriesDetails();
                                    return(View());
                                }
                            }
                            catch (Exception)
                            {
                                ViewBag.Messag       = "Flight Name already Exists.";
                                ViewBag.DropDownList = getSeriesDetails();
                                return(View());
                            }
                        }
                    }
                }
            }
            return(View());
        }