public void ExceptionLogger(string stackTrace, DateTime encounteredDate, AppEnums.LoggerStatus status) { try { LoggerMessage _logMessage = new LoggerMessage(); _logMessage.StackTrace = stackTrace; _logMessage.EncounteredDate = encounteredDate; _logMessage.Status = status; DBHelper.Instance.RunExceptionLogger(_logMessage); } catch (Exception ex) { throw ex; } }
/// <summary> /// Inserts log to database for tracing purposes. /// </summary> /// <param name="logMsg"></param> public void RunExceptionLogger(LoggerMessage logMsg) { InitiateDBConnection(); try { SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = Constants.SP_INSERT_EXCEPTION_LOGGER; cmd.Parameters.Add("@StackTrace", logMsg.StackTrace); cmd.Parameters.Add("@EncounteredDate", logMsg.EncounteredDate); cmd.Parameters.Add("@Status", Convert.ToBoolean(logMsg.Status)); cmd.ExecuteNonQuery(); } catch (SqlException sqlEx) { throw sqlEx; } TerminateDBConnection(); }