protected override void SaveConfig(ConfigBase config)
{
DBToolConfig dbToolConfig = config as DBToolConfig;
string name = comboBoxName.Text;
DBToolConnection conn = dbToolConfig.Connections.FirstOrDefault(c => c.Name == name);
if (conn == null)
{
conn = new DBToolConnection();
conn.Name = name;
conn.Type = (DatabaseType)Enum.Parse(typeof(DatabaseType), cbxDatabaseType.Text);
conn.DataSource = textBoxDataSource.Text;
conn.Username = textBoxUsername.Text;
conn.Password = textBoxPassword.Text;
dbToolConfig.Connections.Add(conn);
(comboBoxName.DataSource as BindingList<DBToolConnection>).ResetBindings();
comboBoxName.SelectedIndex = dbToolConfig.Connections.Count - 1;
}
else
{
conn.Type = (DatabaseType)Enum.Parse(typeof(DatabaseType), cbxDatabaseType.Text);
conn.DataSource = textBoxDataSource.Text;
conn.Username = textBoxUsername.Text;
conn.Password = textBoxPassword.Text;
}
}
public IDBBrowsable GetBrowser(DBToolConnection conn)
{
Load();
IDBBrowsable browser = Browsers.FirstOrDefault(b => b.DatabaseType == conn.Type);
if (browser != null)
{
browser.Connection = conn;
}
return browser;
}
public int IndexOf(DBToolConnection info)
{
int result = -1;
for (int i = 0; i < this.Connections.Count; i++)
{
if (info.DataSource.Equals(this.Connections[i].DataSource))
{
result = i;
break;
}
}
return result;
}
public Database(DBToolConnection conn)
{
this.conn = conn;
}
public Instance(DBToolConnection conn)
{
this.conn = conn;
}
private void btnTest_Click(object sender, EventArgs e)
{
lblTestResult.Text = "Connecting...";
Application.DoEvents();
DBToolConnection conn = new DBToolConnection();
conn.Name = comboBoxName.Text;
conn.Type = (DatabaseType)Enum.Parse(typeof(DatabaseType), cbxDatabaseType.Text);
conn.DataSource = textBoxDataSource.Text;
conn.Username = textBoxUsername.Text;
conn.Password = textBoxPassword.Text;
DBBrowserLoader loader = new DBBrowserLoader();
IDBBrowsable browser = loader.GetBrowser(conn);
bool testSuccessed = browser.TestConnection();
if (testSuccessed)
{
lblTestResult.Text = "Success";
}
else
{
lblTestResult.Text = "Fail";
}
}
public Table(DBToolConnection conn)
{
this.conn = conn;
}
