public Database(Player p)
{
MySqlConnectionStringBuilder connBuilder = new MySqlConnectionStringBuilder();
connBuilder.Server = "localhost";
connBuilder.Database = "mydb";
connBuilder.UserID = "root";
connBuilder.Password = "******";
connection = new MySqlConnection(connBuilder.ToString());
bool name_exist = nameCheck(connection, p);
if (name_exist)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = connection;
cmd.CommandText = "UPDATE statictics SET Wins=@Wins, Losses=@Losses ,HighScore=@HighScore WHERE Name = @Name;";
//cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Name", p.getPlayerName());
cmd.Parameters.AddWithValue("@Wins", p.getWins());
cmd.Parameters.AddWithValue("@Losses", p.getLosses());
cmd.Parameters.AddWithValue("@HighScore", p.getHighScore());
cmd.ExecuteNonQuery();
}
catch (Exception)
{
log.Error("Error occured while updating database");
throw;
}
}
else
{
try
{
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "INSERT INTO statictics (Name,Wins,Losses,HighScore)VALUES(@Name,@Wins,@Losses,@HighScore)";
cmd.Parameters.AddWithValue("@Name", p.getPlayerName());
cmd.Parameters.AddWithValue("@Wins", p.getWins());
cmd.Parameters.AddWithValue("@Losses", p.getLosses());
cmd.Parameters.AddWithValue("@HighScore", p.getHighScore());
cmd.ExecuteNonQuery();
}
catch (Exception)
{
log.Error("Error occured while inserting data to a database");
throw;
}
}
/*using (connection)
* {
* string s = "mydb.statictics;";
* MySqlDataAdapter adapter = new MySqlDataAdapter("select * from " + s, connection);
*
* adapter.Fill(ds, s);
*
* }*/
}