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