public int LogErrorInternal(string message, ErrorType type, Exception e, HttpContextLoggerInfo wrapper) { var connection = new SqlConnection(ConnectionString); var cmd = new SqlCommand("dbo.LogError", connection) { CommandType = CommandType.StoredProcedure }; var requestIdParameter = new SqlParameter("RequestId", SqlDbType.BigInt) { Direction = ParameterDirection.InputOutput }; cmd.Parameters.Add(requestIdParameter); if (wrapper == null) { requestIdParameter.Value = null; } else { SetWebEnabledParameters(cmd, wrapper); requestIdParameter.Value = wrapper.Items[REQUEST_ID_CONTEXT_KEY]; } SetStandAloneErrorParameters(message, type, e, cmd); ExecuteCommand(connection, cmd); RequestId = Convert.ToInt32(cmd.Parameters["RequestId"].Value); if (wrapper != null && wrapper.Items[REQUEST_ID_CONTEXT_KEY] == null) { wrapper.Items[REQUEST_ID_CONTEXT_KEY] = RequestId; } return Convert.ToInt32(cmd.Parameters["ErrorId"].Value); }
public void LogSecurityEventInternal(EventType type, Result result, string description, HttpContextLoggerInfo wrapper) { var connection = new SqlConnection(ConnectionString); var cmd = new SqlCommand("dbo.LogSecurityEvent", connection) { CommandType = CommandType.StoredProcedure }; var requestIdParameter = new SqlParameter("RequestId", SqlDbType.BigInt) { Direction = ParameterDirection.InputOutput }; cmd.Parameters.Add(requestIdParameter); if (wrapper == null) { requestIdParameter.Value = null; } else { SetWebEnabledParameters(cmd, wrapper); requestIdParameter.Value = wrapper.Items[REQUEST_ID_CONTEXT_KEY]; } SetStandAloneSecurityEventParameters(description, type, result, cmd); ExecuteCommand(connection, cmd); RequestId = Convert.ToInt32(cmd.Parameters["RequestId"].Value); if (wrapper != null && wrapper.Items[REQUEST_ID_CONTEXT_KEY] == null) { wrapper.Items[REQUEST_ID_CONTEXT_KEY] = RequestId; } }
private static void SetWebEnabledParameters(SqlCommand cmd, HttpContextLoggerInfo wrapper) { cmd.Parameters.Add(new SqlParameter("SessionKey", SqlDbType.NVarChar)).Value = wrapper.SessionID; cmd.Parameters.Add(new SqlParameter("Ip", SqlDbType.NChar)).Value = wrapper.UserHostAddress; cmd.Parameters.Add(new SqlParameter("UserAgent", SqlDbType.NVarChar)).Value = wrapper.UserAgent; cmd.Parameters.Add(new SqlParameter("UserId", SqlDbType.NVarChar)).Value = wrapper.UserName; cmd.Parameters.Add(new SqlParameter("Uri", SqlDbType.NVarChar)).Value = wrapper.AbsoluteUri; }