public void Insert(Usuario newUsuario)
{
MySqlConnector conexao = new MySqlConnector(_strConexao);
conexao.Open();
string sql = "INSERT INTO usuario (nome, login, senha) VALUES (@Nome,@Login, @Senha)";
MySqlCommand comando = new MySqlCommand(sql, conexao);
comando.Parameters.AddWithValue("@Nome", newUsuario.Nome);
comando.Parameters.AddWithValue("@Login", newUsuario.Login);
comando.Parameters.AddWithValue("@Senha", newUsuario.Senha);
comando.ExecuteNonQuery();
conexao.Close();
}
/// <summary>
/// Closes the singleton connection
/// </summary>
public override void CloseConnection()
{
connector.Close();
}
private void CloseConnection()
{
Logger.Info("Closing connection..");
connector.Close();
}
