Esempio n. 1
0
        //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);
        }
Esempio n. 2
0
        //==============================================================================================
        #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);
        }
Esempio n. 3
0
        //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;
        }
Esempio n. 4
0
        //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;
        }