public void Delete(int dvd) { var repository = new DvdLibraryEntities(); var dvdx = repository.Dvds.FirstOrDefault(m => m.DvdId == dvd); // movie exists? if (dvdx != null) { repository.Dvds.Remove(dvdx); repository.SaveChanges(); } }
public void Update(DVDLibrary.Models.Dvd dvd) { var repository = new DvdLibraryEntities(); Dvd model = new Dvd(); model.DvdId = dvd.DvdId; model.Title = dvd.Title; model.ReleaseYear = dvd.ReleaseYear; model.Director = dvd.Director; model.RatingId = (from r in repository.Ratings where r.RatingName == dvd.Rating select r.RatingId).FirstOrDefault(); //fix this model.Notes = dvd.Notes; repository.Entry(model).State = EntityState.Modified; repository.SaveChanges(); }
public void Insert(DVDLibrary.Models.Dvd dvd) { var repository = new DvdLibraryEntities(); Dvd dvdx = new Dvd(); dvdx.Title = dvd.Title; dvdx.RatingId = (from r in repository.Ratings where r.RatingName == dvd.Rating select r.RatingId).FirstOrDefault(); //fix this dvdx.ReleaseYear = dvd.ReleaseYear; dvdx.Director = dvd.Director; dvdx.Notes = dvd.Notes; repository.Dvds.Add(dvdx); repository.SaveChanges(); dvdx.RatingId = dvd.DvdId; }