private void AddPlayerLog()
{
try
{
DataHandler dh = new DataHandler();
playerLog pl = new playerLog(MilitaryGame.playerID, recordedHealth.Min().ToString(), recordedFuel.Min().ToString(),
allRecordedSpeeds.Max().ToString(), allRecordedAltitudes.Max().ToString(), PickAircraft.aircraftUsed);
dh.AddPlayerLog(pl);
}
catch (Exception)
{
MessageBox.Show("An error occurred when adding your results", "Error");
}
}
public void AddPlayerLog(playerLog player)
{
conn.Open();
string command = "INSERT INTO tblPlayer_Log (playerID, Health, Fuel, MaxSpeed, MaxAltitude, AircraftUsed) VALUES (" +
"'" + player.PlayerId + "'," +
"'" + player.Health + "'," +
"'" + player.Fuel + "'," +
"'" + player.MaxSpeed + "'," +
"'" + player.MaxAltitude + "'," +
"'" + player.AircraftUsed + "')";
OleDbCommand cmd = new OleDbCommand(command, conn);
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
}
