public static async Task Initialize(IServiceProvider serviceProvider, string testUserPW)
{
using (var context = new SandboxContext(serviceProvider.GetRequiredService <DbContextOptions <SandboxContext> >()))
{
var adminID = await EnsureUser(serviceProvider, testUserPW, "*****@*****.**");
await EnsureRole(serviceProvider, adminID, Constants.AdministratorRole);
var managerID = await EnsureUser(serviceProvider, testUserPW, "*****@*****.**");
await EnsureRole(serviceProvider, managerID, Constants.ManagerRole);
SeedDB(context, adminID);
}
}//end of seed data
public static void SeedDB(SandboxContext context, string adminID)
{
//Look for any movies
if (context.Movie.Any())
{
return; //DB has been seeded
}
context.Movie.AddRange
(
new Movie
{
Title = "When Harry Met Sally",
ReleaseDate = DateTime.Parse("1989-2-12"),
Genre = "Romantic Comedy",
Price = 7.99m,
Rating = "R"
},
new Movie
{
Title = "Ghostbusters",
ReleaseDate = DateTime.Parse("1984-3-13"),
Genre = "Comedy",
Price = 8.99m,
Rating = "PG"
},
new Movie
{
Title = "Ghostbusters 2",
ReleaseDate = DateTime.Parse("1986-2-23"),
Genre = "Comedy",
Price = 9.99m,
Rating = "PG"
},
new Movie
{
Title = "Rio Bravo",
ReleaseDate = DateTime.Parse("1959-4-15"),
Genre = "Western",
Price = 3.99m,
Rating = "R"
}
);
context.SaveChanges();
}