public static int AddEventLog(EventLogger objTrans)
{
//Set the Connection String
int result = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO tblEventLog");
strSql.Append("(KIOSKID, EventDttm, EventID, Description, Uploaded) VALUES (");
strSql.AppendFormat("'{0}','{1}',{2},'{3}','{4}')", objTrans.KioskId, FormatDateTime(objTrans.EventDtTm), objTrans.EventId, objTrans.Desc, objTrans.Uploaded);
if (log.IsInfoEnabled) log.Info("QUERY FORMED IN AddEventLog IS : " + strSql.ToString());
//Trace.WriteLine(strSql.ToString());
try
{
Open(strConnectionString);
SqlCeCommand command = new SqlCeCommand(strSql.ToString());
result = ExecuteNonQuery(command);
if (log.IsErrorEnabled) log.Error("KioskId:"+objTrans.KioskId.ToString() +" and EventId:"+ objTrans.EventId.ToString() +" is added in tblEventLog and result is:" + result.ToString());
}
catch (SqlCeException ex)
{
if (log.IsErrorEnabled) log.Error("SqlCeException caught in DBLogger.AddEventLog.." + ex.Message);
Close();
//System.Environment.Exit(1); // exit
}
catch (Exception ex)
{
if (log.IsErrorEnabled) log.Error("Generic exception caught in DBLogger.AddEventLog.." + ex.Message);
}
return result;
}
public static void LogEvents(EventLogger objLog, LOGTO enumLog = LOGTO.DATABASE)
{
int result = DBLogger.AddEventLog(objLog);
}