public List <int> GetSelectedCategoriesByMovieId(int movieId) { using (OMDBEntities context = new OMDBEntities()) { MovieCategoryRepository crepo = new MovieCategoryRepository(); return(crepo.Where(x => x.MovieId == movieId).Select(x => x.CategoryId).ToList()); } }
public void RemoveById(int id) { MovieCastCrewRepository marepo = new MovieCastCrewRepository(); MovieCategoryRepository crepo = new MovieCategoryRepository(); marepo.RemoveRange(x => x.MovieId == id); crepo.RemoveRange(x => x.MovieId == id); Remove(id); }
public void Create(Movie movie, List <int> MovieCategories) { Add(movie); if (MovieCategories != null) { MovieCategoryRepository crepo = new MovieCategoryRepository(); foreach (var item in MovieCategories) { MovieCategory mcategory = new MovieCategory(); mcategory.MovieId = movie.Id; mcategory.CategoryId = item; crepo.Create(mcategory); } } }