public void Delete(int dvdId)
{
using (DvdCatalogEntities data = new DvdCatalogEntities())
{
data.Dvds.Remove(data.Dvds.FirstOrDefault(x => x.DvdId == dvdId));
data.SaveChanges();
}
}
public List <Rating> GetRatings()
{
List <Rating> ratings = new List <Rating>();
using (DvdCatalogEntities data = new DvdCatalogEntities())
{
var getAll = (from r in data.Ratings select r);
foreach (var x in getAll)
{
Rating rating = new Rating();
rating.RatingId = x.RatingId;
rating.RatingName = x.RatingName;
ratings.Add(rating);
}
}
return(ratings);
}
public List <Director> GetDirectors()
{
List <Director> directors = new List <Director>();
using (DvdCatalogEntities data = new DvdCatalogEntities())
{
var getAll = (from r in data.Directors select r);
foreach (var x in getAll)
{
Director director = new Director();
director.DirectorId = x.DirectorId;
director.DirectorName = x.DirectorName;
directors.Add(director);
}
}
return(directors);
}
public GetDvds GetById(int dvdId)
{
GetDvds dvd = new GetDvds();
using (DvdCatalogEntities data = new DvdCatalogEntities())
{
var getDvd = (from r in data.Dvds.Include("Director").Include("Rating") where r.DvdId == dvdId select r);
foreach (var x in getDvd)
{
dvd.DvdId = x.DvdId;
dvd.Title = x.Title;
dvd.ReleaseYear = x.ReleaseYear;
dvd.Director = x.Director.DirectorName;
dvd.Rating = x.Rating.RatingName;
dvd.Notes = x.Notes;
}
}
return(dvd);
}
public List <GetDvds> GetByDirector(string directorName)
{
List <GetDvds> dvds = new List <GetDvds>();
using (DvdCatalogEntities data = new DvdCatalogEntities())
{
var getByDirector = (from r in data.Dvds.Include("Director").Include("Rating") where r.Director.DirectorName == directorName select r);
foreach (var x in getByDirector)
{
GetDvds dvd = new GetDvds();
dvd.DvdId = x.DvdId;
dvd.Title = x.Title;
dvd.ReleaseYear = x.ReleaseYear;
dvd.Director = x.Director.DirectorName;
dvd.Rating = x.Rating.RatingName;
dvd.Notes = x.Notes;
dvds.Add(dvd);
}
}
return(dvds);
}
public void SaveNew(string title, int releaseYear, string directorName, string ratingName, string notes)
{
Dvd dvd = new Dvd();
using (DvdCatalogEntities data = new DvdCatalogEntities())
{
dvd.Director = (from x in data.Directors select x).FirstOrDefault(y => y.DirectorName == directorName);
if (dvd.Director == null)
{
Director director = new Director();
director.DirectorName = directorName;
data.Directors.Add(director);
}
dvd.Rating = (from r in data.Ratings select r).First(x => x.RatingName == ratingName);
dvd.ReleaseYear = releaseYear;
dvd.Title = title;
dvd.Notes = notes;
data.Dvds.Add(dvd);
data.SaveChanges();
}
}
public void Edit(int dvdId, string title, int releaseYear, string directorName, string ratingName, string notes)
{
using (DvdCatalogEntities data = new DvdCatalogEntities())
{
Dvd dvd = data.Dvds.FirstOrDefault(x => x.DvdId == dvdId);
dvd.Title = title;
dvd.ReleaseYear = releaseYear;
var directorCheck = data.Directors.FirstOrDefault(
y =>
y.DirectorName == directorName
);
dvd.Director = directorCheck;
if (dvd.Director == null || dvd.Director.DirectorName == "")
{
Director director = new Director();
director.DirectorName = directorName;
data.Directors.Add(director);
dvd.Director = director;
}
dvd.Rating = data.Ratings.First(x => x.RatingName == ratingName);
dvd.Notes = notes;
data.SaveChanges();
}
}
