public void LogPrintCycleLogToLocalDb() { PrintCycleLog obj = null; try { obj = new PrintCycleLog() { TxnId = this.Transaction.Id, ReceiptId = this.Transaction.Id, TimePrt = DateTime.Now, ReceiptTaken = 1, KioskId = long.Parse(this.Transaction.MachineId) }; if (log.IsErrorEnabled) log.Error("PrintCycle logging for TxnId:" + obj.TxnId.ToString() + "KioskId:" + obj.KioskId.ToString()); DBLogger.AddTxnPrintCycle(obj); if (log.IsInfoEnabled) log.Info("Mawaqif - added entry in tbltxnPrintcycle using LogPrintCycleLogToLocalDb." + "TxnId:" + obj.TxnId.ToString()); } catch (Exception ex) { if (log.IsErrorEnabled) log.Error("Mawaqif - Caught exception in LogPrintCycleLogToLocalDb method. " + "TxnId:" + obj.TxnId.ToString() + "." + ex.Message); } }
public static int AddTxnPrintCycle(PrintCycleLog obj) { int result = 0; StringBuilder strSql = new StringBuilder(); StringBuilder strSelect = new StringBuilder(); SqlCeDataReader dr; strSelect.Append("select TXNID from tblTxnPrintCycle where TXNID='" + obj.TxnId + "'"); strSql.Append("INSERT INTO tblTxnPrintCycle"); strSql.Append("(TXNID, TIMEPRT, RECID, RECTAKEN,KioskID) VALUES ("); strSql.AppendFormat("'{0}','{1}','{2}',{3},{4})", obj.TxnId, FormatDateTime(obj.TimePrt), obj.ReceiptId, obj.ReceiptTaken,obj.KioskId); //Trace.WriteLine(strSql.ToString()); if (log.IsInfoEnabled) log.Info(strSql.ToString()); try { Open(strConnectionString); string readerResult = string.Empty; SqlCeCommand commandDr = new SqlCeCommand(strSelect.ToString()); dr = ExecuteReader(commandDr); while (dr.Read()) { readerResult = Convert.ToString(dr["TxnId"]); } dr.Close(); if (string.IsNullOrEmpty(readerResult)) { SqlCeCommand command = new SqlCeCommand(strSql.ToString()); result = ExecuteNonQuery(command); } if (log.IsErrorEnabled) log.Error("TxnID:"+obj.TxnId.ToString()+"KioskID:"+obj.KioskId + " is added in tblTxnPrintCycle.And Execution result is:" + result.ToString()); } catch (SqlCeException ex) { if (log.IsErrorEnabled) log.Error("SqlCeException caught in DBLogger.AddTxnPrintCycle.." + ex.Message); Close(); //System.Environment.Exit(1); // exit } catch (Exception ex) { if (log.IsErrorEnabled) log.Error("Generic exception caught in DBLogger.AddTxnPrintCycle.." + ex.Message); } return result; }
public static void LogPrintCycle(PrintCycleLog objLog, LOGTO enumLog = LOGTO.DATABASE) { int result = DBLogger.AddTxnPrintCycle(objLog); }