public static void Initialize(IServiceProvider serviceProvider)
{
using (var db = new MovieContext(serviceProvider.GetRequiredService <DbContextOptions <MovieContext> >()))
{
if (db.Movie.Any())
{
return;
}
db.Movie.AddRange(
new Movie
{
Title = "When Harry Met Sally",
ReleaseDate = DateTime.Parse("1989-2-12"),
Genre = "Romantic Comedy",
Price = 7.99M,
Rating = "R",
Reviews = new List <Review> {
new Review {
Score = 5
},
new Review {
Score = 1
}
}
},
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-13"
},
new Movie
{
Title = "Rio Bravo",
ReleaseDate = DateTime.Parse("1959-4-15"),
Genre = "Western",
Price = 3.99M,
Rating = "G"
}
);
db.SaveChanges();
}
}
public IActionResult OnPostDeleteReview(int?id)
{
if (!ModelState.IsValid)
{
return(Page());
}
// Find the review in the database
Review Review = _context.Review.FirstOrDefault(r => r.ID == ReviewIdToDelete);
if (Review != null)
{
_context.Remove(Review); // Delete the review
_context.SaveChanges();
}
Movie = _context.Movie.Include(m => m.Reviews).FirstOrDefault(m => m.MovieID == id);
return(Page());
}
