public List <Movie> GetMoviesByDistributor(int distributorId) { using (IMDBEntities7 dbContext = new IMDBEntities7()) { DALDistributor dALDistributor = new DALDistributor(); var distributor = dALDistributor.GetDistributorById(distributorId); List <Movie> movies = new List <Movie>(); if (distributor != null) { foreach (var movie in AllMovies()) { if (movie.Distributor_Id == distributor.Id) { movies.Add(movie); } } } return(movies); } }