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);
}
