public ActionResult AddBonusMiles(FormCollection fc, string create) { FMS_tbl_BonusMilesDEtails obj = new FMS_tbl_BonusMilesDEtails(); if (create == null) { int distance = 0; obj.FlightScheduleId = int.Parse(fc["FlightScheduleId"].ToString()); List <FMS_tbl_FlightScheduleDetails> list = db.FMS_tbl_FlightScheduleDetails.ToList(); foreach (FMS_tbl_FlightScheduleDetails items in list) { if (items.FlightScheduleId.Equals(obj.FlightScheduleId)) { distance = (int)items.Distance; } } ViewBag.list = getFlightName(); obj.BonusMiles = Convert.ToInt32(distance * 0.25); TempData["BonusMiles"] = obj.BonusMiles; return(View(obj)); } else { try { obj.FlightScheduleId = int.Parse(fc["FlightScheduleId"].ToString()); obj.BonusMiles = int.Parse(fc["BonusMiles"].ToString()); } catch (Exception) { ViewBag.Messag = "Flight Name or Bonus Miles Shouldn't be Empty."; ViewBag.list = getFlightName(); return(View()); } List <FMS_tbl_BonusMilesDEtails> li = db.FMS_tbl_BonusMilesDEtails.ToList(); foreach (FMS_tbl_BonusMilesDEtails item in li) { if (obj.FlightScheduleId.Equals(item.FlightScheduleId)) { ViewBag.Msg = "Already Added Miles For this Flight"; ViewBag.list = getFlightName(); return(View()); } } if (obj.BonusMiles > (int)TempData["BonusMiles"]) { ViewBag.Msg = "Value of Bonus Miles should be below the value which is populated."; ViewBag.list = getFlightName(); return(View()); } else { db.FMS_tbl_BonusMilesDEtails.Add(obj); db.SaveChanges(); int id = obj.BonusMilesId; if (id > 1) { ViewBag.Msg = "Miles added Sucessfully"; ViewBag.list = getFlightName(); return(View()); } else { ViewBag.Msg = "Error while adding Miles"; ViewBag.list = getFlightName(); return(View()); } } } }
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()); }
public ActionResult AddFlightSchedule(string create, string Flight, FormCollection fc) { if (create == null) { if (Flight == "") { ViewBag.ddlFlight = new SelectList(db.FMS_tbl_AirBusDetails, "Name", "Name"); string depName = fc["DeparturePlace"].ToString(); List <string> list = new List <string>() { "Delhi", "Kolkata", "Trivandrum", "Chennai", "Bangalore", "Mumbai" }; ViewBag.ddlDeparturePlace = new SelectList(list, depName); List <string> li = new List <string>(); foreach (string item in list) { if (item.Equals(depName)) { continue; } else { li.Add(item); } } ViewBag.ddlDestinationPlace = new SelectList(li); return(View()); } else { FMS_tbl_FlightScheduleDetails obj = new FMS_tbl_FlightScheduleDetails(); obj.DestinationPlace = fc["DestinationPlace"].ToString(); obj.DeparturePlace = fc["DeparturePlace"].ToString(); List <string> list = new List <string>() { "Delhi", "Kolkata", "Trivandrum", "Chennai", "Bangalore", "Mumbai" }; ViewBag.ddlDestinationPlace = new SelectList(list, obj.DestinationPlace); ViewBag.ddlDeparturePlace = new SelectList(list, obj.DeparturePlace); ViewBag.ddlFlight = new SelectList(db.FMS_tbl_AirBusDetails, "Name", "Name"); obj.Flight = fc["Flight"].ToString(); List <FMS_tbl_AirBusDetails> lst1 = db.FMS_tbl_AirBusDetails.Where(e => e.Name == obj.Flight).ToList <FMS_tbl_AirBusDetails>(); foreach (FMS_tbl_AirBusDetails li in lst1) { obj.PremiumClassSeatingAvailability = li.PremiumClassSeatingCapacity; obj.FirstClassSeatingAvailability = li.FirstClassSeatingCapacity; obj.EconomyClassSeatingAvailability = li.EconomyClassSeatingCapacity; obj.AirBusId = li.AirBusId; } return(View(obj)); } } else { if (ModelState.IsValid) { FMS_tbl_FlightScheduleDetails obj = new FMS_tbl_FlightScheduleDetails(); try { obj.Flight = fc["Flight"].ToString(); obj.DeparturePlace = fc["DeparturePlace"].ToString(); obj.DestinationPlace = fc["DestinationPlace"].ToString(); obj.AirBusId = int.Parse(fc["AirBusId"].ToString()); obj.PremiumClassSeatingAvailability = int.Parse(fc["PremiumClassSeatingAvailability"].ToString()); obj.FirstClassSeatingAvailability = int.Parse(fc["FirstClassSeatingAvailability"].ToString()); obj.EconomyClassSeatingAvailability = int.Parse(fc["EconomyClassSeatingAvailability"].ToString()); obj.DepartureDate = DateTime.Parse(fc["DepartureDate"].ToString()); obj.ArrivalTime = DateTime.Parse(fc["ArrivalTime"].ToString()); obj.PremiumClassFare = int.Parse(fc["PremiumClassFare"].ToString()); obj.FirstClassFare = int.Parse(fc["FirstClassFare"].ToString()); obj.EconomyClassFare = int.Parse(fc["EconomyClassFare"].ToString()); obj.VAT = decimal.Parse(fc["VAT"].ToString()); obj.TAX = decimal.Parse(fc["TAX"].ToString()); obj.Distance = int.Parse(fc["Distance"].ToString()); obj.stats = true; if (obj.DepartureDate > obj.ArrivalTime) { ViewBag.Messag = String.Format("Arrival Date Should not be below the Departure date."); List <string> list = new List <string>() { "Delhi", "Kolkata", "Trivandrum", "Chennai", "Bangalore", "Mumbai" }; ViewBag.ddlDeparturePlace = new SelectList(list); ViewBag.ddlDestinationPlace = new SelectList(list); ViewBag.ddlFlight = new SelectList(db.FMS_tbl_AirBusDetails, "Name", "Name"); return(View(obj)); } db.FMS_tbl_FlightScheduleDetails.Add(obj); } catch (Exception) { List <string> list = new List <string>() { "Delhi", "Kolkata", "Trivandrum", "Chennai", "Bangalore", "Mumbai" }; ViewBag.ddlDeparturePlace = new SelectList(list); ViewBag.ddlDestinationPlace = new SelectList(list); ViewBag.ddlFlight = new SelectList(db.FMS_tbl_AirBusDetails, "Name", "Name"); ViewBag.Messag = "Format You Entered is Incorrect."; return(View(obj)); } try { db.SaveChanges(); int id = obj.FlightScheduleId; if (id > 1) { ViewBag.Message = String.Format("Success: Flight Schedule added. Flight Schedule Id is {0}", id); List <string> list = new List <string>() { "Delhi", "Kolkata", "Trivandrum", "Chennai", "Bangalore", "Mumbai" }; ViewBag.ddlDeparturePlace = new SelectList(list); ViewBag.ddlDestinationPlace = new SelectList(list); ViewBag.ddlFlight = new SelectList(db.FMS_tbl_AirBusDetails, "Name", "Name"); return(View()); } else { ViewBag.Message = "Error while adding Flight Schedule. Please try again"; List <string> list = new List <string>() { "Delhi", "Kolkata", "Trivandrum", "Chennai", "Bangalore", "Mumbai" }; ViewBag.ddlDeparturePlace = new SelectList(list); ViewBag.ddlDestinationPlace = new SelectList(list); ViewBag.ddlFlight = new SelectList(db.FMS_tbl_AirBusDetails, "Name", "Name"); return(View()); } } catch { List <string> list = new List <string>() { "Delhi", "Kolkata", "Trivandrum", "Chennai", "Bangalore", "Mumbai" }; ViewBag.ddlDeparturePlace = new SelectList(list); ViewBag.ddlDestinationPlace = new SelectList(list); ViewBag.ddlFlight = new SelectList(db.FMS_tbl_AirBusDetails, "Name", "Name"); ViewBag.Messag = "Flight is already Scheduled."; return(View(obj)); } } return(View()); } }