private void lnkTypeDefault_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
 {
     if (DialogResult.Yes == MessageBox.Show("Are you sure you want to insert default values?", "Confirm Insert", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
     {
         foreach (Control ctrl in pnlParameters.Controls)
         {
             if (ctrl is ParameterCtrl)
             {
                 ParameterCtrl pC = (ParameterCtrl)ctrl;
                 pC.ParameterTextValue = TestManager.GetDefaultValueForSqlDbType(pC.DbType);
                 pC.Parameter.Value    = pC.ParameterTextValue;
             }
         }
     }
 }
        private void lnkPasteParameters_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            PasteScriptForm frmScript = new PasteScriptForm();

            if (DialogResult.OK == frmScript.ShowDialog())
            {
                Dictionary <string, string> paramvalues = TestManager.ParseParameterValuesFromScript(this.sprocName, RetrieveParameterNames(), frmScript.ScriptText);
                foreach (Control ctrl in pnlParameters.Controls)
                {
                    if (ctrl is ParameterCtrl)
                    {
                        ParameterCtrl pC = (ParameterCtrl)ctrl;
                        if (paramvalues.ContainsKey(pC.Parameter.Name))
                        {
                            pC.Parameter.Value    = paramvalues[pC.Parameter.Name];
                            pC.ParameterTextValue = paramvalues[pC.Parameter.Name];
                        }
                    }
                }
            }
        }
        private void BindData()
        {
            this.grpTestCase.Text = "Test Case Definition for " + this.sprocName;
            pnlParameters.Controls.Clear();
            pnlOutput.Controls.Clear();

            List <ParameterCtrl> paramCtrls = new List <ParameterCtrl>();

            this.txtCaseName.Text             = this.tCase.Name;
            this.ddExecutionType.SelectedItem = this.tCase.ExecuteType;

            #region Add Parameter controls
            bool  foundMatch;
            Point paramStart = new Point(3, 3);

            if (derivedParameters != null && derivedParameters.Count > 0)
            {
                //Loop through derived parameters and match to test case.
                for (int i = 0; i < derivedParameters.Count; i++)
                {
                    foundMatch = false;
                    if (this.tCase.Parameter != null)
                    {
                        for (int j = 0; j < this.tCase.Parameter.Length; j++)
                        {
                            if (this.tCase.Parameter[j].Name.ToLower() == this.derivedParameters[i].ParameterName.ToLower())
                            {
                                this.tCase.Parameter[j].HasDerivedParameterMatch = true;
                                ParameterCtrl ctrl = new ParameterCtrl(ref this.tCase.Parameter[j]);
                                ctrl.ParameterStatus = ParameterStatus.Matching;
                                ctrl.DbType          = this.derivedParameters[i].SqlDbType;
                                ctrl.DbLength        = this.derivedParameters[i].Size;
                                paramCtrls.Add(ctrl);
                                foundMatch = true;
                                break;
                                // new Int32Converter().ConvertFrom(this.derivedParameters[i].Precision)
                            }
                        }
                    }

                    if (!foundMatch)
                    {
                        ParameterCtrl ctrl = new ParameterCtrl(this.derivedParameters[i].ParameterName);
                        ctrl.ParameterStatus = ParameterStatus.NotInTestCase;
                        ctrl.DbType          = this.derivedParameters[i].SqlDbType;
                        ctrl.DbLength        = this.derivedParameters[i].Size;
                        paramCtrls.Add(ctrl);
                    }
                }

                //Loop through the test case and add any "extra" parameters.
                if (this.tCase.Parameter != null)
                {
                    for (int i = 0; i < this.tCase.Parameter.Length; i++)
                    {
                        if (!this.tCase.Parameter[i].HasDerivedParameterMatch)
                        {
                            ParameterCtrl ctrl = new ParameterCtrl(ref this.tCase.Parameter[i]);
                            ctrl.ParameterStatus = ParameterStatus.NotInDatabase;
                            paramCtrls.Add(ctrl);
                        }
                    }
                }
            }
            else if (this.tCase.Parameter != null)
            {
                //If there are no derived parameters...
                for (int i = 0; i < this.tCase.Parameter.Length; i++)
                {
                    ParameterCtrl ctrl = new ParameterCtrl(ref this.tCase.Parameter[i]);
                    ctrl.ParameterStatus = ParameterStatus.NotInDatabase;
                    paramCtrls.Add(ctrl);
                }
            }


            for (int i = 0; i < paramCtrls.Count; i++)
            {
                paramCtrls[i].Location         = paramStart;
                paramStart.Y                  += paramCtrls[i].Height;
                paramCtrls[i].Width            = pnlParameters.Width - 10;
                paramCtrls[i].RemoveParameter += new EventHandler(SprocTestConfigCtrl_RemoveParameter);
                paramCtrls[i].DataChanged     += new EventHandler(ChildData_DataChanged);
                paramCtrls[i].Anchor           = AnchorStyles.Top | AnchorStyles.Left | AnchorStyles.Right;
                pnlParameters.Controls.Add(paramCtrls[i]);
            }


            #endregion

            if (this.tCase.ExpectedResult != null)
            {
                if (this.tCase.ExpectedResult.RowCountSpecified)
                {
                    this.txtRowCount.Text = this.tCase.ExpectedResult.RowCount.ToString();
                }
                else
                {
                    this.txtRowCount.Text = "";
                }

                if (this.tCase.ExpectedResult.ColumnCountSpecified)
                {
                    this.txtColumnCount.Text = this.tCase.ExpectedResult.ColumnCount.ToString();
                }
                else
                {
                    this.txtColumnCount.Text = "";
                }

                if (this.tCase.ExpectedResult.RowCountOperatorSpecified)
                {
                    this.ddRowCountOperator.SelectedItem = this.tCase.ExpectedResult.RowCountOperator;
                }
                else
                {
                    this.ddRowCountOperator.SelectedItem = RowCountOperator.EqualTo;
                }

                this.ddResultType.SelectedItem = this.tCase.ExpectedResult.ResultType;

                #region Add Output Controls
                List <OutputResultCtrl> outputCtrls = new List <OutputResultCtrl>();
                Point outputStart = new Point(3, 3);
                if (this.tCase.ExpectedResult.OutputResult != null)
                {
                    for (int i = 0; i < this.tCase.ExpectedResult.OutputResult.Length; i++)
                    {
                        OutputResultCtrl ctrl = new OutputResultCtrl(ref this.tCase.ExpectedResult.OutputResult[i]);
                        outputCtrls.Add(ctrl);
                    }
                }
                for (int i = 0; i < outputCtrls.Count; i++)
                {
                    outputCtrls[i].Location            = outputStart;
                    outputStart.Y                     += outputCtrls[i].Height;
                    outputCtrls[i].DataChanged        += new EventHandler(ChildData_DataChanged);
                    outputCtrls[i].RemoveOutputResult += new EventHandler(SprocTestConfigCtrl_RemoveOutputResult);
                    outputCtrls[i].Anchor              = AnchorStyles.Top | AnchorStyles.Left | AnchorStyles.Right;
                    outputCtrls[i].Width               = pnlOutput.Width - 10;
                    pnlOutput.Controls.Add(outputCtrls[i]);
                }
                #endregion
            }
            ddExecutionType_SelectionChangeCommitted(null, EventArgs.Empty);
            ddResultType_SelectionChangeCommitted(null, EventArgs.Empty);
            this.DataChanged = false;
        }