/// <summary>
/// Called when Execute button is clicked
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ButtonExecuteClick(object sender, EventArgs e)
{
// Checks if any program has been selected
if (comboBoxPrograms.SelectedIndex == -1)
{
// Show no program selected error
MessageBox.Show("No program selected", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
// Get reference of selected program
selectedProgram = (ProgramEntry)comboBoxPrograms.SelectedItem;
}
// Check if camera 1 is connected
if (mainForm.hvAcqHandleCamera1 != null)
{
try
{
// Change trigger source to software
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera1, "TriggerSource", "Software");
// Do a software trigger
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera1, "TriggerSoftware", 1);
// Change back trigger source to line 2
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera1, "TriggerSource", "Line2");
}
catch (Exception ex)
{
Console.WriteLine("Trigger camera 1: " + ex.Message);
}
}
// Check if camera 2 is connected
if (mainForm.hvAcqHandleCamera2 != null)
{
try
{
// Change trigger source to software
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera2, "TriggerSource", "Software");
// Do a software trigger
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera2, "TriggerSoftware", 1);
// Change back trigger source to line 2
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera2, "TriggerSource", "Line2");
}
catch (Exception ex)
{
Console.WriteLine("Trigger camera 2: " + ex.Message);
}
}
}
private void ComboBoxProgramsSelectedIndexChanged(object sender, EventArgs e)
{
if (comboBoxPrograms.SelectedIndex != -1)
{
ProgramEntry selectedProgram = (ProgramEntry)comboBoxPrograms.SelectedItem;
this.selectedProgram = selectedProgram;
labelDescription.Text = selectedProgram.Description;
}
}
private void ButtonExecuteClick(object sender, EventArgs e)
{
if (comboBoxPrograms.SelectedIndex == -1)
{
MessageBox.Show("No program selected", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
selectedProgram = (ProgramEntry)comboBoxPrograms.SelectedItem;
}
if (mainForm.hvAcqHandleCamera1 != null)
{
try
{
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera1, "TriggerSource", "Software");
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera1, "TriggerSoftware", 1);
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera1, "TriggerSource", "Line2");
}
catch (Exception ex)
{
Console.WriteLine("Trigger camera 1: " + ex.Message);
}
}
if (mainForm.hvAcqHandleCamera2 != null)
{
try
{
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera2, "TriggerSource", "Software");
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera2, "TriggerSoftware", 1);
HOperatorSet.SetFramegrabberParam(mainForm.hvAcqHandleCamera2, "TriggerSource", "Line2");
}
catch (Exception ex)
{
Console.WriteLine("Trigger camera 2: " + ex.Message);
}
}
}
private void ButtonOkClick(object sender, EventArgs e)
{
string programName = textBoxProgramName.Text.Replace(' ', '_');
if (programName == string.Empty)
{
MessageBox.Show("Program name has not been entered", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
ProgramEntry programToCheck = SqlCommunication.CheckProgram(programName);
if (programToCheck.Name == null)
{
manageProgramsForm.AddProgramToComboBox(programName);
Close();
}
else
{
MessageBox.Show("Program already exists", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public ProgramEntry CheckProgram()
{
ProgramEntry programEntry = SqlCommunication.CheckProgram(scanValue);
return(programEntry);
}
public static ProgramEntry CheckProgram(string programName)
{
ProgramEntry programEntry = new ProgramEntry();
string server = "localhost";
string dbName = "hirschmann";
string dbUser = "******";
string dbPassword = "******";
string connectionString = $"datasource = {server}; database = {dbName}; username = {dbUser}; password = {dbPassword}";
string dbQuery = $"SELECT * FROM programs WHERE name = '{programName}'";
// Create connection
MySqlConnection connection = new MySqlConnection(connectionString);
try
{
// Open connection
connection.Open();
// Create command
MySqlCommand cmd = new MySqlCommand(dbQuery, connection);
// Create a data reader and execute the command
MySqlDataReader dataReader = cmd.ExecuteReader();
//Read the data and store them in the list
while (dataReader.Read())
{
programEntry.Name = dataReader["name"].ToString();
programEntry.TriggerOffset = Convert.ToInt32(dataReader["triggerOffset"]);
programEntry.StartWastingOffset = Convert.ToInt32(dataReader["startWastingOffset"]);
programEntry.WasteOffset = Convert.ToInt32(dataReader["wasteOffset"]);
programEntry.ColorCamera1 = dataReader["colorCamera1"].ToString();
programEntry.ColorCamera2 = dataReader["colorCamera2"].ToString();
programEntry.Camera1 = Convert.ToBoolean(dataReader["camera1"]);
programEntry.Camera2 = Convert.ToBoolean(dataReader["camera2"]);
programEntry.LogosCamera1 = Convert.ToBoolean(dataReader["logosCamera1"]);
programEntry.LogosCamera2 = Convert.ToBoolean(dataReader["logosCamera2"]);
programEntry.NumberOfLogosCamera1 = Convert.ToInt32(dataReader["numberOfLogosCamera1"]);
programEntry.NumberOfLogosCamera2 = Convert.ToInt32(dataReader["numberOfLogosCamera2"]);
programEntry.Logo1Camera1SaveLocation = dataReader["logo1Camera1SaveLocation"].ToString();
programEntry.Logo2Camera1SaveLocation = dataReader["logo2Camera1SaveLocation"].ToString();
programEntry.Logo1Camera2SaveLocation = dataReader["logo1Camera2SaveLocation"].ToString();
programEntry.Logo2Camera2SaveLocation = dataReader["logo2Camera2SaveLocation"].ToString();
programEntry.ShapesCamera1 = Convert.ToBoolean(dataReader["shapesCamera1"]);
programEntry.ShapesCamera2 = Convert.ToBoolean(dataReader["shapesCamera2"]);
programEntry.ShapeTypeCamera1 = dataReader["shapeTypeCamera1"].ToString();
programEntry.ShapeTypeCamera2 = dataReader["shapeTypeCamera2"].ToString();
programEntry.TextToDetectCamera1 = dataReader["textToDetectCamera1"].ToString();
programEntry.TextToDetectCamera2 = dataReader["textToDetectCamera2"].ToString();
}
// Close data reader
dataReader.Close();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message, "SQL ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
// Close connection
connection.Close();
return(programEntry);
}
