private bool RegisterUserToDatabase(string username, string password, long id)
{
MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder();
builder.Server = "127.0.0.1";
builder.UserID = "root";
builder.Password = "arda6464";
builder.SslMode = MySqlSslMode.Disabled;
builder.Database = Configuration.Instance.DatabaseName;
builder.CharacterSet = "utf8mb4";
JsonConvert.DefaultSettings = () => new JsonSerializerSettings
{
DefaultValueHandling = DefaultValueHandling.Ignore,
NullValueHandling = NullValueHandling.Ignore
};
string connectionString = builder.ToString();
bool success = false;
try.
{
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
string query = "INSERT INTO users (username, password, id) VALUES (@username, @password, @id)";
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.Parameters.AddWithValue("@username", username);
cmd.Parameters.AddWithValue("@password", password);
cmd.Parameters.AddWithValue("@id", id);
int rowsAffected = cmd.ExecuteNonQuery();
if (rowsAffected > 0)
{
success = true;
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return success;