// Seed roles in the db if they don't exist
        public static async Task SeedRoles(IServiceProvider serviceProvider, SportsContext context)
        {
            if (!context.UserRoles.Any())
            {
                var roleManager = serviceProvider.GetRequiredService <RoleManager <Role> >();

                foreach (var role in RoleNames)
                {
                    if (!await roleManager.RoleExistsAsync(role))
                    {
                        await roleManager.CreateAsync(new Role(role));
                    }
                }
            }
        }
示例#2
0
        public static void SeedDb(SportsContext context)
        {
            //TODO: Remove in Release :)
            context.Database.EnsureDeleted();

            context.Database.EnsureCreated();

            //TODO: Add seed data or use NMockaroo

            //Insert data into the database if there aren't any in the specific table
            if (!context.Addresses.Any())
            {
                var addresses = new Address[]
                {
                    new Address {
                        Street = "Amazing Drive", City = "Aalborg", Country = "DK", State = "DK"
                    },
                    new Address {
                        Street = "Not so Amazing Drive", City = "Copenhagen", Country = "DK", State = "DK"
                    },
                    new Address {
                        City = "Aalborg", Street = "Amazing Drive", Country = "Denmark", PostalCode = "9000", State = "Denmark"
                    },
                    new Address {
                        City = "Aarhus", Street = "Not so Amazing Drive", Country = "Denmark", PostalCode = "9000", State = "Denmark"
                    },
                    new Address {
                        City = "Copenhagen", Street = "Not so Amazing Drive", Country = "Denmark", PostalCode = "9000", State = "Denmark"
                    },
                    new Address {
                        City = "Esbjerg", Street = "Not so Amazing Drive", Country = "Denmark", PostalCode = "9000", State = "Denmark"
                    },
                };

                context.Addresses.AddRange(addresses);
                context.SaveChanges();
            }

            if (!context.Locations.Any())
            {
                var locations = new Location[]
                {
                    new Location {
                        Latitude = 55.724478044067006, Longitude = 12.60262191295624
                    },
                    new Location {
                        Latitude = 57.058790791383466, Longitude = 9.895803630352022
                    },
                    new Location {
                        Latitude = 57.05889288811736, Longitude = 9.895127713680269
                    },
                };

                context.Locations.AddRange(locations);
                context.SaveChanges();
            }

            if (!context.Persons.Any())
            {
                var persons = new Person[]
                {
                    new Person {
                        FirstName = "Bartosz", LastName = "Urban", Email = "*****@*****.**", AddressId = 1
                    },
                    new Person {
                        FirstName = "Dragos", LastName = "Ionescu", Email = "*****@*****.**", AddressId = 1
                    },
                    new Person {
                        FirstName = "Peter", LastName = "Boelt", Email = "*****@*****.**", AddressId = 2
                    },
                    new Person {
                        FirstName = "Zach", LastName = "Horatau", Email = "*****@*****.**", AddressId = 2
                    }
                };

                context.Persons.AddRange(persons);
                context.SaveChanges();
            }

            if (!context.MarinaOwners.Any())
            {
                var marinaOwners = new MarinaOwner[]
                {
                    new MarinaOwner {
                        PersonId = 1
                    },
                    new MarinaOwner {
                        PersonId = 2
                    },
                    new MarinaOwner {
                        PersonId = 3
                    },
                    new MarinaOwner {
                        PersonId = 4
                    },
                };

                context.MarinaOwners.AddRange(marinaOwners);
                context.SaveChanges();
            }

            if (!context.Marinas.Any())
            {
                var marinas = new Marina[]
                {
                    new Marina {
                        Name = "Aalborg Marina", MarinaOwnerId = 1, Description = "Coolest marina", Facilities = "none", AddressId = 1
                    },
                    new Marina {
                        Name = "Aarhus Marina", MarinaOwnerId = 2, Description = "Some marina", Facilities = "none", AddressId = 2
                    },
                    new Marina {
                        Name = "Copenhagen Marina", MarinaOwnerId = 3, Description = "Some marina", Facilities = "none", AddressId = 3
                    },
                    new Marina {
                        Name = "Esbjerg Marina", MarinaOwnerId = 1, Description = "Some marina", Facilities = "none", AddressId = 4
                    },
                };

                context.Marinas.AddRange(marinas);
                context.SaveChanges();
            }

            if (!context.BoatOwners.Any())
            {
                var boatOwners = new BoatOwner[]
                {
                    new BoatOwner {
                        PersonId = 3
                    },
                    new BoatOwner {
                        PersonId = 4
                    }
                };

                context.BoatOwners.AddRange(boatOwners);
                context.SaveChanges();
            }

            if (!context.Boats.Any())
            {
                var boats = new Boat[]
                {
                    new Boat {
                        Name = "Titanic", BoatOwnerId = 1, Depth = 2, Length = 5, Width = 3
                    },
                    new Boat {
                        Name = "Mama Destroyer", BoatOwnerId = 2, Depth = 5, Length = 20, Width = 9
                    },
                };

                context.Boats.AddRange(boats);
                context.SaveChanges();
            }

            if (!context.Spots.Any())
            {
                var spots = new Spot[]
                {
                    new Spot {
                        SpotNumber = 1, MarinaId = 1, Available = true, Price = 50.00, MaxDepth = 30, MaxWidth = 10, MaxLength = 30
                    },
                    new Spot {
                        SpotNumber = 2, MarinaId = 1, Available = true, Price = 50.00, MaxDepth = 30, MaxWidth = 30, MaxLength = 30
                    },
                    new Spot {
                        SpotNumber = 3, MarinaId = 1, Available = true, Price = 50.00, MaxDepth = 30, MaxWidth = 30, MaxLength = 30
                    },
                    new Spot {
                        SpotNumber = 4, MarinaId = 2, Available = true, Price = 50.00, MaxDepth = 30, MaxWidth = 30, MaxLength = 30, LocationId = 3
                    },
                    new Spot {
                        SpotNumber = 5, MarinaId = 3, Available = true, Price = 50.00, MaxDepth = 30, MaxWidth = 30, MaxLength = 30
                    },
                    new Spot {
                        SpotNumber = 1, MarinaId = 4, Available = true, Price = 50.00, MaxDepth = 30, MaxWidth = 30, MaxLength = 30, LocationId = 1
                    },
                    new Spot {
                        SpotNumber = 2, MarinaId = 4, Available = true, Price = 40.00, MaxDepth = 30, MaxWidth = 30, MaxLength = 30, LocationId = 2
                    },
                    new Spot {
                        SpotNumber = 3, MarinaId = 4, Available = true, Price = 30.00, MaxDepth = 30, MaxWidth = 30, MaxLength = 30
                    }
                };

                context.Spots.AddRange(spots);
                context.SaveChanges();
            }

            if (!context.Bookings.Any())
            {
                var bookings = new Booking[]
                {
                    new Booking {
                        BookingReferenceNo = 1, BoatId = 1, TotalPrice = 2, PaymentStatus = "not paid", CreationDate = DateTime.Now
                    },
                    new Booking {
                        BookingReferenceNo = 2, BoatId = 1, TotalPrice = 10, PaymentStatus = "not paid", CreationDate = DateTime.Now
                    },
                    new Booking {
                        BookingReferenceNo = 3, BoatId = 1, TotalPrice = 100, PaymentStatus = "not paid", CreationDate = DateTime.Now
                    },
                    new Booking {
                        BookingReferenceNo = 4, BoatId = 2, TotalPrice = 83, PaymentStatus = "not paid", CreationDate = DateTime.Now
                    },
                    new Booking {
                        BookingReferenceNo = 5, BoatId = 2, TotalPrice = 97, PaymentStatus = "not paid", CreationDate = DateTime.Now
                    },
                    new Booking {
                        BookingReferenceNo = 6, BoatId = 2, TotalPrice = 23, PaymentStatus = "not paid", CreationDate = DateTime.Now
                    }
                };

                context.Bookings.AddRange(bookings);
                context.SaveChanges();
            }

            if (!context.BookingLines.Any())
            {
                var bookingLines = new BookingLine[]
                {
                    // Ongoing: True
                    new BookingLine {
                        Ongoing = true, BookingId = 1, SpotId = 1, DiscountedTotalPrice = 1, Confirmed = true, StartDate = DateTime.Now.AddDays(-1), EndDate = DateTime.Now.AddDays(1)
                    },
                    new BookingLine {
                        Ongoing = false, BookingId = 1, SpotId = 2, DiscountedTotalPrice = 2, StartDate = DateTime.Now.AddDays(-1), EndDate = DateTime.Now.AddDays(1)
                    },
                    new BookingLine {
                        Ongoing = false, BookingId = 1, SpotId = 3, DiscountedTotalPrice = 3, StartDate = DateTime.Now.AddDays(3), EndDate = DateTime.Now.AddDays(4)
                    },
                    // Ongoing: False
                    new BookingLine {
                        Ongoing = false, BookingId = 2, SpotId = 1, DiscountedTotalPrice = 4, StartDate = DateTime.Now.AddDays(3), EndDate = DateTime.Now.AddDays(4)
                    },
                    new BookingLine {
                        Ongoing = false, BookingId = 2, SpotId = 2, DiscountedTotalPrice = 5, StartDate = DateTime.Now.AddDays(3), EndDate = DateTime.Now.AddDays(4)
                    },
                    new BookingLine {
                        Ongoing = false, BookingId = 2, SpotId = 3, DiscountedTotalPrice = 6, StartDate = DateTime.Now.AddDays(5), EndDate = DateTime.Now.AddDays(7)
                    },
                    // Ongoing: False
                    new BookingLine {
                        Ongoing = false, BookingId = 3, SpotId = 1, DiscountedTotalPrice = 10, StartDate = DateTime.Now.AddDays(5), EndDate = DateTime.Now.AddDays(7)
                    },
                    new BookingLine {
                        Ongoing = false, BookingId = 3, SpotId = 2, DiscountedTotalPrice = 10, StartDate = DateTime.Now.AddDays(5), EndDate = DateTime.Now.AddDays(7)
                    },
                    new BookingLine {
                        Ongoing = false, BookingId = 3, SpotId = 3, DiscountedTotalPrice = 10, StartDate = DateTime.Now.AddDays(5), EndDate = DateTime.Now.AddDays(7)
                    },

                    // Ongoing: False
                    new BookingLine {
                        Ongoing = false, BookingId = 4, SpotId = 1, DiscountedTotalPrice = 19, StartDate = DateTime.Now.AddDays(12), EndDate = DateTime.Now.AddDays(15)
                    },
                    new BookingLine {
                        Ongoing = false, BookingId = 4, SpotId = 2, DiscountedTotalPrice = 11, StartDate = DateTime.Now.AddDays(12), EndDate = DateTime.Now.AddDays(15)
                    },
                    new BookingLine {
                        Ongoing = false, BookingId = 4, SpotId = 3, DiscountedTotalPrice = 17, StartDate = DateTime.Now.AddDays(12), EndDate = DateTime.Now.AddDays(15)
                    },
                    // Ongoing: True
                    new BookingLine {
                        Ongoing = true, BookingId = 5, SpotId = 1, DiscountedTotalPrice = 15, StartDate = DateTime.Now.AddDays(22), EndDate = DateTime.Now.AddDays(25)
                    },
                    new BookingLine {
                        Ongoing = true, BookingId = 5, SpotId = 3, DiscountedTotalPrice = 16, StartDate = DateTime.Now.AddDays(22), EndDate = DateTime.Now.AddDays(25)
                    },
                    new BookingLine {
                        Ongoing = true, BookingId = 5, SpotId = 2, DiscountedTotalPrice = 14, StartDate = DateTime.Now.AddDays(22), EndDate = DateTime.Now.AddDays(25)
                    },
                    // Ongoing: True
                    new BookingLine {
                        Ongoing = false, BookingId = 6, SpotId = 1, DiscountedTotalPrice = 12
                    },
                    new BookingLine {
                        Ongoing = true, BookingId = 6, SpotId = 2, DiscountedTotalPrice = 13
                    },
                    new BookingLine {
                        Ongoing = true, BookingId = 6, SpotId = 5, DiscountedTotalPrice = 14
                    }
                };

                context.BookingLines.AddRange(bookingLines);
                context.SaveChanges();
            }
        }
示例#3
0
 public static async Task InitializeDb(IServiceProvider serviceProvider, SportsContext context)
 {
     SeedDb(context);
 }