public List <DVD> EditDVD(DVD original, DVD updated) { var repository = new DVDIndexDbContext(); var director = repository.Directors.FirstOrDefault(d => d.DirectorName == updated.DirectorName); if (director == null) { director = repository.Directors.Add(new Director { DirectorName = updated.DirectorName }); } var rating = repository.Ratings.FirstOrDefault(r => r.Rating == updated.Rating); if (rating == null) { rating = repository.Ratings.Add(new RatingClass { Rating = updated.Rating }); } var update = new DVDEF { DvdId = original.DvdId, RatingId = rating.RatingId, DirectorId = director.DirectorId, Title = updated.Title, ReleaseYear = updated.ReleaseYear, Notes = updated.Notes }; repository.Entry(update).State = EntityState.Modified; repository.SaveChanges(); return(GetAll()); }
public List <DVD> AddDVD(DVD dvd) { var repository = new DVDIndexDbContext(); var director = repository.Directors.FirstOrDefault(d => d.DirectorName == dvd.DirectorName); if (director == null) { director = repository.Directors.Add(new Director { DirectorName = dvd.DirectorName }); } var rating = repository.Ratings.FirstOrDefault(r => r.Rating == dvd.Rating); if (rating == null) { rating = repository.Ratings.Add(new RatingClass { Rating = dvd.Rating }); } var update = repository.DVDS.Add( new DVDEF { RatingId = rating.RatingId, DirectorId = director.DirectorId, Title = dvd.Title, ReleaseYear = dvd.ReleaseYear, Notes = dvd.Notes }); repository.SaveChanges(); return(GetAll()); }
public List <DVD> DeleteDVD(int id) { var repository = new DVDIndexDbContext(); var dvd = repository.DVDS.Find(id); repository.DVDS.Remove(dvd); repository.SaveChanges(); return(GetAll()); }
public List <DVD> GetAll() { var repository = new DVDIndexDbContext(); var DVD = from movie in repository.DVDS select new DVD { DvdId = movie.DvdId, Rating = movie.Rating.Rating, DirectorName = movie.Director.DirectorName, Title = movie.Title, ReleaseYear = movie.ReleaseYear, Notes = movie.Notes }; return(DVD.ToList()); }
public DVD GetByTitle(string title) { var repository = new DVDIndexDbContext(); var findDvd = repository.DVDS.Where(d => d.Title.Contains(title)).FirstOrDefault(); DVD dvd = new DVD(); if (findDvd != null) { dvd.DvdId = findDvd.DvdId; dvd.Rating = findDvd.Rating.Rating; dvd.DirectorName = findDvd.Director.DirectorName; dvd.Title = findDvd.Title; dvd.ReleaseYear = findDvd.ReleaseYear; dvd.Notes = findDvd.Notes; return(dvd); } else { dvd.Title = "Not Found"; return(dvd); } }
public DVD GetById(int id) { var repository = new DVDIndexDbContext(); var findDvd = repository.DVDS.Find(id); DVD dvd = new DVD(); if (findDvd != null) { dvd.DvdId = findDvd.DvdId; dvd.Rating = findDvd.Rating.Rating; dvd.DirectorName = findDvd.Director.DirectorName; dvd.Title = findDvd.Title; dvd.ReleaseYear = findDvd.ReleaseYear; dvd.Notes = findDvd.Notes; return(dvd); } else { dvd.Title = "Not Found"; return(dvd); } }