public ActionResult DeleteFlightSchedule(int id) { FMS_tbl_FlightScheduleDetails obj = new FMS_tbl_FlightScheduleDetails(); obj = db.FMS_tbl_FlightScheduleDetails.Find(id); return(View(obj)); }
public ActionResult DeleteFlightSchedule(FormCollection fc, int id) { FMS_tbl_FlightScheduleDetails obj = new FMS_tbl_FlightScheduleDetails(); obj = db.FMS_tbl_FlightScheduleDetails.FirstOrDefault(x => x.FlightScheduleId == id); db.Entry(obj).State = System.Data.Entity.EntityState.Deleted; try { db.SaveChanges(); TempData["Message"] = "Delete successful"; return(RedirectToAction("ViewAllFlightScheduling")); }catch (Exception) { ViewBag.Messag = "Flight is already booked, Please release the tickets to continue."; return(View(obj)); } }
public ActionResult EditFlightScheduling(FMS_tbl_FlightScheduleDetails obj) { try { if (obj.DepartureDate > obj.ArrivalTime) { ViewBag.Messag = String.Format("Arrival Date Should not be below the Departure date."); return(View(obj)); } db.Entry(obj).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); ViewBag.Message = "Changes Saved Sucessfully"; return(View(obj)); } catch { ViewBag.Messag = "Could not edit. Check values"; return(View(obj)); } }
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()); } }