public void PullGameRatingTest()
        {
            GameRating test = new GameRating();

            test = dao.PullGameRating(rtingID);
            Assert.AreEqual(100, test.Game_popularity);
            Assert.AreEqual(200, test.Game_Hype);
            Assert.AreEqual(5, test.Game_Total_Rating);
            Assert.AreEqual(7, test.Game_Total_Rating_Count);
        }
        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 RatingsAddToSQLTest() //Testing is limited due to the values always changing
        {
            IList <GameInfo> testList = new List <GameInfo>();

            testList = mediator.GetGames("Halo", false);
            GameRating testRating = new GameRating();

            testRating = daoGameRatings.PullGameRating(testList[0].ratingId);
            Assert.AreEqual(0, testRating.Game_Hype);
        }