Example #1
0
        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();
                //}
            }
        }
Example #2
0
        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();
        }