public void Create(Movie movie)
{
using (MovieLibraryContext db = new MovieLibraryContext())
{
db.Movies.Add(movie);
db.SaveChanges();
}
}
public List <Movie> ReadMovies()
{
List <Movie> _listOfMovies = new List <Movie>();
using (MovieLibraryContext db = new MovieLibraryContext())
{
foreach (var i in db.Movies)
{
_listOfMovies.Add(i);
}
}
return(_listOfMovies);
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new MovieLibraryContext(
serviceProvider.GetRequiredService <DbContextOptions <MovieLibraryContext> >()))
{
// 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-1-11"),
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 = "Unrated"
}
);
context.SaveChanges();
}
}
public MovieRepository(MovieLibraryContext context)
{
this.context = context;
}
public MoviesController(MovieLibraryContext context)
{
_context = context;
}
public CommentsRepository(MovieLibraryContext context)
{
this.context = context;
}
public Uow(MovieLibraryContext context)
{
this.context = context;
}
