public void insertCareerStats(careerStats combinedStats) { MySqlCommand queryCommand = new MySqlCommand(); queryCommand.Connection = conn; queryCommand.CommandText = "UPDATE playerStats SET pawnsEaten = @pawnsEaten, pawnsLost = @pawnsLost, finalScore = @finalScore" + "WHERE personID= @personID"; queryCommand.Prepare(); queryCommand.Parameters.AddWithValue("@personID", combinedStats.getID()); queryCommand.Parameters.AddWithValue("@pawnsEaten", combinedStats.getpawnsEaten()); queryCommand.Parameters.AddWithValue("@pawnsLost", combinedStats.getPawnsLost()); queryCommand.Parameters.AddWithValue("@finalScore", combinedStats.getFinalScore()); try { MySqlDataReader reader = queryCommand.ExecuteReader(); } catch (Exception exc) { Console.WriteLine(exc.Message); } }
public careerStats getNewCareerStats(gameStats y, careerStats x) { careerStats combinedStats = new careerStats(y.getID(), (y.getpawnsEaten() + x.getpawnsEaten()), (y.getPawnsLost() + x.getPawnsLost()), (y.getFinalScore() + x.getFinalScore())); return(combinedStats); }