public DVDDetailView GetByID(int ID) //works
{
DVDLibraryEntities Libris = new DVDLibraryEntities();
DVD result = Libris.DVDs.Where(d => d.DVDID == ID).FirstOrDefault();
if (Libris.Notes.Where(n => n.DVDID == ID).FirstOrDefault().Notes == null)
{
result.Note = "no note";
}
else
{
result.Note = Libris.Notes.Where(n => n.DVDID == ID).FirstOrDefault().Notes;
}
DVDDetailView Selected = new DVDDetailView
{
DVDID = result.DVDID,
Director = result.Director,
RatingName = result.Rating.RatingName,
RatingID = result.RatingID,
realeaseYear = result.realeaseYear,
Title = result.Title,
Note = result.Note
};
return(Selected);
}
public IEnumerable <DVDDetailView> FindByTitle(string title)
{
List <DVDDetailView> FinalResult = new List <DVDDetailView>();
DVDLibraryEntities Libris = new DVDLibraryEntities();
var results = from d in Libris.DVDs
where d.Title.Contains(title)
select d;
foreach (DVD r in results)
{
DVDDetailView current = new DVDDetailView();
current.DVDID = r.DVDID;
current.Title = r.Title;
current.Director = r.Director;
current.RatingID = r.RatingID;
current.RatingName = r.Rating.RatingName;
current.realeaseYear = r.realeaseYear;
current.realeaseYear = r.realeaseYear;
if (Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes != null)
{
current.Note = Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes;
}
FinalResult.Add(current);
}
return(FinalResult);
}
public IEnumerable <DVDDetailView> FindbyYear(int year)
{
List <DVDDetailView> FinalResult = new List <DVDDetailView>();
DVDLibraryEntities Libris = new DVDLibraryEntities();
var results = from d in Libris.DVDs
where d.realeaseYear == year
select d;
foreach (DVD r in results)
{
DVDDetailView current = new DVDDetailView();
current.DVDID = r.DVDID;
current.Title = r.Title;
current.Director = r.Director;
current.RatingID = r.RatingID;
current.RatingName = r.Rating.RatingName;
current.realeaseYear = r.realeaseYear;
if (!string.IsNullOrEmpty(Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes))
{
current.Note = Libris.Notes.Where(n => n.DVDID == r.DVDID).FirstOrDefault().Notes;
}
FinalResult.Add(current);
}
return(FinalResult);
}
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 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 IEnumerable <DVDListView> GetAll() //WORKS
{
DVDLibraryEntities Libris = new DVDLibraryEntities();
var results = from DVD in Libris.DVDs
select new DVDListView
{
DVDID = DVD.DVDID,
Director = DVD.Director,
RatingName = DVD.Rating.RatingName,
RatingID = DVD.RatingID,
realeaseYear = DVD.realeaseYear,
Title = DVD.Title
};
return(results.ToList());
}
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();
}
