public static void CreateNew(Player player) { string[] sql = new string[3] { "", "", "" }; sql[0] = $"SELECT COUNT(1) FROM high_scores WHERE player = '{player.UserName}';"; sql[1] = $"INSERT INTO high_scores (player, score) " + $"VALUES ('{player.UserName}',{player.Score});"; sql[2] = $"UPDATE high_scores SET score =" + $" {player.Score} WHERE player = '{player.UserName}';"; try { var dt = DataBaseConnection.ExecuteQuery(sql[0]); if (dt.Rows[0][0].ToString() == "1") { DataBaseConnection.ExecuteNonQuery(sql[2]); } else { DataBaseConnection.ExecuteNonQuery(sql[1]); } } catch (NpgsqlException ex) { MessageBox.Show("An error has occured in the database.\n" + ex.Message, "Server Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly); } catch (Exception ex) { MessageBox.Show("An error has occured.\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly); } }