public static void Initialize(ApplicationDbContext context)
{
context.Database.EnsureCreated();
if (context.Flights.Any())
{
return;
}
//----< Adding 4 flights for Testing the workinng of application.
// More flights can be added from the Admin Application >-----
var flights = new Flights[]
{
new Flights {
FlightNumber = 12345, FlightName = "United", Source = "Syracuse", Destination = "New Jersey", DepartsOn = new DateTime().AddHours(9).AddMinutes(10).ToString("HH:mm"),
DepartureDate = new DateTime().AddDays(04).AddMonths(08).AddYears(2018), ArrivesOn = new DateTime().AddHours(14).AddMinutes(25).ToString("HH:mm"), EconomyNos = 36, FirstNos = 6, PriceEconomy = 100, PriceFirst = 400
},
new Flights {
FlightNumber = 89101, FlightName = "Jet Blue", Source = "Syracuse", Destination = "New Jersey", DepartsOn = new DateTime().AddHours(11).AddMinutes(10).ToString("HH:mm"),
DepartureDate = new DateTime().AddDays(04).AddMonths(08).AddYears(2018), ArrivesOn = new DateTime().AddHours(14).AddMinutes(25).ToString("HH:mm"), EconomyNos = 36, FirstNos = 6, PriceEconomy = 150, PriceFirst = 600
},
new Flights {
FlightNumber = 45678, FlightName = "American Airline", Source = "New Jersey", Destination = "Syracuse", DepartsOn = new DateTime().AddHours(15).AddMinutes(00).ToString("HH:mm"),
DepartureDate = new DateTime().AddDays(04).AddMonths(08).AddYears(2018), ArrivesOn = new DateTime().AddHours(19).AddMinutes(00).ToString("HH:mm"), EconomyNos = 48, FirstNos = 12, PriceEconomy = 200, PriceFirst = 500
},
new Flights {
FlightNumber = 76543, FlightName = "United", Source = "New Jersey", Destination = "Syracuse", DepartsOn = new DateTime().AddHours(16).AddMinutes(00).ToString("HH:mm"),
DepartureDate = new DateTime().AddDays(04).AddMonths(08).AddYears(2018), ArrivesOn = new DateTime().AddHours(20).AddMinutes(00).ToString("HH:mm"), EconomyNos = 48, FirstNos = 12, PriceEconomy = 250, PriceFirst = 600
}
};
foreach (Flights f in flights)
{
context.Flights.Add(f);
}
context.SaveChanges();
//----< Adding the seat numbers and the initial seating arrangement of above flights
// When a flight is added it's corressponding seating arrangement is saved in the
// table automaticall, without making the adminstrator to input anything >----
var flightseating = new FlightSeating[]
{
new FlightSeating {
FlightNumber = 12345, FirstClassSeatNumbers = "1A,1B,1C,1D,1E,1F", FirstClassSeatStatus = "O,O,O,O,O,O",
EconomyClassSeatNumbers = "2A,2B,2C,2D,2E,2F,3A,3B,3C,3D,3E,3F,4A,4B,4C,4D,4E,4F,5A,5B,5C,5D,5E,5F,6A,6B,6C,6D,6E,6F,7A,7B,7C,7D,7E,7F"
, EconomyClassSeatStatus = "O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O"
},
new FlightSeating {
FlightNumber = 89101, FirstClassSeatNumbers = "1A,1B,1C,1D,1E,1F", FirstClassSeatStatus = "O,O,O,O,O,O",
EconomyClassSeatNumbers = "2A,2B,2C,2D,2E,2F,3A,3B,3C,3D,3E,3F,4A,4B,4C,4D,4E,4F,5A,5B,5C,5D,5E,5F,6A,6B,6C,6D,6E,6F,7A,7B,7C,7D,7E,7F"
, EconomyClassSeatStatus = "O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O"
},
new FlightSeating {
FlightNumber = 45678, FirstClassSeatNumbers = "1A,1B,1C,1D,1E,1F,2A,2B,2C,2D,2E,2F", FirstClassSeatStatus = "O,O,O,O,O,O,O,O,O,O,O,O",
EconomyClassSeatNumbers = "2A,2B,2C,2D,2E,2F,3A,3B,3C,3D,3E,3F,4A,4B,4C,4D,4E,4F,5A,5B,5C,5D,5E,5F,6A,6B,6C,6D,6E,6F,7A,7B,7C,7D,7E,7F,8A,8B,8C,8D,8E,8F,9A,9B,9C,9D,9E,9F",
EconomyClassSeatStatus = "O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O"
},
new FlightSeating {
FlightNumber = 76543, FirstClassSeatNumbers = "1A,1B,1C,1D,1E,1F,2A,2B,2C,2D,2E,2F", FirstClassSeatStatus = "O,O,O,O,O,O,O,O,O,O,O,O",
EconomyClassSeatNumbers = "2A,2B,2C,2D,2E,2F,3A,3B,3C,3D,3E,3F,4A,4B,4C,4D,4E,4F,5A,5B,5C,5D,5E,5F,6A,6B,6C,6D,6E,6F,7A,7B,7C,7D,7E,7F,8A,8B,8C,8D,8E,8F,9A,9B,9C,9D,9E,9F",
EconomyClassSeatStatus = "O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O,O"
}
};
foreach (FlightSeating f in flightseating)
{
context.FlightSeatings.Add(f);
}
context.SaveChanges();
;
}
public async Task <IActionResult> AddFlight()
{
var request = HttpContext.Request;
var flight = new Flights
{
FlightNumber = Int32.Parse(request.Form["flightNumber"]),
FlightName = request.Form["flightName"],
Source = request.Form["source"],
Destination = request.Form["destination"],
ArrivesOn = request.Form["arrival"],
DepartsOn = request.Form["departure"],
DepartureDate = DateTime.Parse(request.Form["departureDate"]),
EconomyNos = Int32.Parse(request.Form["economySeats"]),
FirstNos = Int32.Parse(request.Form["firstSeats"]),
PriceEconomy = Int32.Parse(request.Form["economyPrice"]),
PriceFirst = Int32.Parse(request.Form["firstPrice"])
};
_context.Flights.Add(flight);
_context.SaveChanges();
//----< After saving the New Flight information into the Database, the seating arrangement for the flight
// must be added into the FlightSeating table. We get the seat number and the status into a string and
// add that string to the database along with flight number with any adminstrator involvement >----
int economyNOS = Int32.Parse(request.Form["economySeats"]);
int firstNOS = Int32.Parse(request.Form["firstSeats"]);
string economySeatString, economySeatStatusString, firstSeatString, firstStatusString;
if (firstNOS == 6)
{
economySeatString = EconomySeatDictionary6[economyNOS];
economySeatStatusString = EconomyStatusDictionary[economyNOS];
firstSeatString = FirstSeatDictionary[firstNOS];
firstStatusString = FirstStatusDictionary[firstNOS];
}
else if (firstNOS == 12)
{
economySeatString = EconomySeatDictionary12[economyNOS];
economySeatStatusString = EconomyStatusDictionary[economyNOS];
firstSeatString = FirstSeatDictionary[firstNOS];
firstStatusString = FirstStatusDictionary[firstNOS];
}
else
{
economySeatString = EconomySeatDictionary18[economyNOS];
economySeatStatusString = EconomyStatusDictionary[economyNOS];
firstSeatString = FirstSeatDictionary[firstNOS];
firstStatusString = FirstStatusDictionary[firstNOS];
}
var seating = new FlightSeating
{
FlightNumber = Int32.Parse(request.Form["flightNumber"]),
FirstClassSeatNumbers = firstSeatString,
FirstClassSeatStatus = firstStatusString,
EconomyClassSeatNumbers = economySeatString,
EconomyClassSeatStatus = economySeatStatusString
};
_context.FlightSeatings.Add(seating);
_context.SaveChanges();
return(Ok());
}
