public SqlServer(string ip, string displayname, string repository, string username, string password) : base(ip, displayname, repository, username, password)
{
if (SqlGeneratorParameters == null)
{
SqlGeneratorParameters = new SqlGeneratorParameters();
}
}
public SqlServer(string ip, string username, string password) : base(ip, username, password)
{
if (SqlGeneratorParameters == null)
{
SqlGeneratorParameters = new SqlGeneratorParameters();
}
}
private void btn_StartSQLGeneration_Click(object sender, EventArgs e)
{
var failedValidation = false;
var textBoxValidate = new List <TextBox> {
tb_dbName, tb_SQLAmountRows
};
foreach (var textBox in textBoxValidate)
{
if (!string.IsNullOrWhiteSpace(textBox.Text))
{
continue;
}
errorProvider1.SetError(textBox, "Field cannot be empty");
failedValidation = true;
}
if (failedValidation)
{
return;
}
var rowsToInsert = Convert.ToInt32(tb_SQLAmountRows.Text);
var sqlParmsToSerialize = new SqlGeneratorParameters()
{
RowsToInsert = rowsToInsert, DbName = tb_dbName.Text
};
sqlParmsToSerialize.SerizalizeSqlParamsToFile();
if (!SqlGenWrapper.DoNotShowSqlPrerequisites)
{
var prerequisitesForm = new SQLPrerequisites();
prerequisitesForm.Show();
}
// Start SQL Generation for selected servers with specific parameters
if (cb_UseCustomCredsSQL.Checked)
{
SqlGenWrapper.StartSqlGenerator(lv_SQL, ServerWrapper.SqlServersList, tb_dbName.Text, rowsToInsert,
tb_SQLCustomUsername.Text, tb_SQLCustomPassword.Text);
}
else
{
SqlGenWrapper.StartSqlGenerator(lv_SQL, ServerWrapper.SqlServersList, tb_dbName.Text, rowsToInsert);
}
// Update ListView
ServerWrapper.UpdateSqlListView(lv_SQL, lbl_SQLGenerationRunningvalue);
}
private void GetGenParamsFromFileToGui()
{
var ddtParams = DdtParameters.DeserializeDdtParamsFromFile();
if (ddtParams != null)
{
tb_Size.Text = ddtParams.Filesize.ToString();
tb_Compression.Text = ddtParams.Compression.ToString();
tb_Path.Text = ddtParams.Filepath;
tb_Interval.Text = ddtParams.Interval.ToString();
}
var exchangeParams = ExchangeGeneratorParameters.DeserializeExchangeParamsFromFile();
if (exchangeParams != null)
{
var i = 0;
foreach (var item in cb_MailSize.Items)
{
if ((item.ToString()).Contains(_mailSizeDictionary[exchangeParams.MessageSize]))
{
cb_MailSize.SelectedIndex = i;
}
i++;
}
}
var sqlParams = SqlGeneratorParameters.DeserializeSqlParamsFromFile();
if (sqlParams == null)
{
return;
}
tb_dbName.Text = sqlParams.DbName;
tb_SQLAmountRows.Text = sqlParams.RowsToInsert.ToString();
}
private void btn_StartSQLGeneration_Click(object sender, EventArgs e)
{
var failedValidation = false;
var textBoxValidate = new List<TextBox> { tb_dbName, tb_SQLAmountRows };
foreach (var textBox in textBoxValidate)
{
if (!string.IsNullOrWhiteSpace(textBox.Text)) continue;
errorProvider1.SetError(textBox, "Field cannot be empty");
failedValidation = true;
}
if (failedValidation)
return;
var rowsToInsert = Convert.ToInt32(tb_SQLAmountRows.Text);
var sqlParmsToSerialize = new SqlGeneratorParameters() { RowsToInsert = rowsToInsert, DbName = tb_dbName.Text };
sqlParmsToSerialize.SerizalizeSqlParamsToFile();
if (!SqlGenWrapper.DoNotShowSqlPrerequisites)
{
var prerequisitesForm = new SQLPrerequisites();
prerequisitesForm.Show();
}
// Start SQL Generation for selected servers with specific parameters
if (cb_UseCustomCredsSQL.Checked)
{
SqlGenWrapper.StartSqlGenerator(lv_SQL, ServerWrapper.SqlServersList, tb_dbName.Text, rowsToInsert,
tb_SQLCustomUsername.Text, tb_SQLCustomPassword.Text);
}
else
{
SqlGenWrapper.StartSqlGenerator(lv_SQL, ServerWrapper.SqlServersList, tb_dbName.Text, rowsToInsert);
}
// Update ListView
ServerWrapper.UpdateSqlListView(lv_SQL, lbl_SQLGenerationRunningvalue);
}
public SqlServer(string ip, string username, string password)
: base(ip, username, password)
{
if (SqlGeneratorParameters == null)
SqlGeneratorParameters = new SqlGeneratorParameters();
}
public SqlServer(string ip, string displayname, string repository, string username, string password)
: base(ip, displayname, repository, username, password)
{
if (SqlGeneratorParameters == null)
SqlGeneratorParameters = new SqlGeneratorParameters();
}
