private void GetNotificationData(Int64 ID) { ENT.ResponseHeatReport objResponse = new ENT.ResponseHeatReport(); List <ENT.HeatStartStopReportApi> lstResult = new List <ENT.HeatStartStopReportApi>(); lstResult = new DAL.HeatStartStopReport().GetHeatStartStopReportByDate(DateTime.Now.ToString("dd-MMM-yyyy"), ID); if (lstResult.Count > 0) { // heat timming data objResponse.ReportName = "HeatReport"; objResponse.PowerOn = Convert.ToString(lstResult[0].StartDataTime); objResponse.SuperHeat = Convert.ToString(lstResult[0].StartDataTime); objResponse.HeatTapped = Convert.ToString(lstResult[0].EndDataTime); objResponse.TapToTapHrsMin = Convert.ToString(lstResult[0].HrsMin); // heat unit consumption data objResponse.KwhrAtStart = Convert.ToString(lstResult[0].DataValue); objResponse.KwhrAtEnd = Convert.ToString(lstResult[0].DataValue2); objResponse.TotalKwhr = Convert.ToString(lstResult[0].UnitDifference); objResponse.KwhrHeat = Convert.ToString(lstResult[0].UnitDifference * 10); // create json for send data to mobile app string jsonNotification = Newtonsoft.Json.JsonConvert.SerializeObject(objResponse); ENT.HeatStartStopReport objENT = new ENT.HeatStartStopReport(); // here, call the function for send data from local to live database string result = SendHeatStartStopReportData(objENT, jsonNotification); } }
public bool UpdateHeatStartStopReport(ENT.HeatStartStopReport objENT) { bool row = false; try { sqlCMD = new SqlCommand(); sqlCMD.CommandText = "InsertUpdateDeleteHeatStartStopReport"; sqlCMD.Parameters.AddWithValue("@ID", objENT.ID); sqlCMD.Parameters.AddWithValue("@fur_name", objENT.fur_name); sqlCMD.Parameters.AddWithValue("@fur_no", objENT.fur_no); sqlCMD.Parameters.AddWithValue("@fur_status_stop", objENT.fur_status_stop); sqlCMD.Parameters.AddWithValue("@fur_status_start", objENT.fur_status_start); sqlCMD.Parameters.AddWithValue("@fur_open_time", objENT.fur_open_time); sqlCMD.Parameters.AddWithValue("@fur_close_time", objENT.fur_close_time); sqlCMD.Parameters.AddWithValue("@LineCountEnd", objENT.LineCountEnd); sqlCMD.Parameters.AddWithValue("@EndDataTime", objENT.EndDataTime); sqlCMD.Parameters.AddWithValue("@DataValue", objENT.DataValue); sqlCMD.Parameters.AddWithValue("@isupdated", objENT.isupdated); sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode); row = objCRUD.InsertUpdateDelete(sqlCMD); } catch (Exception ex) { throw ex; } return(row); }
public bool InsertHeatStartStopReport(ENT.HeatStartStopReport objENT) { bool row = false; try { sqlCMD = new SqlCommand(); sqlCMD.CommandText = "InsertUpdateDeleteHeatStartStopReport"; 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("@DataValue", objENT.DataValue); sqlCMD.Parameters.AddWithValue("@DataValue2", objENT.DataValue2); sqlCMD.Parameters.AddWithValue("@FileName", objENT.FileName); sqlCMD.Parameters.AddWithValue("@EntryDate", objENT.EntryDate); sqlCMD.Parameters.AddWithValue("@isupdated", objENT.isupdated); sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode); row = objCRUD.InsertUpdateDelete(sqlCMD); } catch (Exception ex) { throw ex; } return(row); }
public List <ENT.HeatStartStopReport> GetHeatStartStopReport(ENT.HeatStartStopReport objENT) { List <ENT.HeatStartStopReport> lstENT = new List <ENT.HeatStartStopReport>(); try { sqlCMD = new SqlCommand(); sqlCMD.CommandText = "GetHeatStartStopReport"; sqlCMD.Parameters.AddWithValue("@ID", objENT.ID); sqlCMD.Parameters.AddWithValue("@Mode", objENT.Mode); lstENT = DBHelper.GetEntityList <ENT.HeatStartStopReport>(sqlCMD); } catch (Exception ex) { throw ex; } return(lstENT); }
private string SendHeatStartStopReportData(ENT.HeatStartStopReport obj, string json) { string message = string.Empty; try { // this is our live api url for send data to live database WebRequest tRequest = WebRequest.Create("http://gisrv.appsmith.co.in/api/HeatReport/InsertHeatStartStopReportAPI"); tRequest.Method = "POST"; tRequest.ContentType = "application/json"; obj.heat_json = json; string jsonNotificationFormat = Newtonsoft.Json.JsonConvert.SerializeObject(obj); Byte[] byteArray = Encoding.UTF8.GetBytes(jsonNotificationFormat); tRequest.ContentLength = byteArray.Length; tRequest.ContentType = "application/json"; using (Stream dataStream = tRequest.GetRequestStream()) { dataStream.Write(byteArray, 0, byteArray.Length); using (WebResponse tResponse = tRequest.GetResponse()) { using (Stream dataStreamResponse = tResponse.GetResponseStream()) { using (StreamReader tReader = new StreamReader(dataStreamResponse)) { String responseFromFirebaseServer = tReader.ReadToEnd(); message = "HeatStartStopReport : " + responseFromFirebaseServer; } } } } } catch (Exception ex) { message = ex.Message; return(message); } return(message); }
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()); } }
private void ReadData() { string strFilename = "01SELEC" + DateTime.Now.ToString("yyMMdd") + ".csv"; try { objTime.Stop(); objTime.Enabled = false; int cntInsert = 0; string copyToFilePath = Path.Combine(Application.StartupPath, strFilename); string[] copyFromFilePath = File.ReadAllLines(Path.Combine(Application.StartupPath, "DownloadFilePath.txt")); tmInerval = Convert.ToInt32(copyFromFilePath[1]); objTime.Interval = ((1000 * 60) * tmInerval); #region Copy File From FTP Folder if (File.Exists(copyToFilePath)) { if (File.Exists(Path.Combine(copyFromFilePath[0], strFilename))) { File.Delete(copyToFilePath); File.Copy(Path.Combine(copyFromFilePath[0], strFilename), copyToFilePath); } else { notifyIcon1.BalloonTipText = "File not generated by machine, Please check machine status."; notifyIcon1.ShowBalloonTip(2000); objTime.Start(); } } else { if (File.Exists(Path.Combine(copyFromFilePath[0], strFilename))) { File.Copy(Path.Combine(copyFromFilePath[0], strFilename), copyToFilePath); } else { notifyIcon1.BalloonTipText = "File not generated by machine, Please check machine status."; notifyIcon1.ShowBalloonTip(2000); objTime.Start(); } } #endregion #region Line Count Of File DataTable dtNew = new DataTable(); if (conn.State == ConnectionState.Closed) { conn.Open(); } string strqry = "SELECT COUNT(*) AS Cnt FROM MeterSlaveMaster WHERE FileName='" + strFilename.Trim() + "'"; SqlCommand cmd = new SqlCommand(); cmd.CommandText = strqry; cmd.CommandType = CommandType.Text; cmd.Connection = conn; SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dtNew); if (conn.State == ConnectionState.Open) { conn.Close(); } int lines_count = Convert.ToInt32(dtNew.Rows[0][0]); #endregion DataTable dtCSV = DAL.MeterSlaveMaster.GetDataTableFromCSVFile((Path.Combine(Application.StartupPath, strFilename))); for (int m = lines_count; m < dtCSV.Rows.Count; m++) { try { ENT.MeterSlaveMaster objENT = new ENT.MeterSlaveMaster(); ENT.HeatStartStopReport objHSSR = new ENT.HeatStartStopReport(); ENT.DryrunHeatReport objHDRH = new ENT.DryrunHeatReport(); objENT.ID = Guid.NewGuid(); string date = dtCSV.Rows[m][0].ToString().Substring(0, 8); string[] arrDate = date.Split('-'); DateTime dtDate = new DateTime(2000 + Convert.ToInt32(arrDate[0]), Convert.ToInt32(arrDate[1]), Convert.ToInt32(arrDate[2]), 0, 0, 0); objENT.DataDate = dtDate; string time = dtCSV.Rows[m][0].ToString().Substring(9, 8); string[] arrTime = time.Split(':'); DateTime dtTime = new DateTime(2000 + Convert.ToInt32(arrDate[0]), Convert.ToInt32(arrDate[1]), Convert.ToInt32(arrDate[2]), Convert.ToInt32(arrTime[0]), Convert.ToInt32(arrTime[1]), Convert.ToInt32(arrTime[2])); objENT.DataTime = dtTime; objENT.MeterID = 0; objENT.SlaveID = 0; objENT.Address = 0; objENT.Quantity = 0; objENT.DataValue = Convert.ToDecimal(Convert.ToString(dtCSV.Rows[m][1])); string strValues = Convert.ToString(dtCSV.Rows[m][2]); strValues = strValues.Replace("[", "").Replace("]", ""); string[] Values = strValues.Split(','); objENT.Value1 = Convert.ToDecimal(Values[0]); objENT.Value2 = Convert.ToDecimal(Values[1]); #region Get Last Unit DataTable dtTop = new DataTable(); if (conn.State == ConnectionState.Closed) { conn.Open(); } string strTopOne = "SELECT TOP 1 ISNULL(DataValue,0) as DataValue,Value2,FinalUnit FROM MeterSlaveMaster ORDER BY EntryDate DESC, LineCount DESC"; SqlCommand cmdtop = new SqlCommand(); cmdtop.CommandText = strTopOne; cmdtop.CommandType = CommandType.Text; cmdtop.Connection = conn; SqlDataAdapter daTop = new SqlDataAdapter(cmdtop); daTop.Fill(dtTop); decimal dcmPrvValue2 = 0; if (conn.State == ConnectionState.Open) { conn.Close(); } if (dtTop.Rows.Count > 0) { objENT.DataValue2 = Convert.ToDecimal(dtTop.Rows[0]["DataValue"]); objENT.FinalUnit = Convert.ToDecimal(dtTop.Rows[0]["FinalUnit"]); dcmPrvValue2 = Convert.ToDecimal(dtTop.Rows[0]["Value2"]); using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\LastUnitLog-" + DateTime.Now.ToString("dd-MM-yyyy") + ".txt", true)) { file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> DataValue Found >> " + objENT.DataValue2 + " >> " + " LINE_NO >> " + m); } } else { objENT.DataValue2 = 0; objENT.FinalUnit = 0; using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\LastUnitLog-" + DateTime.Now.ToString("dd-MM-yyyy") + ".txt", true)) { file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> DataValue Not Found>> " + objENT.DataValue2 + " >> " + " LINE_NO >> " + m); } } decimal dcmDiff = objENT.Value2 - dcmPrvValue2; dcmDiff = dcmDiff / 64; if (dcmDiff < 0) { dcmDiff = dcmDiff + 1024; } objENT.Difference = dcmDiff; objENT.FinalUnit = objENT.FinalUnit + dcmDiff; #endregion string QueryString = "INSERT INTO MeterSlaveMaster (ID,DataDate,DataTime,MeterID,SlaveID,Address,Quantity,DataValue,DataValue2,Difference,FinalUnit,Value1,Value2,FileName,LineCount,EntryDate) values ('" + objENT.ID.ToString() + "','" + objENT.DataDate.ToString("dd/MMM/yyyy") + "','" + objENT.DataTime.ToString("dd/MMM/yyyy hh:mm:ss tt") + "'," + objENT.MeterID + "," + objENT.SlaveID + "," + objENT.Address + "," + objENT.Quantity + "," + objENT.DataValue + "," + objENT.DataValue2 + "," + objENT.Difference + "," + objENT.FinalUnit + "," + objENT.Value1 + "," + objENT.Value2 + ",'" + strFilename.Trim() + "'," + (m + 1).ToString() + ",getdate())"; if (conn.State == ConnectionState.Closed) { conn.Open(); } SqlCommand cmdInsert = new SqlCommand(); cmdInsert.CommandText = QueryString; cmdInsert.CommandType = CommandType.Text; cmdInsert.Connection = conn; if (cmdInsert.ExecuteNonQuery() > 0) { cntInsert = cntInsert + 1; if (m == 0) { // Insert First record for heat report try { objHSSR.LineCountStart = lines_count + 1; objHSSR.LineCountEnd = lines_count + 1; objHSSR.StartDataTime = objENT.DataTime; objHSSR.EndDataTime = objENT.DataTime; objHSSR.DataValue = objENT.DataValue; objHSSR.DataValue2 = objENT.DataValue; objHSSR.FileName = strFilename.Trim(); 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\\LastUnitLog-" + DateTime.Now.ToString("dd-MM-yyyy") + ".txt", true)) { file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> FILE_NAME >> " + strFilename + " >> LINE_NO >> " + cntInsert + " >> Inserted For Report."); } } } catch (Exception ex) { using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\ErrorLog.txt", true)) { file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> FILE_NAME >> " + strFilename + " >> LINE_NO >> " + cntInsert + " >> HeatReport >> " + ex.Message.ToString()); } } // Insert First record for dryrun heat report try { objHDRH.LineCountStart = lines_count + 1; objHDRH.LineCountEnd = lines_count + 1; objHDRH.StartDataTime = objENT.DataTime; objHDRH.EndDataTime = objENT.DataTime; objHDRH.DataValueLast = objENT.DataValue; objHDRH.DataValueFirst = objENT.DataValue; objHDRH.FileName = strFilename.Trim(); 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\\LastUnitLog-" + DateTime.Now.ToString("dd-MM-yyyy") + ".txt", true)) { file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> FILE_NAME >> " + strFilename + " >> " + " >> LINE_NO >> " + cntInsert + " >> Inserted For Dryrun Report."); } } } catch (Exception ex) { using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\ErrorLog.txt", true)) { file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> FILE_NAME >> " + strFilename + " >> " + " >> LINE_NO >> " + cntInsert + " >> DryrunReport >> " + ex.Message.ToString()); } } } } if (conn.State == ConnectionState.Open) { conn.Close(); } } catch (Exception ex) { using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\ErrorLog.txt", true)) { file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> FILE_NAME >> " + strFilename + " >> " + " >> LINE_NO >> " + cntInsert + " >> " + ex.Message.ToString()); } if (conn.State == ConnectionState.Open) { conn.Close(); } } } objTime.Start(); objTime.Enabled = true; } catch (Exception ex) { using (System.IO.StreamWriter file = new System.IO.StreamWriter(Application.StartupPath + "\\Log\\ErrorLog.txt", true)) { file.WriteLine("Date >> " + DateTime.Now.ToString("dd/MMM/yyyy hh:mm:ss tt") + " >> FILE_NAME >> " + strFilename + " >> " + ex.Message.ToString()); } if (conn.State == ConnectionState.Open) { conn.Close(); } notifyIcon1.BalloonTipText = "Error : " + ex.Message.ToString(); notifyIcon1.ShowBalloonTip(2000); objTime.Start(); } }