public void AddDVD(DVD ToAdd)
{
DVDLibraryEntities Libris = new DVDLibraryEntities();
Libris.DVDs.Add(ToAdd);
Libris.SaveChanges();
Note ToAddNote = new Note
{
DVDID = (Libris.DVDs.Max(d => d.DVDID)),
Notes = ToAdd.Note
};
Libris.Notes.Add(ToAddNote);
Libris.SaveChanges();
}
public void DeleteDvD(int DVDID) //WORKS
{
DVDLibraryEntities Libris = new DVDLibraryEntities();
var dvd = Libris.DVDs.Where(d => d.DVDID == DVDID).FirstOrDefault();
if (dvd != null)
{
Libris.Notes.Remove(Libris.Notes.Where(d => d.DVDID == DVDID).FirstOrDefault());
Libris.DVDs.Remove(Libris.DVDs.Where(d => d.DVDID == DVDID).FirstOrDefault());
Libris.SaveChanges();
}
}
public void EditDVD(DVD ToEdit)
{
DVDLibraryEntities Libris = new DVDLibraryEntities();
DVD dvd = new DVD();
dvd.DVDID = ToEdit.DVDID;
dvd.Title = ToEdit.Title;
dvd.Director = ToEdit.Director;
dvd.RatingID = ToEdit.RatingID;
dvd.RatingName = ToEdit.RatingName;
dvd.realeaseYear = ToEdit.realeaseYear;
Note noteedit = Libris.Notes.Where(n => n.DVDID == ToEdit.DVDID).FirstOrDefault();
noteedit.Notes = ToEdit.Note;
Libris.Entry(dvd).State = System.Data.Entity.EntityState.Modified;
Libris.Entry(noteedit).State = System.Data.Entity.EntityState.Modified;
Libris.SaveChanges();
}