private void PassParametersCheckbox_CheckedChanged(object sender, EventArgs e)
{
Engine.AutomationEngineInstance currentScriptEngine = new Engine.AutomationEngineInstance();
var startFile = v_taskPath.ConvertToUserVariable(currentScriptEngine);
var Sender = (CheckBox)sender;
AssignmentsGridViewHelper.Visible = Sender.Checked;
//load variables if selected and file exists
if ((Sender.Checked) && (System.IO.File.Exists(startFile)))
{
Script.Script deserializedScript = Core.Script.Script.DeserializeFile(startFile);
foreach (var variable in deserializedScript.Variables)
{
DataRow[] foundVariables = v_VariableAssignments.Select("VariableName = '" + variable.VariableName + "'");
if (foundVariables.Length == 0)
{
v_VariableAssignments.Rows.Add(variable.VariableName, variable.VariableValue);
}
}
AssignmentsGridViewHelper.DataSource = v_VariableAssignments;
for (int i = 0; i < AssignmentsGridViewHelper.Rows.Count - 1; i++)
{
DataGridViewComboBoxCell returnComboBox = new DataGridViewComboBoxCell();
returnComboBox.Items.Add("Yes");
returnComboBox.Items.Add("No");
AssignmentsGridViewHelper.Rows[i].Cells[2] = returnComboBox;
}
}
}
private void TestConnection(object sender, EventArgs e)
{
try
{
var engine = new Engine.AutomationEngineInstance();
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.ToString()}", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
