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();
}
