/// <summary>
/// Insert Update Dryrun report data
/// </summary>
/// <param name="objENT"></param>
/// <returns></returns>
public bool InsertUpdateDeleteDryrunHeatReport(ENT.DryrunHeatReport objENT)
{
bool row = false;
try
{
sqlCMD = new SqlCommand();
sqlCMD.CommandText = "InsertUpdateDeleteDryrunHeatReport";
sqlCMD.Parameters.AddWithValue("@ID", objENT.ID);
sqlCMD.Parameters.AddWithValue("@LineCountStart", objENT.LineCountStart);
sqlCMD.Parameters.AddWithValue("@LineCountEnd", objENT.LineCountEnd);
sqlCMD.Parameters.AddWithValue("@StartDataTime", objENT.StartDataTime);
sqlCMD.Parameters.AddWithValue("@EndDataTime", objENT.EndDataTime);
sqlCMD.Parameters.AddWithValue("@DataValueLast", objENT.DataValueLast);
sqlCMD.Parameters.AddWithValue("@DataValueFirst", objENT.DataValueFirst);
sqlCMD.Parameters.AddWithValue("@FileName", objENT.FileName);
sqlCMD.Parameters.AddWithValue("@EntryDate", objENT.EntryDate);
sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode);
row = objCRUD.InsertUpdateDelete(sqlCMD);
}
catch (Exception ex)
{
throw ex;
}
return(row);
}
private void DataReceivedHandler(object sender, SerialDataReceivedEventArgs e)
{
string fileName = "COMPortLog" + DateTime.Now.ToString("dd-MM-yyyy");
try
{
this.Invoke((Action) delegate
{
SerialPort sp = (SerialPort)sender;
string indata = sp.ReadLine();
string[] words = indata.Split('|');
if (words.Length >= 3)
{
CURR_FUR_NAME = Convert.ToString(words[0]).Trim();
CURR_FUR_NO = Convert.ToInt32(words[1]);
CURR_POUR_STATUS = Convert.ToString(words[2]).Trim() == "POURSTOP" ? Convert.ToInt32(DAL.MyEnum.PourStatus.POUR_STOP) : Convert.ToInt32(DAL.MyEnum.PourStatus.POUR_START);
if (CURR_FUR_NAME.Equals("FURNACE2") && CURR_FUR_NO.Equals(1))
{
SetText(CURR_FUR_NAME + "|" + CURR_FUR_NO + "|" + Convert.ToString(words[2]) + "|True");
using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\" + fileName + ".txt", true))
{
file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> STRING >> " + indata + "");
}
}
objENTFur.Mode = "GetTopOne";
objENTFur.fur_name = CURR_FUR_NAME.Trim();
objENTFur.fur_no = CURR_FUR_NO;
objENTFur.fur_status = CURR_POUR_STATUS;
lstENTFur = objDALFur.GetFurnaceSwitch(objENTFur);
if (lstENTFur.Count > 0)
{
if (lstENTFur[0].fur_status != CURR_POUR_STATUS)
{
// get last time from unit file.
SetText(getDateFromCSVFile().ToString("dd/MMM/yyyy hh:mm:ss tt") + " Date From File.");
objENTFur.fur_file_time = getDateFromCSVFile().ToString("dd/MMM/yyyy hh:mm:ss tt");
objENTFur.fur_id = Guid.NewGuid();
objENTFur.Mode = "ADD";
if (objDALFur.InsertUpdateDeleteFurnaceSwitch(objENTFur))
{
SetText(indata + "|True|InsertSuccess");
using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\" + fileName + ".txt", true))
{
file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> STRING >> " + indata + "|True|InsertSuccess");
}
}
else
{
SetText(indata + "|False|InsertFail");
using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\" + fileName + ".txt", true))
{
file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> STRING >> " + indata + "|False|InsertFail");
}
}
if (CURR_POUR_STATUS == 1)
{
// get top one record by id for updated
List <ENT.HeatStartStopReport> lstHSSR = new List <ENT.HeatStartStopReport>();
lstHSSR = new DAL.HeatStartStopReport().GetHeatStartStopReport(new ENT.HeatStartStopReport {
Mode = "GetByTopOneUpdate"
});
if (lstHSSR.Count > 0)
{
// when status is 0 then update record one time
if (lstHSSR[0].isupdated == 0)
{
try
{
// get last record from MeterSlaveMaster for update into HeatStartStopReport table
List <ENT.MeterSlaveMaster> lstMeter = new List <ENT.MeterSlaveMaster>();
lstMeter = new DAL.MeterSlaveMaster().GetTopOneRecord(new ENT.MeterSlaveMaster {
Mode = "GetByTopOne"
});
if (lstMeter.Count > 0)
{
ENT.HeatStartStopReport objHSSR = new ENT.HeatStartStopReport();
objHSSR = new ENT.HeatStartStopReport();
objHSSR.ID = lstHSSR[0].ID;
objHSSR.fur_name = lstENTFur[0].fur_name;
objHSSR.fur_no = lstENTFur[0].fur_no;
objHSSR.fur_status_stop = lstENTFur[0].fur_status;
objHSSR.fur_open_time = Convert.ToDateTime(lstENTFur[0].fur_open_time);
objHSSR.fur_close_time = Convert.ToDateTime(lstENTFur[0].fur_close_time);
objHSSR.LineCountEnd = lstMeter[0].LineCount;
objHSSR.EndDataTime = lstMeter[0].DataTime;
objHSSR.DataValue = lstMeter[0].DataValue;
objHSSR.isupdated = 1;
objHSSR.Mode = "UPDATE";
if (new DAL.HeatStartStopReport().UpdateHeatStartStopReport(objHSSR))
{
using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\" + fileName + ".txt", true))
{
file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> FILE_NAME >> " + lstMeter[0].FileName + " >> " + " >> LINE_NO >> " + objHSSR.LineCountEnd + " >> Updated For Report.");
}
}
}
}
catch (Exception ex)
{
using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\" + fileName + ".txt", true))
{
file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> ERROR >> " + ex.Message + "");
}
}
}
}
}
else if (CURR_POUR_STATUS == 0)
{
// get record from database where isupdated=0 if not found any record then insert one record with isupdated=0
List <ENT.HeatStartStopReport> lstHSSR = new List <ENT.HeatStartStopReport>();
lstHSSR = new DAL.HeatStartStopReport().GetHeatStartStopReport(new ENT.HeatStartStopReport {
Mode = "GetByTopOneInsert"
});
if (lstHSSR.Count == 0)
{
// get last record from MeterSlaveMaster for insert into HeatStartStopReport table
List <ENT.MeterSlaveMaster> lstMeter = new List <ENT.MeterSlaveMaster>();
lstMeter = new DAL.MeterSlaveMaster().GetTopOneRecord(new ENT.MeterSlaveMaster {
Mode = "GetByTopOne"
});
if (lstMeter.Count > 0)
{
ENT.HeatStartStopReport objHSSR = new ENT.HeatStartStopReport();
objHSSR.LineCountStart = lstMeter[0].LineCount;
objHSSR.LineCountEnd = lstMeter[0].LineCount;
objHSSR.StartDataTime = lstMeter[0].DataTime;
objHSSR.EndDataTime = lstMeter[0].DataTime;
objHSSR.DataValue = lstMeter[0].DataValue;
objHSSR.DataValue2 = lstMeter[0].DataValue;
objHSSR.FileName = lstMeter[0].FileName;
objHSSR.EntryDate = DateTime.Now;
objHSSR.isupdated = 0;
objHSSR.Mode = "ADD";
if (new DAL.HeatStartStopReport().InsertHeatStartStopReport(objHSSR))
{
using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\" + fileName + ".txt", true))
{
file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> FILE_NAME >> " + objHSSR.FileName + " >> " + " LINE_NO >> " + objHSSR.LineCountStart + " >> Inserted For Report.");
}
}
// Insert First record for dryrun heat report
ENT.DryrunHeatReport objHDRH = new ENT.DryrunHeatReport();
try
{
objHDRH.LineCountStart = lstMeter[0].LineCount;
objHDRH.LineCountEnd = lstMeter[0].LineCount;
objHDRH.StartDataTime = lstMeter[0].DataTime;
objHDRH.EndDataTime = lstMeter[0].DataTime;
objHDRH.DataValueLast = lstMeter[0].DataValue;
objHDRH.DataValueFirst = lstMeter[0].DataValue;
objHDRH.FileName = lstMeter[0].FileName;
objHDRH.EntryDate = DateTime.Now;
objHDRH.IsUpdated = 0;
objHDRH.Mode = "ADD";
if (new DAL.DryrunHeatReport().InsertUpdateDeleteDryrunHeatReport(objHDRH))
{
using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\" + fileName + ".txt", true))
{
file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> FILE_NAME >> " + objHDRH.FileName + " >> " + " LINE_NO >> " + objHDRH.LineCountStart + " >> Inserted For Dryrun Report.");
}
}
}
catch (Exception ex)
{
using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\ErrorLog.txt", true))
{
file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> FILE_NAME >> " + objHDRH.FileName + " >> " + " >> LINE_NO >> " + objHDRH.LineCountStart + " >> " + ex.Message.ToString());
}
}
}
}
}
}
}
else
{
// get last time from unit file.
SetText(getDateFromCSVFile().ToString("dd/MMM/yyyy hh:mm:ss tt") + " Date From File.");
objENTFur.fur_file_time = getDateFromCSVFile().ToString("dd/MMM/yyyy hh:mm:ss tt");
objENTFur.fur_id = Guid.NewGuid();
objENTFur.Mode = "ADD";
if (objDALFur.InsertUpdateDeleteFurnaceSwitch(objENTFur))
{
SetText(indata + "|True|FirstInsertSuccess");
}
else
{
SetText(indata + "|False|FirstInsertFail");
}
}
}
else
{
SetText(indata + "|NA");
}
});
}
catch (Exception ex)
{
using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\" + fileName + ".txt", true))
{
file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> ERROR >> " + ex.Message + "");
}
this.SetText("Error => " + ex.Message.ToString());
}
}