public Film SelectById(int id)
{
using (FilmStoreContext context = new FilmStoreContext())
{
return(context.Films.FirstOrDefault(f => f.Id == id));
}
}
public ICollection <Film> SelectAll()
{
using (FilmStoreContext context = new FilmStoreContext())
{
return(context.Films.ToList());
}
}
public void Insert(Film film)
{
using (FilmStoreContext context = new FilmStoreContext())
{
context.Entry(film).State = EntityState.Added;
context.SaveChanges();
}
}
public bool Delete(Film film)
{
using (FilmStoreContext context = new FilmStoreContext())
{
context.Entry(film).State = EntityState.Deleted;
context.SaveChanges();
return(true);
}
}
public ICollection <Film> SelectByTitle(string searchText)
{
using (FilmStoreContext context = new FilmStoreContext())
{
List <Film> films = searchText == null?
context.Films.ToList() :
context.Films.Where(f => f.Title.Contains(searchText)).ToList();
return(films);
}
}
