/// <summary>
/// Generates sql statements based upon the generator type selected and the tableinfo provided
/// </summary>
private void GenerateSqlStatements()
{
// clear the string member
m_sSqlStatementText = string.Empty;
// create an array of all the columns that are to be included
ArrayList aryColumns = new ArrayList();
for (int i = 0; i < chklstIncludeFields.CheckedItems.Count; i++)
{
aryColumns.Add(chklstIncludeFields.CheckedItems[i].ToString());
}
// if no columns included, return with a msg
if (aryColumns.Count <= 0)
{
MessageBox.Show("No columns selected! Please check/select some columns to include!");
return;
}
string sTargetTableName = txtTargetTable.Text.Trim();
if (sTargetTableName == string.Empty)
{
MessageBox.Show("No valid target table name! Please enter a table name to be used in the SQL statements!");
return;
}
// generate the sql by type
if (cmbSqlType.SelectedIndex == (int)STATEMENT_TYPES.INSERT)
{
m_sSqlStatementText = SqlScriptGenerator.GenerateSqlInserts(aryColumns, m_TableInfo, sTargetTableName);
}
else if (cmbSqlType.SelectedIndex == (int)STATEMENT_TYPES.UPDATE)
{
// get an array of all the active table columns
ArrayList aryWhereColumns = new ArrayList();
for (int i = 0; i < chklstIncludeFields.Items.Count; i++)
{
aryWhereColumns.Add(chklstIncludeFields.GetItemText(chklstIncludeFields.Items[i]));
}
// create dlg and pass in array of columns
SelectMultipleItems dlg = new SelectMultipleItems();
dlg.Text = "Select WHERE Columns";
dlg.Description = "Select WHERE-Clause Columns for UPDATE SQLs:";
dlg.Initialize(aryWhereColumns, string.Empty, false);
// user cancelled, so exit
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
aryWhereColumns.Clear();
aryWhereColumns = dlg.UserSelectedItems;
m_sSqlStatementText = SqlScriptGenerator.GenerateSqlUpdates(aryColumns, aryWhereColumns, m_TableInfo, sTargetTableName);
}
else if (cmbSqlType.SelectedIndex == (int)STATEMENT_TYPES.DELETE)
{
m_sSqlStatementText = SqlScriptGenerator.GenerateSqlDeletes(aryColumns, m_TableInfo, sTargetTableName);
}
}
/// <summary>
/// Generates sql statements based upon the generator type selected and the tableinfo provided
/// </summary>
private void GenerateSqlStatements()
{
// clear the string member
m_sSqlStatementText = string.Empty;
// create an array of all the columns that are to be included
ArrayList aryColumns = new ArrayList();
for (int i = 0; i < chklstIncludeFields.CheckedItems.Count; i++)
{
aryColumns.Add(chklstIncludeFields.CheckedItems[i].ToString());
}
// if no columns included, return with a msg
if(aryColumns.Count <= 0)
{
MessageBox.Show("No columns selected! Please check/select some columns to include!");
return;
}
string sTargetTableName = txtTargetTable.Text.Trim();
if(sTargetTableName == string.Empty)
{
MessageBox.Show("No valid target table name! Please enter a table name to be used in the SQL statements!");
return;
}
// generate the sql by type
if (cmbSqlType.SelectedIndex == (int)STATEMENT_TYPES.INSERT)
{
m_sSqlStatementText = SqlScriptGenerator.GenerateSqlInserts(aryColumns, m_TableInfo, sTargetTableName);
}
else if (cmbSqlType.SelectedIndex == (int)STATEMENT_TYPES.UPDATE)
{
// get an array of all the active table columns
ArrayList aryWhereColumns = new ArrayList();
for (int i = 0; i < chklstIncludeFields.Items.Count; i++)
{
aryWhereColumns.Add(chklstIncludeFields.GetItemText(chklstIncludeFields.Items[i]));
}
// create dlg and pass in array of columns
SelectMultipleItems dlg = new SelectMultipleItems();
dlg.Text = "Select WHERE Columns";
dlg.Description = "Select WHERE-Clause Columns for UPDATE SQLs:";
dlg.Initialize(aryWhereColumns, string.Empty, false);
// user cancelled, so exit
if (dlg.ShowDialog() != DialogResult.OK)
{
return;
}
aryWhereColumns.Clear();
aryWhereColumns = dlg.UserSelectedItems;
m_sSqlStatementText = SqlScriptGenerator.GenerateSqlUpdates(aryColumns, aryWhereColumns, m_TableInfo, sTargetTableName);
}
else if (cmbSqlType.SelectedIndex == (int)STATEMENT_TYPES.DELETE)
{
m_sSqlStatementText = SqlScriptGenerator.GenerateSqlDeletes(aryColumns, m_TableInfo, sTargetTableName);
}
}