public IList <DisplayResults> GetUserList(string username)
        {
            IList <DisplayResults> getUserGames = new List <DisplayResults>();

            IList <UserGameInfo> userGame = new List <UserGameInfo>();

            userGame = userGameInfoSQLDAO.PullUserGameInfo(username);

            foreach (UserGameInfo x in userGame)
            {
                DisplayResults newGameResult = new DisplayResults();
                newGameResult.UserGameInfo = x;
                newGameResult.GameInfo     = gameInfoSQLDAO.PullGameByID(x.Game_Id);
                newGameResult.Rating       = gameRatingSQLDAO.PullGameRating(newGameResult.GameInfo.ratingId);
                newGameResult.Franchise    = franchiseSQLDAO.PullSpecificFranchise(newGameResult.GameInfo.franchiseID);
                newGameResult.Genre        = genresSQLDAO.PullGenreList(newGameResult.GameInfo.genreID);
                newGameResult.Platform     = platformsSQLDAO.PullPlatformList(newGameResult.GameInfo.platformID);

                getUserGames.Add(newGameResult);
            }



            return(getUserGames);
        }
        public void PullGamebyIDTest()
        {
            GameInfo test = new GameInfo();

            test = dao.PullGameByID(200);
            Assert.AreEqual("CW 01", test.gameName);
        }