//edit selected connection button
private void btnEdit_Click(object sender, RoutedEventArgs e)
{
if (cb_Connections.SelectedIndex < 0)
{
return;
}
//populate TextBoxes on Window by selected connection values
ConnectionWindow EditConnWindow = new ConnectionWindow();
ConnectionBase connectionBase = cb_Connections.SelectedItem as ConnectionBase;
EditConnWindow.tbBD.Text = connectionBase.Database;
EditConnWindow.tbHost.Text = connectionBase.Host;
EditConnWindow.tbPort.Text = connectionBase.Port;
EditConnWindow.tbUsername.Text = connectionBase.Username;
EditConnWindow.tbNewConnectionName.Text = connectionBase.ConnName;
EditConnWindow.ShowDialog();
if ((bool)EditConnWindow.DialogResult.HasValue && EditConnWindow.DialogResult.Value)
{
//GetNewConnectionValues(EditConnWindow, out string NewConnString, out string newConnName);
//ModifySelectedConnection(NewConnString, newConnName, connectionBase.ConnName);
ConnectionBase new_conn_base = new ConnectionBase()
{
Database = EditConnWindow.tbBD.Text.ToString().Trim(),
Host = EditConnWindow.tbHost.Text.ToString().Trim(),
Port = EditConnWindow.tbPort.Text.ToString().Trim(),
Username = EditConnWindow.tbUsername.Text.ToString().Trim(),
ConnName = EditConnWindow.tbNewConnectionName.Text.ToString().Trim()
};
ModifySelectedConnection(new_conn_base, connectionBase.ConnName);
}
}
//get new values from Dialog controls
private void GetNewConnectionValues(ConnectionWindow win, out string NewConnString, out string newConnName)
{
ConnectionBase new_conn_base = new ConnectionBase();
new_conn_base.Database = win.tbBD.Text.ToString().Trim();
new_conn_base.Host = win.tbHost.Text.ToString().Trim();
new_conn_base.Port = win.tbPort.Text.ToString().Trim();
new_conn_base.Username = win.tbUsername.Text.ToString().Trim();
new_conn_base.ConnName = win.tbNewConnectionName.Text.ToString().Trim();
NewConnString = new_conn_base.BuildConnectionString();
newConnName = new_conn_base.ConnName;
}
//add new connection button
private void btnAdd_Click(object sender, RoutedEventArgs e)
{
ConnectionWindow NewConnWindow = new ConnectionWindow();
NewConnWindow.ShowDialog();
if ((bool)NewConnWindow.DialogResult.HasValue && NewConnWindow.DialogResult.Value)
{
//GetNewConnectionValues(NewConnWindow, out string NewConnString, out string newConnName);
//AddNewConnection(NewConnString, newConnName);
ConnectionBase new_conn_base = new ConnectionBase()
{
Database = NewConnWindow.tbBD.Text.ToString().Trim(),
Host = NewConnWindow.tbHost.Text.ToString().Trim(),
Port = NewConnWindow.tbPort.Text.ToString().Trim(),
Username = NewConnWindow.tbUsername.Text.ToString().Trim(),
ConnName = NewConnWindow.tbNewConnectionName.Text.ToString().Trim()
};
AddNewConnection(new_conn_base);
}
}
