private void Button1_Click(object sender, EventArgs e)
{
if (serverData.Count > 0)
{
var server = sqlservers.CreateSqlServerFromDataTable(serverData, comboBox1);
if (server != null)
{
server.password = textBoxPassword.Text;
ConnectionResultSet result = DB.TestConnection(server);
if (result.wasSuccessful)
{
var con = DB.connect(server);
this.OnConnectionChanged(this, new ConnectionEventArgs(con, server));
Close();
}
else
{
this.UseWaitCursor = false;
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
WarnNoServersSaved();
}
}
private void Button2_Click(object sender, EventArgs e)
{
if (serverData.Count > 0)
{
var server = DbUtils.getSqlServerFromTable(serverData, comboBox1);
if (server != null)
{
//test connection
ConnectionResultSet result = DB.TestConnection(server);
if (result.wasSuccessful)
{
this.UseWaitCursor = false;
MessageBox.Show("Connection Successful", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
this.UseWaitCursor = false;
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
else
{
WarnNoServersSaved();
}
}
private void fillTreeView()
{
if (cmbServers.Items.Count == 0)
{
return;
} //ama den iparxei kanenas server den to kanei
sqlservers server = null;
this.Invoke((MethodInvoker) delegate()
{
server = sqlservers.CreateSqlServerFromDataTable(serverData, cmbServers);
});
ConnectionResultSet result = DB.TestConnection(server);
if (result.wasSuccessful)
{
DbConnection con = DB.connect(server);
List <string> databases = null;
if (Utils._convert(server.db_type) == sqlbox.commons.DbType.SQLITE)
{
databases = new List <string>()
{
"main"
};
}
else
{
databases = new SqlBuilderFactory(server)
.Create(null).removeSystemDatabases(DbDataHelper.getDatabases(server, con), !hideSystemDatabases);
}
foreach (string database in databases)
{
this.Invoke((MethodInvoker) delegate()
{
TreeNode node = new TreeNode(database);
node.ImageIndex = 0;
List <string> tables = DbDataHelper.getTables(server, database, con);
foreach (string table in tables)
{
TreeNode tablenode = new TreeNode(table);
tablenode.ImageIndex = 1;
node.Nodes.Add(tablenode);
}
tvDatabases.Nodes.Add(node);
});
}
DB.close(con);
}
else
{
this.Invoke((MethodInvoker) delegate()
{
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
});
}
}
private void Reconnect()
{
if (server != null && con != null)
{
con.Close();
ConnectionResultSet result = DB.TestConnection(server);
if (result.wasSuccessful)
{
var con = DB.connect(server, this.con.Database);
this.SetReconnectionStatus(con);
}
}
}
private void fillDatabaseCmb(object sender, DoWorkEventArgs args)
{
if (cmbServers.Items.Count == 0)
{
return;
} //ama den iparxei kanenas server den to kanei
DbConnection con = new DbConnection();
con.Host = (string)serverData.Rows[cmbServers.SelectedIndex]["host"];
con.port = unchecked ((int)(long)serverData.Rows[cmbServers.SelectedIndex]["port"]);
con.username = (string)serverData.Rows[cmbServers.SelectedIndex]["username"];
con.password = (string)serverData.Rows[cmbServers.SelectedIndex]["password"];
Console.WriteLine("cmbServers.Items.Count" + cmbServers.Items.Count);
//edw prepei na bei to database kai mia if then else apo katw analoga ama kanei connect se server i se database
try {
ConnectionResultSet result = con.testConnection();
if (result.wasSuccessful)
{
List <string> databases = con.getDatabases();
databases.Remove("information_schema");
databases.Remove("mysql");
databases.Remove("performance_schema");
databases.Remove("sys");
cmbdatabase.Items.Clear();
foreach (string database in databases)
{
TreeNode node = new TreeNode(database);
node.ImageIndex = 0;
cmbdatabase.Items.Add(database);
Console.WriteLine(database);
}
if (cmbdatabase.Items.Count > 0)
{
cmbdatabase.SelectedIndex = 0;
}
}
else
{
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void fillTreeView()
{
if (cmbServers.Items.Count == 0)
{
return;
} //ama den iparxei kanenas server den to kanei
sqlservers server = null;
this.Invoke((MethodInvoker) delegate()
{
server = DbUtils.getSqlServerFromTable(serverData, cmbServers);
});
//edw prepei na bei to database kai mia if then else apo katw analoga ama kanei OldMySqlConnect se server i se database
ConnectionResultSet result = DB.TestConnection(server);
if (result.wasSuccessful)
{
MySqlConnection con = (MySqlConnection)DB.connect(server);
List <string> databases = DbUtils.getDatabases(server, con);//con.getDatabases();
if (hideSystemDatabases)
{
databases = DbUtils.removeSystemDatabases(databases);
}
foreach (string database in databases)
{
this.Invoke((MethodInvoker) delegate() {
TreeNode node = new TreeNode(database);
node.ImageIndex = 0;
List <string> tables = DbUtils.getTables(server, database, con);
foreach (string table in tables)
{
TreeNode tablenode = new TreeNode(table);
tablenode.ImageIndex = 1;
node.Nodes.Add(tablenode);
}
tvDatabases.Nodes.Add(node);
});
}
DB.close(con);
}
else
{
this.Invoke((MethodInvoker) delegate() {
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
});
}
}
private void fillDatabaseCmb(object sender, DoWorkEventArgs args)
{
if (cmbServers.Items.Count == 0)
{
return;
} //ama den iparxei kanenas server den to kanei
//edw prepei na bei to database kai mia if then else apo katw analoga ama kanei OldMySqlConnect se server i se database
try {
ConnectionResultSet result = DB.TestConnection(this.getServerFromUI());//con.testConnection();
if (result.wasSuccessful)
{
using (var con = DB.connect(this.getServerFromUI()))
{
List <string> databases = DbUtils.getDatabases(this.getServerFromUI());
databases.Remove("information_schema");
databases.Remove("mysql");
databases.Remove("performance_schema");
databases.Remove("sys");
cmbdatabase.Items.Clear();
foreach (string database in databases)
{
TreeNode node = new TreeNode(database);
node.ImageIndex = 0;
cmbdatabase.Items.Add(database);
Console.WriteLine(database);
}
if (cmbdatabase.Items.Count > 0)
{
cmbdatabase.SelectedIndex = 0;
}
}
}
else
{
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void bTestConnection_Click(object sender, EventArgs e)
{
if (!performChecks())
{
return;
}
//test connection
ConnectionResultSet result = con.testConnection();
if (result.wasSuccessful)
{
MessageBox.Show("Connection Successful", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void bTestConnection_Click(object sender, EventArgs e)
{
if (!performChecks())
{
return;
}
this.UseWaitCursor = true;
//test connection
ConnectionResultSet result = DB.TestConnection(createMySqlServerInfoCreds(), tbDatabase.Text);
if (result.wasSuccessful)
{
this.UseWaitCursor = false;
MessageBox.Show("Connection Successful", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
this.UseWaitCursor = false;
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void fillTreeView()
{
if (cmbServers.Items.Count == 0)
{
return;
} //ama den iparxei kanenas server den to kanei
DbConnection con = new DbConnection();
this.Invoke((MethodInvoker) delegate()
{
con.Host = (string)serverData.Rows[cmbServers.SelectedIndex]["host"];
con.port = unchecked ((int)(long)serverData.Rows[cmbServers.SelectedIndex]["port"]);
con.username = (string)serverData.Rows[cmbServers.SelectedIndex]["username"];
con.password = (string)serverData.Rows[cmbServers.SelectedIndex]["password"];
});
//edw prepei na bei to database kai mia if then else apo katw analoga ama kanei connect se server i se database
ConnectionResultSet result = con.testConnection();
if (result.wasSuccessful)
{
List <string> databases = con.getDatabases();
if (hideSystemDatabases)
{
databases.Remove("information_schema");
databases.Remove("mysql");
databases.Remove("performance_schema");
databases.Remove("sys");
}
foreach (string database in databases)
{
this.Invoke((MethodInvoker) delegate() {
TreeNode node = new TreeNode(database);
node.ImageIndex = 0;
List <string> tables = con.getTables(database);
foreach (string table in tables)
{
TreeNode tablenode = new TreeNode(table);
tablenode.ImageIndex = 1;
node.Nodes.Add(tablenode);
}
tvDatabases.Nodes.Add(node);
});
}
this.Invoke((MethodInvoker) delegate() {
ToolStripMenuItem opendb = new ToolStripMenuItem();
ToolStripMenuItem analyzedb = new ToolStripMenuItem();
opendb.Text = "browse data";
opendb.Tag = "sql";
opendb.Click += new EventHandler(menuClick);
analyzedb.Text = "inspect database";
analyzedb.Click += new EventHandler(menuClick);
ContextMenuStrip menu = new ContextMenuStrip();
menu.Items.AddRange(new ToolStripMenuItem[] { opendb, analyzedb });
tvDatabases.ContextMenuStrip = menu;
});
}
else
{
this.Invoke((MethodInvoker) delegate() {
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
});
}
}
private void fillTreeView()
{
if (cmbServers.Items.Count == 0)
{
return;
} //ama den iparxei kanenas server den to kanei
sqlservers server = null;
this.Invoke((MethodInvoker) delegate()
{
server = DbUtils.getSqlServerFromTable(serverData, cmbServers);
});
//edw prepei na bei to database kai mia if then else apo katw analoga ama kanei OldMySqlConnect se server i se database
ConnectionResultSet result = DB.TestConnection(server);
if (result.wasSuccessful)
{
MySqlConnection con = (MySqlConnection)DB.connect(server);
List <string> databases = DbUtils.getDatabases(server, con);//con.getDatabases();
if (hideSystemDatabases)
{
databases = DbUtils.removeSystemDatabases(databases);
}
foreach (string database in databases)
{
this.Invoke((MethodInvoker) delegate() {
TreeNode node = new TreeNode(database);
node.ImageIndex = 0;
List <string> tables = DbUtils.getTables(server, database, con);
foreach (string table in tables)
{
TreeNode tablenode = new TreeNode(table);
tablenode.ImageIndex = 1;
node.Nodes.Add(tablenode);
}
tvDatabases.Nodes.Add(node);
});
}
this.Invoke((MethodInvoker) delegate() {
ToolStripMenuItem opendb = new ToolStripMenuItem();
ToolStripMenuItem analyzedb = new ToolStripMenuItem();
opendb.Text = "browse data";
opendb.Tag = "sql";
opendb.Click += new EventHandler(menuClick);
analyzedb.Text = "inspect database";
analyzedb.Click += new EventHandler(menuClick);
ContextMenuStrip menu = new ContextMenuStrip();
menu.Items.AddRange(new ToolStripMenuItem[] { opendb, analyzedb });
tvDatabases.ContextMenuStrip = menu;
});
DB.close(con);
}
else
{
this.Invoke((MethodInvoker) delegate() {
MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
});
}
}
