public bool CreateDioev(Dioev dioevToCreate)
{
bool result = false;
MySqlConnection connection;
connection = new MySqlConnection(myConnectionString);
try
{
connection.Open();
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "INSERT INTO dioev(TubeIndex) VALUES(?)";
//cmd.Prepare();
cmd.Parameters.Add("TubeIndex", MySqlDbType.Int32).Value = dioevToCreate.TubeIndex;
cmd.ExecuteNonQuery(); // HERE I GOT AN EXCEPTION IN THIS LINE
result = true;
}
catch (Exception e)
{
result = false;
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
return(result);
}
private void PullData()
{
for (int i = 0; i < 6; ++i)
{
Temperature t = new Temperature();
t.TubeIndex = i + 1;
mTemperRepository.CreateTemperature(t);
Gas g = new Gas();
g.TubeIndex = i + 1;
mMfcRepository.CreateGas(g);
Vacuum v = new Vacuum();
v.TubeIndex = i + 1;
mVacuumRepository.CreateVacuum(v);
Dioev d = new Dioev();
d.TubeIndex = i + 1;
mDioevRepository.CreateDioev(d);
Paddle curPaddle = ProcessService.Instance.GetPaddle(i + 1);
if (prePaddles[i] == null)
{
curPaddle.TubeIndex = i + 1;
mPaddleRepository.CreatePaddle(curPaddle);
prePaddles[i] = curPaddle;
}
else
{
if (prePaddles[i].PaddlePosAct != curPaddle.PaddlePosAct || prePaddles[i].PaddlePosSp != curPaddle.PaddlePosSp || prePaddles[i].PaddleSpeedSp != curPaddle.PaddleSpeedSp)
{
curPaddle.TubeIndex = i + 1;
mPaddleRepository.CreatePaddle(curPaddle);
prePaddles[i] = curPaddle;
}
}
}
Thread.Sleep(1000);
PullData();
}
