public void portDataOperation(string portReceivedDate)
{
string[] portDataArr = portReceivedDate.Split(',');
int portDateArrLenght = portDataArr.Length;
classes.PortDataDetails portDetailsObj = new classes.PortDataDetails();
if (portDateArrLenght >= 17)
{
portDetailsObj.partNumber = portDataArr[0];
portDetailsObj.revisionNumber = portDataArr[1];
portDetailsObj.dateTime = portDataArr[2] + ' ' + portDataArr[3];
portDetailsObj.testResult = portDataArr[4];
portDetailsObj.testingMode = portDataArr[5];
portDetailsObj.passCount = portDataArr[6];
portDetailsObj.failCount = portDataArr[7];
portDetailsObj.failTypePoints = portDataArr[8];
portDetailsObj.cutterCount = portDataArr[9];
portDetailsObj.labelSerialNumber = portDataArr[10];
portDetailsObj.printedBarCode = portDataArr[11];
portDetailsObj.operatorCode = portDataArr[12];
portDetailsObj.shift = portDataArr[13];
portDetailsObj.lotCount = portDataArr[14];
portDetailsObj.lotQuantity = portDataArr[15];
portDetailsObj.customField = portDataArr[16];
//MessageBox.Show(portDetailsObj.ToString());
insertPortData(portDetailsObj);
}
//MessageBox.Show(portDateArrLenght.ToString());
}
public void insertPortData(classes.PortDataDetails portDetObj)
{
const string insertQuerystr = "insert into Face_Connect(" +
"part_number, " +
"date_time, " +
"test_result, " +
"testing_mode, " +
"pass_count, " +
"fail_count, " +
"fail_type_points, " +
"cutter_count, " +
"label_serial_number, " +
"printed_barcode, " +
"operator_code, " +
"shift, " +
"lot_count, " +
"lot_quantity, " +
"custom_field)" +
"values(" +
"@partNumber, " +
"@dateTime, " +
"@testResult, " +
"@testingMode, " +
"@passCount, " +
"@failCount, " +
"@failTypePoints, " +
"@cutterCount, " +
"@labelSerialNumber, " +
"@printedBarCode, " +
"@operatorCode, " +
"@shift, " +
"@lotCount, " +
"@lotQuantity, " +
"@customField)";
cmd = new OleDbCommand(insertQuerystr, con);
cmd.Parameters.AddWithValue("@partNumber", portDetObj.partNumber);
cmd.Parameters.AddWithValue("@dateTime", portDetObj.dateTime);
cmd.Parameters.AddWithValue("@testResult", portDetObj.testResult);
cmd.Parameters.AddWithValue("@testingMode", portDetObj.testingMode);
cmd.Parameters.AddWithValue("@passCount", portDetObj.passCount);
cmd.Parameters.AddWithValue("@failCount", portDetObj.failCount);
cmd.Parameters.AddWithValue("@failTypePoints", portDetObj.failTypePoints);
cmd.Parameters.AddWithValue("@cutterCount", portDetObj.cutterCount);
cmd.Parameters.AddWithValue("@labelSerialNumber", portDetObj.labelSerialNumber);
cmd.Parameters.AddWithValue("@printedBarCode", portDetObj.printedBarCode);
cmd.Parameters.AddWithValue("@operatorCode", portDetObj.operatorCode);
cmd.Parameters.AddWithValue("@shift", portDetObj.shift);
cmd.Parameters.AddWithValue("@lotCount", portDetObj.lotCount);
cmd.Parameters.AddWithValue("@lotQuantity", portDetObj.lotQuantity);
cmd.Parameters.AddWithValue("@customField", portDetObj.customField);
try {
con.Open();
if (cmd.ExecuteNonQuery() > 0)
{
MessageBox.Show("Data inserted successfully");
}
con.Close();
//retrieveData();
}
catch (Exception ex) {
con.Close();
MessageBox.Show(ex.Message);
}
}