private void TestConnection(object sender, EventArgs e, IfrmCommandEditor editor, ICommandControls commandControls)
{
try
{
var engine = (IAutomationEngineInstance)commandControls.CreateAutomationEngineInstance(editor.ScriptEngineContext);
var oleDBConnection = CreateConnection(engine);
oleDBConnection.Open();
oleDBConnection.Close();
MessageBox.Show("Connection Successful", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show($"Connection Failed: {ex}", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void PassParametersCheckbox_CheckedChanged(object sender, EventArgs e, IfrmCommandEditor editor, ICommandControls commandControls, bool isMouseEnter = false)
{
var assignArgCheckBox = (CheckBox)sender;
_assignmentsGridViewHelper.Visible = assignArgCheckBox.Checked;
//load arguments if selected and file exists
if (assignArgCheckBox.Checked)
{
var currentScriptEngine = commandControls.CreateAutomationEngineInstance(null);
currentScriptEngine.AutomationEngineContext.Arguments.AddRange(editor.ScriptEngineContext.Arguments);
var startFile = v_TaskPath;
if (startFile.Contains("{ProjectPath}"))
{
startFile = startFile.Replace("{ProjectPath}", editor.ScriptEngineContext.ProjectPath);
}
startFile = startFile.ConvertUserVariableToString(currentScriptEngine);
if (!isMouseEnter && File.Exists(startFile))
{
_assignmentsGridViewHelper.DataSource = v_ArgumentAssignments;
DataTable vArgumentAssignmentsCopy = v_ArgumentAssignments.Copy();
v_ArgumentAssignments.Clear();
JObject scriptObject = JObject.Parse(File.ReadAllText(startFile));
var arguments = scriptObject["Arguments"].ToObject <List <ScriptArgument> >();
foreach (var argument in arguments)
{
if (argument.ArgumentName == "ProjectPath")
{
continue;
}
DataRow foundArguments = vArgumentAssignmentsCopy.Select("ArgumentName = '" + "{" + argument.ArgumentName + "}" + "'").FirstOrDefault();
if (foundArguments != null)
{
var foundArgumentValue = foundArguments[2];
v_ArgumentAssignments.Rows.Add("{" + argument.ArgumentName + "}", argument.ArgumentType, foundArgumentValue, argument.Direction.ToString());
}
else
{
v_ArgumentAssignments.Rows.Add("{" + argument.ArgumentName + "}", argument.ArgumentType, argument.ArgumentValue, argument.Direction.ToString());
}
}
}
for (int i = 0; i < _assignmentsGridViewHelper.Rows.Count; i++)
{
DataGridViewComboBoxCell typeComboBox = new DataGridViewComboBoxCell();
typeComboBox.Items.Add(v_ArgumentAssignments.Rows[i].ItemArray[1]);
typeComboBox.Tag = v_ArgumentAssignments.Rows[i].ItemArray[1];
_assignmentsGridViewHelper.Rows[i].Cells[1] = typeComboBox;
_assignmentsGridViewHelper.Rows[i].Cells[1].ReadOnly = true;
DataGridViewComboBoxCell returnComboBox = new DataGridViewComboBoxCell();
returnComboBox.Items.Add("In");
returnComboBox.Items.Add("Out");
returnComboBox.Items.Add("InOut");
_assignmentsGridViewHelper.Rows[i].Cells[3] = returnComboBox;
_assignmentsGridViewHelper.Rows[i].Cells[3].ReadOnly = true;
}
}
else if (!assignArgCheckBox.Checked)
{
v_ArgumentAssignments.Clear();
}
}