Exemplo n.º 1
0
        private void LoadSchemaControl_Click(object sender, EventArgs e)
        {
            frmVariableSelector selectionForm = new frmVariableSelector();

            selectionForm.Text           = "Load Schema";
            selectionForm.lblHeader.Text = "Select a DataTable from the list";
            foreach (var item in _dataTableCreationCommands)
            {
                selectionForm.lstVariables.Items.Add(item.v_OutputUserVariableName);
            }

            var result = selectionForm.ShowDialog();

            if (result == DialogResult.OK)
            {
                var tableName = selectionForm.lstVariables.SelectedItem.ToString();
                var schema    = _dataTableCreationCommands.Where(f => f.v_OutputUserVariableName == tableName).FirstOrDefault();

                v_DataRowDataTable.Rows.Clear();

                foreach (DataRow rw in schema.v_ColumnNameDataTable.Rows)
                {
                    v_DataRowDataTable.Rows.Add(rw.Field <string>("Column Name"), "");
                }
            }
        }
Exemplo n.º 2
0
        public void ShowVariableSelector(object sender, EventArgs e)
        {
            //create variable selector form
            frmVariableSelector newVariableSelector = new frmVariableSelector();

            //get copy of user variables and append system variables, then load to combobox
            var variableList = _currentEditor.ScriptVariables.Select(f => f.VariableName).ToList();

            variableList.AddRange(Common.GenerateSystemVariables().Select(f => f.VariableName));
            newVariableSelector.lstVariables.Items.AddRange(variableList.ToArray());

            //if user pressed "OK"
            if (newVariableSelector.ShowDialog() == DialogResult.OK)
            {
                //ensure that a variable was actually selected
                if (newVariableSelector.lstVariables.SelectedItem == null)
                {
                    //return out as nothing was selected
                    MessageBox.Show("There were no variables selected!");
                    return;
                }

                //grab the referenced input assigned to the 'insert variable' button instance
                CommandItemControl inputBox = (CommandItemControl)sender;
                //currently variable insertion is only available for simply textboxes

                //load settings
                var settings = new ApplicationSettings().GetOrCreateApplicationSettings();

                if (inputBox.Tag is TextBox)
                {
                    TextBox targetTextbox = (TextBox)inputBox.Tag;
                    //concat variable name with brackets [vVariable] as engine searches for the same
                    targetTextbox.Text = targetTextbox.Text.Insert(targetTextbox.SelectionStart, string.Concat("{",
                                                                                                               newVariableSelector.lstVariables.SelectedItem.ToString(), "}"));
                }
                else if (inputBox.Tag is ComboBox)
                {
                    ComboBox targetCombobox = (ComboBox)inputBox.Tag;
                    //concat variable name with brackets [vVariable] as engine searches for the same
                    targetCombobox.Text = targetCombobox.Text.Insert(targetCombobox.SelectionStart, string.Concat("{",
                                                                                                                  newVariableSelector.lstVariables.SelectedItem.ToString(), "}"));
                }
                else if (inputBox.Tag is DataGridView)
                {
                    DataGridView targetDGV = (DataGridView)inputBox.Tag;

                    if (targetDGV.SelectedCells.Count == 0)
                    {
                        MessageBox.Show("Please make sure you have selected an action and selected a cell before attempting" +
                                        " to insert a variable!", "No Cell Found", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }

                    if (targetDGV.SelectedCells[0].ColumnIndex == 0)
                    {
                        MessageBox.Show("Invalid Cell Selected!", "Invalid Cell Selected", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                        return;
                    }

                    targetDGV.SelectedCells[0].Value = targetDGV.SelectedCells[0].Value +
                                                       string.Concat("{", newVariableSelector.lstVariables.SelectedItem.ToString(), "}");

                    //TODO - Insert variables at cursor position instead of at the end of a cell
                    //targetDGV.CurrentCell = targetDGV.SelectedCells[0];
                    //targetDGV.BeginEdit(false);
                    //TextBox editor = (TextBox)targetDGV.EditingControl;
                    //editor.Text = editor.Text.Insert(editor.SelectionStart, string.Concat("{",
                    //    newVariableSelector.lstVariables.SelectedItem.ToString(), "}"));
                }
            }
        }