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