public static void Initialize(KinoContext ctx) { ctx.Database.EnsureCreated(); if (ctx.movies.Any()) { return; // DB has been seeded } var genres = new Genre[] { new Genre { GenreName = "Action" }, new Genre { GenreName = "Horror" }, new Genre { GenreName = "Drama" }, new Genre { GenreName = "Comedy" }, new Genre { GenreName = "Animation" }, new Genre { GenreName = "Science fiction" }, new Genre { GenreName = "Romance" }, new Genre { GenreName = "Musical" }, new Genre { GenreName = "Thriller" }, new Genre { GenreName = "Horror" } }; ctx.genres.AddRange(genres); ctx.SaveChanges(); var people = new People[] { // The Fast and the Furious: Tokyo Drif new People { Name = "Justin Lin" }, new People { Name = "Lucas Black" }, new People { Name = "Bow Wow" }, // Godzilla: King of the Monsters new People { Name = "Michael Dougherty" }, new People { Name = "Kyle Chandler" }, new People { Name = "Vera Farmiga" }, new People { Name = "Millie Bobby Brown" }, // Anchorman 2: The Legend Continues new People { Name = "Adam McKay" }, new People { Name = "Will Ferrell" }, new People { Name = "Steve Carell" }, // The Hateful Eight new People { Name = "Quentin Tarantino" }, new People { Name = "Samuel L. Jackson" }, new People { Name = "Kurt Russell" }, // Creed new People { Name = "Ryan Coogler" }, new People { Name = "Michael B. Jordan" }, new People { Name = "Sylvester Stallone" }, // Jurassic World new People { Name = "Colin Trevorrow" }, new People { Name = "Chris Pratt" }, new People { Name = "Bryce Dallas Howard" }, // Inside Out new People { Name = "Pete Docter" }, new People { Name = "Amy Poehler" }, new People { Name = "Phyllis Smith" } }; ctx.people.AddRange(people); ctx.SaveChanges(); Room[] rooms = new Room[] { new Room { Name = "Room 1" }, new Room { Name = "Room 2" }, new Room { Name = "Room 3" }, new Room { Name = "Room 4" } }; ctx.rooms.AddRange(rooms); ctx.SaveChanges(); var seats = new Seat[4 * 12 * 30]; int c = 0; for (int room = 0; room <= 3; room++) { for (int row = 1; row <= 12; row++) { for (int number = 1; number <= 30; number++) { seats[c++] = new Seat { Room = rooms[room], Row = row, Number = number }; } } } ctx.seats.AddRange(seats); ctx.SaveChanges(); var movies = new Movie[] { new Movie { Title = "Fast and Furious: Tokyo Drift", Rating = "PG-13", Length = "122", StartDate = new DateTime(2020, 9, 30), EndDate = new DateTime(2021, 1, 23) }, new Movie { Title = "Godzilla: King of the monsters", Rating = "PG-13", Length = "134", StartDate = new DateTime(2020, 9, 21), EndDate = new DateTime(2021, 1, 15) }, new Movie { Title = "Anchorman 2", Rating = "PG-13", Length = "119", StartDate = new DateTime(2020, 8, 3), EndDate = new DateTime(2020, 12, 30) }, new Movie { Title = "Hateful eight", Rating = "R", Length = "168", StartDate = new DateTime(2020, 7, 5), EndDate = new DateTime(2020, 12, 15) }, new Movie { Title = "Creed", Rating = "PG-13", Length = "133", StartDate = new DateTime(2020, 7, 17), EndDate = new DateTime(2020, 12, 11) }, new Movie { Title = "Jurassic World", Rating = "PG-13", Length = "124", StartDate = new DateTime(2020, 6, 9), EndDate = new DateTime(2020, 12, 1) }, new Movie { Title = "Inside Out", Rating = "PG", Length = "95", StartDate = new DateTime(2020, 8, 12), EndDate = new DateTime(2020, 12, 25) } }; ctx.movies.AddRange(movies); ctx.SaveChanges(); // added genres to movies var movieGenres = new GenreMovie[] { new GenreMovie { MovieID = movies.Single(m => m.Title == "Inside Out").MovieID, GenreID = genres.Single(i => i.GenreName == "Action").GenreID }, new GenreMovie { MovieID = movies.Single(m => m.Title == "Fast and Furious: Tokyo Drift").MovieID, GenreID = genres.Single(i => i.GenreName == "Action").GenreID }, new GenreMovie { MovieID = movies.Single(m => m.Title == "Fast and Furious: Tokyo Drift").MovieID, GenreID = genres.Single(i => i.GenreName == "Drama").GenreID }, new GenreMovie { MovieID = movies.Single(m => m.Title == "Godzilla: King of the monsters").MovieID, GenreID = genres.Single(i => i.GenreName == "Science fiction").GenreID }, new GenreMovie { MovieID = movies.Single(m => m.Title == "Godzilla: King of the monsters").MovieID, GenreID = genres.Single(i => i.GenreName == "Action").GenreID }, new GenreMovie { MovieID = movies.Single(m => m.Title == "Anchorman 2").MovieID, GenreID = genres.Single(i => i.GenreName == "Comedy").GenreID }, new GenreMovie { MovieID = movies.Single(m => m.Title == "Hateful eight").MovieID, GenreID = genres.Single(i => i.GenreName == "Drama").GenreID }, new GenreMovie { MovieID = movies.Single(m => m.Title == "Creed").MovieID, GenreID = genres.Single(i => i.GenreName == "Drama").GenreID }, new GenreMovie { MovieID = movies.Single(m => m.Title == "Jurassic World").MovieID, GenreID = genres.Single(i => i.GenreName == "Action").GenreID }, new GenreMovie { MovieID = movies.Single(m => m.Title == "Inside Out").MovieID, GenreID = genres.Single(i => i.GenreName == "Animation").GenreID } }; foreach (GenreMovie gm in movieGenres) { ctx.GenreMovies.Add(gm); } ctx.SaveChanges(); // added actors to movies var actors = new Actors[] { new Actors { MovieID = movies.Single(m => m.Title == "Fast and Furious: Tokyo Drift").MovieID, PeopleID = people.Single(p => p.Name == "Lucas Black").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Fast and Furious: Tokyo Drift").MovieID, PeopleID = people.Single(p => p.Name == "Bow Wow").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Godzilla: King of the monsters").MovieID, PeopleID = people.Single(p => p.Name == "Kyle Chandler").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Godzilla: King of the monsters").MovieID, PeopleID = people.Single(p => p.Name == "Vera Farmiga").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Godzilla: King of the monsters").MovieID, PeopleID = people.Single(p => p.Name == "Millie Bobby Brown").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Anchorman 2").MovieID, PeopleID = people.Single(p => p.Name == "Will Ferrell").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Anchorman 2").MovieID, PeopleID = people.Single(p => p.Name == "Steve Carell").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Hateful eight").MovieID, PeopleID = people.Single(p => p.Name == "Samuel L. Jackson").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Hateful eight").MovieID, PeopleID = people.Single(p => p.Name == "Kurt Russell").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Creed").MovieID, PeopleID = people.Single(p => p.Name == "Michael B. Jordan").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Creed").MovieID, PeopleID = people.Single(p => p.Name == "Sylvester Stallone").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Jurassic World").MovieID, PeopleID = people.Single(p => p.Name == "Chris Pratt").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Jurassic World").MovieID, PeopleID = people.Single(p => p.Name == "Bryce Dallas Howard").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Inside Out").MovieID, PeopleID = people.Single(p => p.Name == "Amy Poehler").PeopleID }, new Actors { MovieID = movies.Single(m => m.Title == "Inside Out").MovieID, PeopleID = people.Single(p => p.Name == "Phyllis Smith").PeopleID } }; foreach (Actors a in actors) { ctx.Actors.Add(a); } ctx.SaveChanges(); // added directors to movies var directors = new Directors[] { new Directors { MovieID = movies.Single(m => m.Title == "Fast and Furious: Tokyo Drift").MovieID, PeopleID = people.Single(p => p.Name == "Justin Lin").PeopleID }, new Directors { MovieID = movies.Single(m => m.Title == "Godzilla: King of the monsters").MovieID, PeopleID = people.Single(p => p.Name == "Michael Dougherty").PeopleID }, new Directors { MovieID = movies.Single(m => m.Title == "Anchorman 2").MovieID, PeopleID = people.Single(p => p.Name == "Adam McKay").PeopleID }, new Directors { MovieID = movies.Single(m => m.Title == "Hateful eight").MovieID, PeopleID = people.Single(p => p.Name == "Quentin Tarantino").PeopleID }, new Directors { MovieID = movies.Single(m => m.Title == "Creed").MovieID, PeopleID = people.Single(p => p.Name == "Ryan Coogler").PeopleID }, new Directors { MovieID = movies.Single(m => m.Title == "Jurassic World").MovieID, PeopleID = people.Single(p => p.Name == "Colin Trevorrow").PeopleID }, new Directors { MovieID = movies.Single(m => m.Title == "Inside Out").MovieID, PeopleID = people.Single(p => p.Name == "Pete Docter").PeopleID }, }; foreach (Directors d in directors) { ctx.Directors.Add(d); } ctx.SaveChanges(); /* Admin role */ ctx.Roles.Add(new IdentityRole { Id = "1", Name = "Administrator" }); /* Admin user */ var userAdmin = new AppUser { FirstName = "Gospod", LastName = "Admin", NormalizedEmail = "*****@*****.**", Email = "*****@*****.**", UserName = "******", NormalizedUserName = "******", PhoneNumber = "+111111111111", EmailConfirmed = true, PhoneNumberConfirmed = true, SecurityStamp = Guid.NewGuid().ToString("D") }; if (!ctx.Users.Any(u => u.UserName == userAdmin.UserName)) { var password = new PasswordHasher <AppUser>(); var hashed = password.HashPassword(userAdmin, "Geslogeslo1!"); userAdmin.PasswordHash = hashed; ctx.Users.Add(userAdmin); } ctx.SaveChanges(); /* Add user role */ ctx.UserRoles.Add(new IdentityUserRole <string> { RoleId = "1", UserId = userAdmin.Id }); ctx.SaveChanges(); /* Normal user */ var userNormal = new AppUser { FirstName = "Gospod", LastName = "Navadnik", NormalizedEmail = "*****@*****.**", Email = "*****@*****.**", UserName = "******", NormalizedUserName = "******", PhoneNumber = "+111111111111", EmailConfirmed = true, PhoneNumberConfirmed = true, SecurityStamp = Guid.NewGuid().ToString("D") }; if (!ctx.Users.Any(u => u.UserName == userNormal.UserName)) { var password = new PasswordHasher <AppUser>(); var hashed = password.HashPassword(userNormal, "Geslogeslo1!"); userNormal.PasswordHash = hashed; ctx.Users.Add(userNormal); } ctx.SaveChanges(); }
public static void Initialize(KinoContext context) { context.Database.EnsureCreated(); // Look for any students if (context.Filmi.Any()) { return; // DB has been seeded } var Filmi = new Film[] { new Film { Film_ime = "James Bond", Film_trajanje = 165, Film_reziser = "Režiser: Cary Joji Fukunaga", Film_opis = "Občutite val adrenalina z najbolj priljubljenim vohunom. Zdaj ni čas za smrt, čas je, da si ogledate film.", Film_img = "Images/james_bond.jpg" }, new Film { Film_ime = "Levji Kralj", Film_trajanje = 96, Film_reziser = "Režiser: Walt Disney", Film_opis = "Najlepši družinski risani film leta 1994.", Film_img = "Images/lion_king.jpg" }, new Film { Film_ime = "Terminator", Film_trajanje = 140, Film_reziser = "Režiser: James Cameron", Film_opis = "Schwarzenegger gre v preteklost v tej akcijski pustolovščini, polni akcije in vprašanj o potovanju skozi čas.", Film_img = "Images/terminator.jpg" }, new Film { Film_ime = "Matrix", Film_trajanje = 125, Film_reziser = "Režiser: Lana Wachowski", Film_opis = "Ste res prepričani, da svet okoli vas ni le računalniška simulacija? Odkrijte nove dimenzije resničnosti v tej 2006 uspešnici.", Film_img = "Images/matrix.jpg" }, new Film { Film_ime = "Star Wars", Film_trajanje = 100, Film_reziser = "Režiser: George Lucas", Film_opis = "Klasične vojne zvezd se vračajo v kinematografe v še bolj spektakularni prequel trilogiji.", Film_img = "Images/star_wars.jpg" }, new Film { Film_ime = "Neon Genesis Evangelion", Film_trajanje = 135, Film_reziser = "Režiser: Hideaki Anno", Film_opis = "Ste si kdaj želeli videti bitke med vesoljci in roboti, hkrati pa se spraševali o pomenu življenja? Raziščite življenje skozi bitke robotskih vesoljcev in psihičnega trpljenja njihovih pilotov.", Film_img = "Images/neon_genesis.jpg" }, }; context.Filmi.AddRange(Filmi); context.SaveChanges(); var Dvorane = new Dvorana[] { new Dvorana { Dvorana_tip = "Mala" }, new Dvorana { Dvorana_tip = "Mala" }, new Dvorana { Dvorana_tip = "Velika" }, new Dvorana { Dvorana_tip = "Velika" }, new Dvorana { Dvorana_tip = "Mala" }, }; context.Dvorane.AddRange(Dvorane); context.SaveChanges(); var Predstave = new Predstava[] { new Predstava { FilmID = 1, DvoranaID = 1, Predstava_cas = "30.01.2021 - 18:00" }, new Predstava { FilmID = 1, DvoranaID = 1, Predstava_cas = "30.01.2021 - 21:00" }, new Predstava { FilmID = 3, DvoranaID = 2, Predstava_cas = "30.01.2021 - 19:00" }, new Predstava { FilmID = 2, DvoranaID = 3, Predstava_cas = "31.01.2021 - 22:00" }, new Predstava { FilmID = 4, DvoranaID = 2, Predstava_cas = "31.01.2021 - 20:00" }, }; context.Predstave.AddRange(Predstave); context.SaveChanges(); var Sedezi = new Sedez[] { new Sedez { DvoranaID = 1, Sedez_tip = "Navaden" }, new Sedez { DvoranaID = 1, Sedez_tip = "Navaden" }, new Sedez { DvoranaID = 1, Sedez_tip = "Navaden" }, new Sedez { DvoranaID = 1, Sedez_tip = "Navaden" }, new Sedez { DvoranaID = 1, Sedez_tip = "Navaden" }, new Sedez { DvoranaID = 1, Sedez_tip = "VIP" }, new Sedez { DvoranaID = 1, Sedez_tip = "VIP" }, new Sedez { DvoranaID = 1, Sedez_tip = "VIP" }, new Sedez { DvoranaID = 2, Sedez_tip = "Navaden" }, new Sedez { DvoranaID = 2, Sedez_tip = "Navaden" }, new Sedez { DvoranaID = 2, Sedez_tip = "Navaden" }, new Sedez { DvoranaID = 2, Sedez_tip = "VIP" }, new Sedez { DvoranaID = 2, Sedez_tip = "VIP" }, new Sedez { DvoranaID = 2, Sedez_tip = "VIP" }, new Sedez { DvoranaID = 2, Sedez_tip = "VIP" }, new Sedez { DvoranaID = 2, Sedez_tip = "VIP" }, }; context.Sedezi.AddRange(Sedezi); context.SaveChanges(); var Karte = new Karta[] { new Karta { PredstavaID = 1, Karta_cena = 7.00 }, new Karta { PredstavaID = 1, Karta_cena = 13.80 }, new Karta { PredstavaID = 2, Karta_cena = 19.90 }, new Karta { PredstavaID = 3, Karta_cena = 12.00 }, }; context.Karte.AddRange(Karte); context.SaveChanges(); }