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