Example #1
0
        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());
        }
Example #2
0
        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();
        }