private void InitializeValues()
{
this.comboBoxDatabase.SelectedIndex = this.GetDatabaseTypeIdx(UIConfig.Get(UIConfig.SQL_DIALECT, "mssql"));
this.comboBoxAuthType.SelectedIndex = this.GetAuthTypeIdx(UIConfig.Get(UIConfig.AUTH_TYPE, "sql_auth"));
this.textBoxServerName.Text = UIConfig.Get(UIConfig.SERVER_NAME, "");
this.textBoxPort.Text = UIConfig.Get(UIConfig.SERVER_PORT, "");
this.textBoxLoginName.Text = UIConfig.Get(UIConfig.LOGIN_NAME, "");
this.textBoxLoginPassword.Text = UIConfig.Get(UIConfig.LOGIN_PASSWORD, "");
this.textBoxUserName.Text = UIConfig.Get(UIConfig.DATA_SET_NAME, "My Data Set Name");
this.textBoxDatabaseName.Text = UIConfig.Get(UIConfig.DATABASE_NAME, "master");
this.textBoxKey.Text = UIConfig.Get(UIConfig.SQLDEP_KEY, "");
this.textBoxDefaultDatabase.Text = UIConfig.Get(UIConfig.FS_DEFAULT_DB, "");
this.textBoxDefautSchema.Text = UIConfig.Get(UIConfig.FS_DEFAULT_SCHEMA, "");
this.textBoxRootDirectory.Text = UIConfig.Get(UIConfig.FS_PATH, "");
this.textBoxFileMask.Text = UIConfig.Get(UIConfig.FS_MASK, "*.sql");
this.textBoxWarehouse.Text = UIConfig.Get(UIConfig.SNOWFLAKE_WAREHOUSE, "");
this.TextBoxAccount.Text = UIConfig.Get(UIConfig.SNOWFLAKE_ACCOUNT, "");
this.textBoxRole.Text = UIConfig.Get(UIConfig.SNOWFLAKE_ROLE, "");
this.buttonRun.Enabled = false;
this.buttonCreateAndSendFiles.Enabled = false;
this.InitializeDSNNames(string.Empty);
this.InitializeDrivers(UIConfig.Get(UIConfig.DRIVER_NAME, ""));
this.EnableAuthSettings();
CheckForIllegalCrossThreadCalls = false;
}
private void SaveDialogSettings()
{
DBExecutor.UseDriver useDriverType;
UIConfig.Set(UIConfig.AUTH_TYPE, this.GetAuthTypeName(this.comboBoxAuthType.SelectedIndex));
UIConfig.Set(UIConfig.SQL_DIALECT, this.GetDatabaseTypeName(this.comboBoxDatabase.SelectedIndex));
UIConfig.Set(UIConfig.DATA_SET_NAME, this.textBoxUserName.Text.ToString());
UIConfig.Set(UIConfig.SQLDEP_KEY, this.textBoxKey.Text.ToString());
UIConfig.Set(UIConfig.SERVER_NAME, this.textBoxServerName.Text.ToString());
UIConfig.Set(UIConfig.SERVER_PORT, this.textBoxPort.Text.ToString());
UIConfig.Set(UIConfig.LOGIN_NAME, this.textBoxLoginName.Text.ToString());
UIConfig.Set(UIConfig.LOGIN_PASSWORD, this.textBoxLoginPassword.Text.ToString());
UIConfig.Set(UIConfig.DATABASE_NAME, this.textBoxDatabaseName.Text.ToString());
UIConfig.Set(UIConfig.DRIVER_NAME, this.GetDriverName(out useDriverType));
}
private void comboBoxDatabase_SelectedIndexChanged(object sender, EventArgs e)
{
this.InitializeDSNNames(string.Empty);
this.InitializeDrivers(UIConfig.Get(UIConfig.DRIVER_NAME, ""));
this.buttonRun.Enabled = false;
this.buttonCreateAndSendFiles.Enabled = false;
switch (GetDatabaseTypeName(this.comboBoxDatabase.SelectedIndex))
{
case "snowflake":
enableSnowflakeFields();
break;
default:
showDefaultFields();
break;
}
}
private void InitializeValues()
{
this.comboBoxDatabase.SelectedIndex = this.GetDatabaseTypeIdx(UIConfig.Get(UIConfig.SQL_DIALECT, "mssql"));
this.comboBoxAuthType.SelectedIndex = this.GetAuthTypeIdx(UIConfig.Get(UIConfig.AUTH_TYPE, "sql_auth"));
this.textBoxServerName.Text = UIConfig.Get(UIConfig.SERVER_NAME, "");
this.textBoxPort.Text = UIConfig.Get(UIConfig.SERVER_PORT, "");
this.textBoxLoginName.Text = UIConfig.Get(UIConfig.LOGIN_NAME, "");
this.textBoxLoginPassword.Text = UIConfig.Get(UIConfig.LOGIN_PASSWORD, "");
this.textBoxUserName.Text = UIConfig.Get(UIConfig.DATA_SET_NAME, "My Data Set Name");
this.textBoxDatabaseName.Text = UIConfig.Get(UIConfig.DATABASE_NAME, "master");
this.textBoxKey.Text = UIConfig.Get(UIConfig.SQLDEP_KEY, "");
this.buttonRun.Enabled = false;
this.InitializeDSNNames(string.Empty);
this.InitializeDrivers(UIConfig.Get(UIConfig.DRIVER_NAME, ""));
this.EnableAuthSettings();
//
CheckForIllegalCrossThreadCalls = false;
}
private void SaveDialogSettings()
{
DBExecutor.UseDriver useDriverType;
UIConfig.Set(UIConfig.AUTH_TYPE, this.GetAuthTypeName(this.comboBoxAuthType.SelectedIndex));
UIConfig.Set(UIConfig.SQL_DIALECT, this.GetDatabaseTypeName(this.comboBoxDatabase.SelectedIndex));
UIConfig.Set(UIConfig.DATA_SET_NAME, this.textBoxUserName.Text);
UIConfig.Set(UIConfig.SQLDEP_KEY, this.textBoxKey.Text);
UIConfig.Set(UIConfig.SERVER_NAME, this.textBoxServerName.Text);
UIConfig.Set(UIConfig.SERVER_PORT, this.textBoxPort.Text);
UIConfig.Set(UIConfig.LOGIN_NAME, this.textBoxLoginName.Text);
UIConfig.Set(UIConfig.LOGIN_PASSWORD, this.textBoxLoginPassword.Text);
UIConfig.Set(UIConfig.DATABASE_NAME, this.textBoxDatabaseName.Text);
UIConfig.Set(UIConfig.DRIVER_NAME, this.GetDriverName(out useDriverType));
UIConfig.Set(UIConfig.FS_PATH, this.textBoxRootDirectory.Text);
UIConfig.Set(UIConfig.FS_MASK, this.textBoxFileMask.Text);
UIConfig.Set(UIConfig.FS_DEFAULT_SCHEMA, this.textBoxDefautSchema.Text);
UIConfig.Set(UIConfig.FS_DEFAULT_DB, this.textBoxDefaultDatabase.Text);
UIConfig.Set(UIConfig.SNOWFLAKE_ACCOUNT, this.TextBoxAccount.Text);
UIConfig.Set(UIConfig.SNOWFLAKE_ROLE, this.textBoxRole.Text);
UIConfig.Set(UIConfig.SNOWFLAKE_WAREHOUSE, this.textBoxWarehouse.Text);
}
private void comboBoxDatabase_SelectedIndexChanged(object sender, EventArgs e)
{
this.InitializeDSNNames(string.Empty);
this.InitializeDrivers(UIConfig.Get(UIConfig.DRIVER_NAME, ""));
}
private void comboBoxDSNName_SelectedIndexChanged(object sender, EventArgs e)
{
this.InitializeDrivers(UIConfig.Get(UIConfig.DRIVER_NAME, ""));
this.buttonRun.Enabled = false;
this.buttonCreateAndSendFiles.Enabled = false;
}