public IEnumerable <MovieViewModel> GetMovies() { var movies = db.Movies.ToList(); var moviesViewModels = new List <MovieViewModel>(); foreach (var movie in movies) { var movieViewModel = new MovieViewModel() { ID = movie.Id, Name = movie.Name, Year = movie.YearOfRelease, ProducerID = movie.ProducerId }; var produceractorViewModels = new List <ProducersActorsViewModel>(); var producersactors = db.ProducersActors.Where(c => c.Id == movie.ProducerId).ToList(); foreach (var produceractor in producersactors) { var produceractorViewModel = new ProducersActorsViewModel() { ID = produceractor.Id, Name = produceractor.Name, }; produceractorViewModels.Add(produceractorViewModel); } movieViewModel.producersactors = produceractorViewModels; moviesViewModels.Add(movieViewModel); } return(moviesViewModels); }
public IHttpActionResult GetMovie(int id) { var movie = db.Movies.Find(id); if (movie == null) { return(NotFound()); } var customerViewModel = new MovieViewModel() { ID = movie.Id, Name = movie.Name, Year = movie.YearOfRelease, ProducerID = movie.ProducerId }; var produceractorViewModels = new List <ProducersActorsViewModel>(); var producersactors = db.ProducersActors.Where(c => c.Id == movie.ProducerId).ToList(); foreach (var produceractor in producersactors) { var produceractorViewModel = new ProducersActorsViewModel() { ID = produceractor.Id, Name = produceractor.Name }; produceractorViewModels.Add(produceractorViewModel); } customerViewModel.producersactors = produceractorViewModels; return(Ok(customerViewModel)); }