public Film SelectByTitle(string title) { using (FilmStoreContext context = new FilmStoreContext()) { return(context.Films.FirstOrDefault(x => x.Title == title)); } }
public Film SelectById(long id) { using (FilmStoreContext context = new FilmStoreContext()) { return(context.Films.FirstOrDefault(x => x.Id == id)); } }
public ICollection <Film> SelectAll() { using (FilmStoreContext context = new FilmStoreContext()) { return(context.Films.ToList()); } }
public ICollection <Film> SearchByTitle(string title) { using (FilmStoreContext context = new FilmStoreContext()) { return(context.Films.Where(x => x.Title.Contains(title)).ToList()); } }
public bool Update(Film film) { using (FilmStoreContext context = new FilmStoreContext()) { context.Entry(film).State = EntityState.Modified; int i = context.SaveChanges(); return(i == 1 ? true : false); } }
public long Insert(Film film) { using (FilmStoreContext context = new FilmStoreContext()) { context.Entry(film).State = EntityState.Added; context.SaveChanges(); return(film.Id); } }