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();
}