public Dvd GetDvd(int dvdId)
{
using (var context = new DvdListEntities())
{
var dvd = (from d in context.DVDs where d.DvdId == dvdId select d).FirstOrDefault();
return(dvd);
}
}
public void EditDvd(Dvd dvd)
{
using (var context = new DvdListEntities())
{
context.Entry(dvd).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public void AddDvd(Dvd dvd)
{
using (var context = new DvdListEntities())
{
context.DVDs.Add(dvd);
context.SaveChanges();
}
}
public List <Dvd> GetAllDvds()
{
using (var context = new DvdListEntities())
{
var dvds = from d in context.DVDs
select d;
return(dvds.ToList());
}
}
public void DeleteDvd(int dvdId)
{
using (var context = new DvdListEntities())
{
var dvd = (from d in context.DVDs where d.DvdId == dvdId select d).FirstOrDefault();
context.DVDs.Remove(dvd);
context.SaveChanges();
}
}
public List <Dvd> GetDvdsByTitle(string dvdTitle)
{
using (var context = new DvdListEntities())
{
var dvds = from d in context.DVDs
where d.Title == dvdTitle
select d;
return(dvds.ToList());
}
}
public List <Dvd> GetDvdsByRating(string rating)
{
using (var context = new DvdListEntities())
{
var dvds = from d in context.DVDs
where d.Rating == rating
select d;
return(dvds.ToList());
}
}
public List <Dvd> GetDvdsByDirector(string directorName)
{
using (var context = new DvdListEntities())
{
var dvds = from d in context.DVDs
where d.Director == directorName
select d;
return(dvds.ToList());
}
}
public List <Dvd> GetDvdsByDate(int year)
{
using (var context = new DvdListEntities())
{
var dvds = from d in context.DVDs
where d.ReleaseYear == year
select d;
return(dvds.ToList());
}
}
