public void EditDvd(Dvd dvd, int id) { DvdLibraryEFEntities db = new DvdLibraryEFEntities(); dvd.DvdId = id; db.Dvds.AddOrUpdate(d => d.DvdId, dvd); db.SaveChanges(); }
public void DeleteDvd(int id) { DvdLibraryEFEntities db = new DvdLibraryEFEntities(); var target = db.Dvds.Find(id); if (target != null) { db.Dvds.Remove(target); } db.SaveChanges(); }
public void AddDvd(Dvd dvd) { DvdLibraryEFEntities db = new DvdLibraryEFEntities(); //IEnumerable<DbEntityValidationResult> validation = db.GetValidationErrors(); bool valid = (dvd.Title != null && dvd.RealeaseYear > 0 && dvd.Director != null && dvd.Rating != null); //foreach (var v in validation) //{ // valid = v.IsValid; //} if (valid) { db.Dvds.AddOrUpdate(dvd); db.SaveChanges(); } }
public List <Dvd> GetByYear(int year) { DvdLibraryEFEntities db = new DvdLibraryEFEntities(); return(db.Dvds.Where(d => d.RealeaseYear == year).Select(d => d).ToList()); }
public List <Dvd> GetByTitle(string title) { DvdLibraryEFEntities db = new DvdLibraryEFEntities(); return(db.Dvds.Where(d => d.Title == title).Select(d => d).ToList()); }
public List <Dvd> GetByRating(string rating) { DvdLibraryEFEntities db = new DvdLibraryEFEntities(); return(db.Dvds.Where(d => d.Rating == rating).Select(d => d).ToList()); }
public Dvd GetById(int id) { DvdLibraryEFEntities db = new DvdLibraryEFEntities(); return(db.Dvds.FirstOrDefault(d => d.DvdId == id)); }
public List <Dvd> GetByDirector(string director) { DvdLibraryEFEntities db = new DvdLibraryEFEntities(); return(db.Dvds.Where(d => d.Director == director).ToList()); }
public List <Dvd> GetAll() { DvdLibraryEFEntities db = new DvdLibraryEFEntities(); return(db.Dvds.ToList()); }