void mPLC_ReadResultsReceived(Object sender, Linc.Communication.NewReadResultsEventArgs e)
{
if (DataManager.Initialized == false)
{
mLog.Write("Error no database connection established. Can't write results to database.");
mPLC.WriteErrorMessagetoPLC("Results not sent to database. Check database connection.");
return;
}
//Send the read results to the database.
mLog.Write("Saving read results to database.");
StringBuilder insert_SQL = new StringBuilder();
insert_SQL.Append("Insert into tpm_results ");
insert_SQL.Append("(serialNumber, stemCode, pressure)");
insert_SQL.Append(" VALUES ");
insert_SQL.Append("(@serialNumber,@stemCode,@pressure)");
MySql.Data.MySqlClient.MySqlCommand cmd = null;
try
{
cmd = DataManager.CreateCommand(insert_SQL.ToString(), System.Data.CommandType.Text);
cmd.Parameters.AddWithValue("@serialNumber", e.results.SerialNumber);
cmd.Parameters.AddWithValue("@stemCode", e.results.StemCode);
cmd.Parameters.AddWithValue("@pressure", e.results.Pressure);
cmd.ExecuteNonQuery();
//Clear the error message if we recevied new results and successfully sent them to the database.
mPLC.WriteErrorMessagetoPLC("");
mLog.Write("New read results successfully sent to database. Serial Number: " + e.results.SerialNumber + "; Stem Code: " + e.results.StemCode + "; Pressure: " + e.results.Pressure + ".");
}
catch (Exception ex)
{
mLog.Write("An exception occurred trying to write to the database. " + ex.Message);
mPLC.WriteErrorMessagetoPLC("Esys TPM service failed to send results to database. Check MySQL service on PC.");
}
finally
{
DataManager.DestroyCommand(cmd);
}
}
void mPLC_MessageReceived(Object sender, Linc.Communication.MessageEventArgs e)
{
//New Messsage was received from the PLC class send it into the logs.
mLog.Write(e.Message);
}