private void btnAddToken_Click(object sender, EventArgs e)
{
newToken = new DatabaseAccountToken();
cmbTokens.Enabled = false;
btnAddToken.Enabled = false;
cmbDBType.Text = String.Empty;
cmbDBDialect.Text = String.Empty;
txtConnectionString.Text = String.Empty;
txtPasswrd.Text = String.Empty;
txtUserID.Text = String.Empty;
txtDataSource.Text = String.Empty;
rtxtMapping.Text = String.Empty;
txtNewTokenName.Text = String.Empty;
label1.Text = "Choose DB Type";
label2.Text = "Choose DB Dialect";
label4.Text = "Set a conection string details";
panelChoseDBProvider.Show();
btnCancelSaveOrEditingSettings.Show();
label2.Hide();
cmbDBDialect.Hide();
panelConStrDiteils.Hide();
panelPreviewString.Hide();
MakeFieldsEnabled();
groupBoxAccounts.Enabled = false;
cmbDBType.SelectedIndexChanged += cmbDBType_SelectedIndexChanged;
cmbDBDialect.SelectedIndexChanged += cmbDBDialect_SelectedIndexChanged;
btnApplyConSetDiteils.Click += btnApplyConSetDiteils_Click;
btnApplyConSetDiteils.Click -= btnApplyConSetDiteilsForExistingToken_Click;
btnSaveSettings.Click += btnSaveSettings_Click;
btnSaveSettings.Click -= btnSaveChangedSettings_Click;
cmbDBDialect.SelectedIndexChanged -= cmbDBDialect_SelectedIndexChangedForExistingToken;
cmbDBDialect.SelectedIndexChanged -= cmbDBType_SelectedIndexChangedForExistingToken;
cmbDBDialect.SelectedIndexChanged += cmbDBType_SelectedIndexChanged;
cmbDBDialect.SelectedIndexChanged += cmbDBDialect_SelectedIndexChanged;
btnTestConStr.Click += btnTestConStr_Click;
btnTestConStr.Click -= btnTestConStrChanged_Click;
btnChekMapping.Click += btnChekMapping_Click;
btnChekMapping.Click -= btnChekMappingChanged_Click;
}
private void PrepareForShowingTokenDetails(DatabaseAccountToken token)
{
cmbDBType.Text = token.DatabaseDriver.ToString();
cmbDBDialect.Text = token.DatabaseDialect.ToString();
panelChoseDBProvider.Show();
txtUserID.Text = token.UserName;
txtPasswrd.Text = token.Password;
txtDataSource.Text = token.DataSource;
panelConStrDiteils.Show();
txtConnectionString.Text = token.ConnectionString;
panelPreviewString.Show();
rtxtMapping.Text = token.Mapping;
btnApplyConSetDiteils.Hide();
btnTestConStr.Hide();
label1.Text = "Database Type";
label2.Text = "Database Dialect";
label4.Text = "Conection string details";
MakeFieldsReadonly();
}
private String CreateConString(DatabaseAccountToken token)
{
String conStr = String.Format("User ID = '{0}'; Password = {1}; Data Source = {2}", token.UserName, token.Password, token.DataSource);
return conStr;
}
private void cmbTokens_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbTokens.SelectedItem != null)
{
DatabaseAccountToken selectedToken = userDBFullAccount.Tokens.FirstOrDefault(x => x.TokenName == cmbTokens.SelectedItem.ToString());
if (selectedToken != null)
{
this.selectedToken = selectedToken;
PrepareForShowingTokenDetails(selectedToken);
if (userDBFullAccount.Owner)
{
btnDeleteToken.Enabled = true;
btnChangeToken.Enabled = true;
}
else
{
btnChangeToken.Enabled = false;
btnDeleteToken.Enabled = false;
}
}
}
}
