public void TestGamesPlayedUserStats() { Games addStats = new Games(); BrainFartController.DeleteStats(14); addStats.UserID = 14; addStats.QuestionsCorrect = 4; addStats.QuestionsMissed = 4; addStats.Score = 100; int newStats = BrainFartController.AddUserStats(addStats); int gamesPlayed = BrainFartController.userGamesPlayed(14); bool addStatsCorrectSuccess = gamesPlayed == 1; Assert.AreEqual(true, addStatsCorrectSuccess); BrainFartController.DeleteStats(14); }
public void TestAddUserStats() { Games addStats = new Games(); BrainFartController.DeleteStats(14); addStats.UserID = 14; addStats.QuestionsCorrect = 4; addStats.QuestionsMissed = 4; int newStats = BrainFartController.AddUserStats(addStats); int statsCorrect = BrainFartController.userQuestionsCorrect(14); bool addStatsCorrectSuccess = statsCorrect == 4; int statsMissed = BrainFartController.userQuestionsMissed(14); bool addStatsMissedSuccess = statsCorrect == 4; Assert.AreEqual(true, addStatsCorrectSuccess); Assert.AreEqual(true, addStatsMissedSuccess); BrainFartController.DeleteStats(14); }
private void frmEndGame_Load(object sender, EventArgs e) { lblTotalPoints.Text = this.totalPoint; lblIncorrect.Text = Convert.ToString(this.incorrect); lblCorrect.Text = Convert.ToString(this.correct); UserAccessController uac = UserAccessController.Instance; if (uac.CurrentLoggedUser != null) { this.loggedInLabel.Text = uac.CurrentLoggedUser.UserName; game = new Games(); this.saveStats(game); try { this.game.GamesID = BrainFartController.AddUserStats(game); } catch (InvalidOperationException ioe) { throw ioe; } } }
/// <summary> /// Insert a Game row to the Games table /// </summary> /// <param name="game">The input Game row object</param> /// <returns>The GamesID for the row inserted</returns> /// public static int AddUserStats(Games game) { string insertStatement = "INSERT Games " + "(UserID, Score, QuestionsMissed, QuestionsCorrect) " + "VALUES (@UserID, @Score, @QuestionsMissed, @QuestionsCorrect)"; try { using (SqlConnection connection = BrainFartConnection.GetConnection()) { connection.Open(); using (SqlCommand insertCommand = new SqlCommand(insertStatement, connection)) { insertCommand.Parameters.AddWithValue("@UserID", game.UserID); insertCommand.Parameters.AddWithValue("@Score", game.Score); insertCommand.Parameters.AddWithValue("@QuestionsMissed", game.QuestionsMissed); insertCommand.Parameters.AddWithValue("@QuestionsCorrect", game.QuestionsCorrect); insertCommand.ExecuteNonQuery(); // Check for using statement use string selectStatement = "SELECT IDENT_CURRENT('Games') FROM Games"; // Check for backticks instead of single quotes using (SqlCommand selectCommand = new SqlCommand(selectStatement, connection)) { int gamesID = Convert.ToInt32(selectCommand.ExecuteScalar()); return gamesID; } } } } catch (SqlException se) { throw se; } catch (Exception ex) { throw ex; } }
public void TestSumMaxAvgUserStats() { Games addStats = new Games(); BrainFartController.DeleteStats(14); addStats.UserID = 14; addStats.QuestionsCorrect = 4; addStats.QuestionsMissed = 4; addStats.Score = 100; int newStats = BrainFartController.AddUserStats(addStats); int statsAvg = BrainFartController.userGamesAvg(14); bool addStatsCorrectSuccess = statsAvg == 100; int statsMax = BrainFartController.userHighScore(14); bool addStatsMissedSuccess = statsMax == 100; Assert.AreEqual(true, addStatsCorrectSuccess); Assert.AreEqual(true, addStatsMissedSuccess); BrainFartController.DeleteStats(14); }
private void saveStats(Games game) { int talley = Convert.ToInt32(this.lblTotalPoints.Text); game.GamesID = this.game.GamesID; game.UserID = userAccess.CurrentLoggedUser.UserID; game.Score = talley; game.QuestionsMissed = this.incorrect; game.QuestionsCorrect = this.correct; }
public static int AddUserStats(Games game) { return GamesDAL.AddUserStats(game); }