//Method that gets all Favorite movies of a specific user public IList <UserFavoriteMovieDTO> GetFavoriteMoviesByUser(Guid userID) { IList <UserFavoriteMovieDTO> ListOfMovies = new List <UserFavoriteMovieDTO>(); using (var context = new CinemaEntities()) { var results = (from fv in context.Favorites.Include("Movie") where fv.UserID == userID select fv); if (results != null) { foreach (var item in results) { UserFavoriteMovieDTO row = new UserFavoriteMovieDTO(); row.userID = userID.ToString(); row.movieID = item.MovieID; row.MovieTitle = item.Movie.Title; ListOfMovies.Add(row); } } } return(ListOfMovies); }
//============================================================================================== #region UserMovieTheater //Method that gets all movies public IList <UserFavoriteMovieDTO> GetListOfMovies() { IList <UserFavoriteMovieDTO> ListOfMovies = new List <UserFavoriteMovieDTO>(); using (var context = new CinemaEntities()) { var results = (from mv in context.Movies select mv); if (results != null) { foreach (var item in results) { UserFavoriteMovieDTO row = new UserFavoriteMovieDTO(); row.movieID = item.MovieID; row.MovieTitle = item.Title; ListOfMovies.Add(row); } } } return(ListOfMovies); }
//Method that gets all Favorite movies of a specific user public IList<UserFavoriteMovieDTO> GetFavoriteMoviesByUser(Guid userID) { IList<UserFavoriteMovieDTO> ListOfMovies = new List<UserFavoriteMovieDTO>(); using (var context = new CinemaEntities()) { var results = (from fv in context.Favorites.Include("Movie") where fv.UserID == userID select fv); foreach (var item in results) { UserFavoriteMovieDTO row = new UserFavoriteMovieDTO(); row.userID = userID.ToString(); row.movieID = item.MovieID; row.MovieTitle = item.Movie.Title; ListOfMovies.Add(row); } } return ListOfMovies; }
//Method that gets all movies public IList<UserFavoriteMovieDTO> GetListOfMovies() { IList<UserFavoriteMovieDTO> ListOfMovies = new List<UserFavoriteMovieDTO>(); using (var context = new CinemaEntities()) { var results = (from mv in context.Movies select mv); if (results != null) { foreach (var item in results) { UserFavoriteMovieDTO row = new UserFavoriteMovieDTO(); row.movieID = item.MovieID; row.MovieTitle = item.Title; ListOfMovies.Add(row); } } } return ListOfMovies; }