public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new AirportContext(serviceProvider.GetRequiredService <DbContextOptions <AirportContext> >()))
{
if (!context.SetOf <PlaneType>().Any())
{
context.SetOf <PlaneType>().AddRange
(
new PlaneType()
{
PlaneModel = "Civil", SeatsNumber = 200, Carrying = 10000
},
new PlaneType()
{
PlaneModel = "Cargo", SeatsNumber = 10, Carrying = 50000
},
new PlaneType()
{
PlaneModel = "Military", SeatsNumber = 40, Carrying = 3000
},
new PlaneType()
{
PlaneModel = "Falcon", SeatsNumber = 100, Carrying = 9
}
);
context.SaveChanges();
}
if (!context.SetOf <Plane>().Any())
{
context.SetOf <Plane>().AddRange
(
new Plane(new DateTime(1995, 11, 4))
{
Name = "Dream", PlaneType = context.PlaneTypes.Find(2)
},
new Plane(new DateTime(2011, 6, 15))
{
Name = "Boeing", PlaneType = context.PlaneTypes.Find(1)
},
new Plane(new DateTime(2018, 2, 6))
{
Name = "Heavy", PlaneType = context.PlaneTypes.Find(4)
}
);
context.SaveChanges();
}
if (!context.SetOf <Stewardess>().Any())
{
context.SetOf <Stewardess>().AddRange
(
new Stewardess()
{
FirstName = "Katy", LastName = "Smith", BirthDate = new DateTime(1983, 10, 5)
},
new Stewardess()
{
FirstName = "Carol", LastName = "Hoover", BirthDate = new DateTime(1991, 4, 11)
},
new Stewardess()
{
FirstName = "Ada", LastName = "Lovelace", BirthDate = new DateTime(1976, 7, 13)
},
new Stewardess()
{
FirstName = "Beverly", LastName = "Marsh", BirthDate = new DateTime(2002, 2, 13)
}
);
context.SaveChanges();
}
if (!context.SetOf <Pilot>().Any())
{
context.SetOf <Pilot>().AddRange
(
new Pilot()
{
FirstName = "Jimmy", LastName = "Doolittle", BirthDate = new DateTime(1973, 9, 16), Exp = 12
},
new Pilot()
{
FirstName = "Noel", LastName = "Wien", BirthDate = new DateTime(1982, 8, 20), Exp = 9
},
new Pilot()
{
FirstName = "Robert", LastName = "Hoover", BirthDate = new DateTime(1980, 3, 13), Exp = 15
}
);
context.SaveChanges();
}
if (!context.SetOf <Crew>().Any())
{
context.SetOf <Crew>().AddRange
(
new Crew()
{
Pilot = context.Pilots.Find(2), Stewardess = new List <Stewardess>()
{
context.Stewardesses.Find(2), context.Stewardesses.Find(4)
}
},
new Crew()
{
Pilot = context.Pilots.Find(3), Stewardess = new List <Stewardess>()
{
context.Stewardesses.Find(3)
}
},
new Crew()
{
Pilot = context.Pilots.Find(1), Stewardess = new List <Stewardess>()
{
context.Stewardesses.Find(1)
}
}
);
context.SaveChanges();
}
if (!context.SetOf <Flight>().Any())
{
context.SetOf <Flight>().AddRange
(
new Flight()
{
FlightNumber = "7W7017", DepartureAirport = "LWO", DepartureTime = new DateTime(2018, 7, 13, 22, 15, 0), DestinationAirport = "FCO", ArrivalTime = new DateTime(2018, 7, 13, 23, 45, 0)
},
new Flight()
{
FlightNumber = "KP5311", DepartureAirport = "KBP", DepartureTime = new DateTime(2018, 7, 15, 14, 30, 0), DestinationAirport = "EIN", ArrivalTime = new DateTime(2018, 7, 15, 17, 45, 0)
},
new Flight()
{
FlightNumber = "AZ4297", DepartureAirport = "ODS", DepartureTime = new DateTime(2018, 9, 15, 19, 45, 0), DestinationAirport = "LIS", ArrivalTime = new DateTime(2018, 9, 15, 22, 30, 0)
}
);
context.SaveChanges();
}
if (!context.SetOf <Ticket>().Any())
{
context.SetOf <Ticket>().AddRange
(
new Ticket()
{
Flight = context.Flights.Find(2), FlightNumber = context.Flights.Find(2).FlightNumber, Price = 250
},
new Ticket()
{
Flight = context.Flights.Find(1), FlightNumber = context.Flights.Find(1).FlightNumber, Price = 240
},
new Ticket()
{
Flight = context.Flights.Find(2), FlightNumber = context.Flights.Find(2).FlightNumber, Price = 300
},
new Ticket()
{
Flight = context.Flights.Find(1), FlightNumber = context.Flights.Find(1).FlightNumber, Price = 270
},
new Ticket()
{
Flight = context.Flights.Find(3), FlightNumber = context.Flights.Find(3).FlightNumber, Price = 280
}
);
context.SaveChanges();
}
if (!context.SetOf <Departure>().Any())
{
context.SetOf <Departure>().AddRange
(
new Departure()
{
FlightNumber = "7W7017", Flight = context.Flights.Find(1), DepartureDate = new DateTime(2018, 7, 13, 22, 15, 0), Crew = context.Crews.Find(1), Plane = context.Planes.Find(2)
},
new Departure()
{
FlightNumber = "AZ4297", Flight = context.Flights.Find(3), DepartureDate = new DateTime(2018, 9, 15, 19, 45, 0), Crew = context.Crews.Find(3), Plane = context.Planes.Find(1)
}
);
context.SaveChanges();
}
//if (!context.SetOf<>().Any())
//{
// context.SetOf<>().AddRange
// (
// );
// context.SaveChanges();
//}
}
}
public static void EnsurePopulated(IApplicationBuilder app)
{
AirportContext context = ServiceProviderServiceExtensions.GetRequiredService <AirportContext>(app.ApplicationServices);
context.Database.EnsureDeleted();
if (!context.Database.EnsureCreated())
{
return;
}
context.Tickets.AddRange(
new Ticket()
{
Price = 111M,
FlightForeignKey = 1,
},
new Ticket()
{
//Id = 2,
Price = 200M,
FlightForeignKey = 2,
},
new Ticket()
{
//Id = 3,
Price = 300M,
FlightForeignKey = 3,
}
);
context.PlaneTypes.AddRange(
new PlaneType()
{
//Id = 1,
Model = "AN",
Seats = 100,
Payload = 3000
},
new PlaneType()
{
//Id = 2,
Model = "AN",
Seats = 200,
Payload = 5000
},
new PlaneType()
{
//Id = 3,
Model = "AN",
Seats = 300,
Payload = 10000
}
);
context.Planes.AddRange(
new Plane()
{
//Id = 1,
Name = "Plane1",
Type = 1,
TimeUsed = "100000"
},
new Plane()
{
//Id = 2,
Name = "Plane2",
Type = 2,
TimeUsed = "20000"
},
new Plane()
{
//Id = 3,
Name = "Plane3",
Type = 3,
TimeUsed = "30000"
}
);
context.Pilots.AddRange(
new Pilot()
{
//Id = 1,
Name = "John",
Surname = "Smith",
BirthDay = "1982/05/23",
Experience = 20000,
},
new Pilot()
{
//Id = 2,
Name = "Scott",
Surname = "Jonson",
BirthDay = "1992/12/03",
Experience = 500,
},
new Pilot()
{
//Id = 3,
Name = "Pall",
Surname = "Green",
BirthDay = "1989/07/13",
Experience = 7000,
}
);
context.Flightattendants.AddRange(
new Flightattendant()
{
//Id = 1,
Name = "Mary",
Surname = "Smith",
BirthDay = "1999/05/21",
CrewForeignKey = 1
},
new Flightattendant()
{
//Id = 2,
Name = "Jane",
Surname = "Jonson",
BirthDay = "1998/15/03",
CrewForeignKey = 1
},
new Flightattendant()
{
//Id = 3,
Name = "Liza",
Surname = "Green",
BirthDay = "1999/08/01",
CrewForeignKey = 3
},
new Flightattendant()
{
//Id = 3,
Name = "Liza",
Surname = "Tomas",
BirthDay = "1997/07/01",
CrewForeignKey = 2
}
);
context.Flights.AddRange(
new Flight()
{
//Id = 1,
Number = "QW543200",
Departure = "Kyiv",
Destination = "Lviv",
DeparturingTime = "2018-12-14 10:13:20",
ArrivingTime = "2018-12-14 10:43:20",
Tickets = new List <Ticket>(),
},
new Flight()
{
//Id = 3,
Number = "PY987500",
Departure = "Kyiv",
Destination = "Barcelona",
DeparturingTime = "2018-12-15 15:13:20",
ArrivingTime = "2018-12-15 17:43:20",
Tickets = new List <Ticket>(),
},
new Flight()
{
//Id = 3,
Number = "KJ457000",
Departure = "Kyiv",
Destination = "Toronto",
DeparturingTime = "2018-10-15 05:13:20",
ArrivingTime = "2018-10-15 23:43:20",
Tickets = new List <Ticket>(),
}
);
context.Crews.AddRange(
new Crew()
{
//Id = 1,
Pilot = 1,
FlightAttendantsList = new List <Flightattendant>(),
},
new Crew()
{
//Id = 1,
Pilot = 2,
FlightAttendantsList = new List <Flightattendant>(),
},
new Crew()
{
//Id = 1,
Pilot = 3,
FlightAttendantsList = new List <Flightattendant>(),
}
);
context.Departures.AddRange(
new Departure()
{
//Id = 1,
Flight = 1,
Crew = 1,
DepartingTime = "2018-12-14 10:33:20",
Plane = 1,
},
new Departure()
{
//Id = 1,
Flight = 2,
Crew = 2,
DepartingTime = "2018-12-15 15:23:20",
Plane = 2,
},
new Departure()
{
//Id = 1,
Flight = 3,
Crew = 3,
DepartingTime = "2018-10-15 05:18:20",
Plane = 3,
}
);
context.SaveChanges();
}