private void removeSpecifier()
{
if (specifiers.Count == 0)
{
return;
}
SingleTableSpecifierPanel panel = specifiers[specifiers.Count - 1];
OracleTableViewForm form = oracleForms
.Where(x => x.Name == string.Concat("oracleForm", panel.SpecifierId))
.FirstOrDefault();
if (form != null && form.Visible)
{
form.Hide();
}
ComboBox cb = panel.Controls.Cast <Control>()
.Where(y => y is ComboBox)
.First() as ComboBox;
this.Controls.Remove(panel);
specifiers.Remove(panel);
comboBoxes.Remove(cb);
updateControls(oracleHandler.IsConnectionUp());
}
private void displayControl(SingleTableSpecifierPanel panel)
{
if (string.IsNullOrWhiteSpace(panel.TableName)) //not found
{
return;
}
OracleTableViewForm form = oracleForms
.Where(x => x.Name == string.Concat("oracleForm", panel.SpecifierId))
.FirstOrDefault();
if (!panel.ViewChecked)
{
if (form != null) //while unchecked, only needs to do something when it is found
{
form.Hide();
}
return;
}
if (form == null) //form does not exist, create a new form
{
form = new OracleTableViewForm();
form.Name = string.Concat("oracleForm", panel.SpecifierId);
form.SetOracleHandler(oracleHandler);
form.FormClosing += form_FormClosing;
oracleForms.Add(form);
}
form.Text = string.Concat(form.OriginalTitle, " [", panel.SpecifierId, "] ", panel.TableName);
form.DisplayTableResult(panel.TableName, panel.ColumnsClause, panel.WhereClause, panel.MaxRows, panel.IndexAdded);
form.Show();
}
void comboBox_SelectedIndexChanged(object sender, EventArgs e) //The only thing which would cause the include and exclude to be reset
{
SingleTableSpecifierPanel panel = (sender as Control).Parent as SingleTableSpecifierPanel;
panel.ResetColumns();
panelControlDisplayHandler(sender as Control);
}
private void addSpecifier()
{
int tableNo = specifiers.Count;
SingleTableSpecifierPanel panel = new SingleTableSpecifierPanel();
panel.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
panel.IndexAdded = false;
panel.Location = new System.Drawing.Point(0, 36 + tableNo * 34);
panel.MaxRows = 200;
panel.Name = string.Concat("singleTableSpecifierPanel", tableNo);
panel.Size = new System.Drawing.Size(819, 35);
panel.SpecifierId = specifiers.Count + 1;
panel.TabIndex = 34;
panel.ViewChecked = false;
panel.WhereClause = "";
specifiers.Add(panel);
ComboBox cb = panel.Controls.Cast <Control>()
.Where(y => y is ComboBox)
.First() as ComboBox;
cb.SelectedIndexChanged += comboBox_SelectedIndexChanged;
if (sources != null && sources.Count > 0)
{
cb.Items.AddRange(sources.ToArray());
cb.SelectedIndex = 0;
}
comboBoxes.Add(cb);
CheckBox chbView = panel.Controls.Cast <Control>()
.Where(y => y is CheckBox && y.Name.StartsWith("checkBoxView"))
.First() as CheckBox;
chbView.CheckedChanged += checkBox_CheckedChanged;
CheckBox chbAddIndex = panel.Controls.Cast <Control>()
.Where(y => y is CheckBox && y.Name.StartsWith("checkBoxAddIndex"))
.First() as CheckBox;
chbAddIndex.CheckedChanged += checkBox_CheckedChanged;
LinkLabel llRefresh = panel.Controls.Cast <Control>()
.Where(y => y is LinkLabel && y.Name.StartsWith("linkLabelRefresh"))
.First() as LinkLabel;
llRefresh.LinkClicked += linkLabelRefresh_LinkClicked;
LinkLabel llFrom = panel.Controls.Cast <Control>()
.Where(y => y is LinkLabel && y.Name.StartsWith("linkLabelFrom"))
.First() as LinkLabel;
llFrom.LinkClicked += linkLabelFrom_LinkClicked;
this.Controls.Add(panel);
updateControls(oracleHandler.IsConnectionUp());
}
void form_FormClosing(object sender, FormClosingEventArgs e)
{
Form form = sender as Form;
form.Hide();
e.Cancel = true;
string numstr = form.Name.Replace("oracleForm", string.Empty);
SingleTableSpecifierPanel panel = specifiers[Convert.ToInt32(numstr) - 1];
panel.ViewChecked = false;
}
void linkLabelFrom_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
SingleTableSpecifierPanel panel = (sender as Control).Parent as SingleTableSpecifierPanel;
if (panel.IncludeCount <= 0) //no item in the include, put everything!
{
panel.SetColumns(oracleHandler.GetAllColumnNames(panel.TableName), null);
}
OracleFromForm form = new OracleFromForm(panel.IncludeColumns, panel.ExcludeColumns, string.Concat(" [", panel.SpecifierId, "] ", panel.TableName));
if (form.ShowDialog() == System.Windows.Forms.DialogResult.OK) //Do something
{
panel.SetColumns(form.IncludedColumns, form.ExcludedColumns); //record the new included and excluded
panelControlDisplayHandler(sender as Control); //update the display control (if there is any)
}
}
