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