public void MessagingInfoLog(DateTime?loggedOn, string logBy, string busType, string subscriberType, string publisherType, string adapterType, string message, System.Exception occurredException) { var occuredExceptionStck = occurredException != null?ExceptionStub.CreateExceptionStubXML(occurredException) : string.Empty; const string insertQuery = @"INSERT INTO [MessagingInfoLog] ([LoggedOn],[LogBy],[BusType],[SubscriberType],[PublisherType],[AdapterType],[Message],[ExceptionType],[ExceptionStack]) VALUES (@LoggedOn, @LogBy,@BusType,@SubscriberType, @PublisherType, @AdapterType,@Message,@ExceptionType, @ExceptionStack)"; IList <SqlParameter> sqlParameters = new List <SqlParameter> { new SqlParameter { ParameterName = "@LoggedOn", SqlDbType = SqlDbType.DateTime, Value = loggedOn.HasValue && (loggedOn.Value != DateTime.MinValue) ?loggedOn.Value:SqlDateTime.Null }, new SqlParameter { ParameterName = "@LogBy", SqlDbType = SqlDbType.VarChar, Value = logBy.ToSqlString() }, new SqlParameter { ParameterName = "@BusType", SqlDbType = SqlDbType.VarChar, Value = busType.ToSqlString() }, new SqlParameter { ParameterName = "@SubscriberType", SqlDbType = SqlDbType.VarChar, Value = subscriberType.ToSqlString() }, new SqlParameter { ParameterName = "@PublisherType", SqlDbType = SqlDbType.VarChar, Value = publisherType.ToSqlString() }, new SqlParameter { ParameterName = "@AdapterType", SqlDbType = SqlDbType.VarChar, Value = adapterType.ToSqlString() }, new SqlParameter { ParameterName = "@Message", SqlDbType = SqlDbType.VarChar, Value = message.ToSqlString() }, new SqlParameter { ParameterName = "@ExceptionType", SqlDbType = SqlDbType.VarChar, Value = occurredException != null?occurredException.GetType().FullName : SqlString.Null }, new SqlParameter { ParameterName = "@ExceptionStack", SqlDbType = SqlDbType.Xml, Value = occuredExceptionStck } }; AddData(insertQuery, sqlParameters); }
public void MessagingSubscriberLog(Guid?messageUId, DateTime?loggedOn, string subscriberType, bool isSuccess, string message, int retryCount, System.Exception occurredException, bool isFatal, bool isRetryAllowed, int retryIntervalInMs, bool isCommandMessage, string retryMessageSubscribers, int retryMessageId, string environment) { string occuredExceptionStck = occurredException != null?ExceptionStub.CreateExceptionStubXML(occurredException) : string.Empty; const string insertQuery = @"INSERT INTO [Ensemble].[MessagingSubscriberLog] ([MessageUID],[LoggedOn],[SubscriberType],[IsSuccess],[Message],[RetryCount],[ExceptionType],[ExceptionStack],[IsFatal],[IsRetryAllowed],[RetryIntervalInMs],[IsCommandMessage],[RetryMessageSubscribers],[retryMessageId],[Environment]) VALUES (@MessageUID,@LoggedOn, @SubscriberType, @IsSuccess, @Message, @RetryCount,@ExceptionType, @ExceptionStack, @IsFatal, @IsRetryAllowed, @RetryIntervalInMs, @IsCommandMessage, @RetryMessageSubscribers, @RetryMessageId,@Environment)"; IList <SqlParameter> sqlParameters = new List <SqlParameter> { new SqlParameter { ParameterName = "@MessageUID", SqlDbType = SqlDbType.VarChar, Value = messageUId.HasValue ? messageUId.Value.ToString() : SqlString.Null }, new SqlParameter { ParameterName = "@LoggedOn", SqlDbType = SqlDbType.DateTime, Value = loggedOn.HasValue && (loggedOn.Value != DateTime.MinValue) ?loggedOn.Value:SqlDateTime.Null }, new SqlParameter { ParameterName = "@SubscriberType", SqlDbType = SqlDbType.VarChar, Value = subscriberType.ToSqlString() }, new SqlParameter { ParameterName = "@IsSuccess", SqlDbType = SqlDbType.Bit, Value = isSuccess }, new SqlParameter { ParameterName = "@Message", SqlDbType = SqlDbType.VarChar, Value = string.IsNullOrEmpty(message) ? SqlString.Null : message.ToSqlString() }, new SqlParameter { ParameterName = "@RetryCount", SqlDbType = SqlDbType.SmallInt, Value = retryCount }, new SqlParameter { ParameterName = "@ExceptionType", SqlDbType = SqlDbType.VarChar, Value = occurredException != null?occurredException.GetType().FullName : SqlString.Null }, new SqlParameter { ParameterName = "@ExceptionStack", SqlDbType = SqlDbType.Xml, Value = occuredExceptionStck }, new SqlParameter { ParameterName = "@IsFatal", SqlDbType = SqlDbType.Bit, Value = isFatal }, new SqlParameter { ParameterName = "@IsRetryAllowed", SqlDbType = SqlDbType.Bit, Value = isRetryAllowed }, new SqlParameter { ParameterName = "@RetryIntervalInMs", SqlDbType = SqlDbType.Int, Value = retryIntervalInMs }, new SqlParameter { ParameterName = "@IsCommandMessage", SqlDbType = SqlDbType.Bit, Value = isCommandMessage }, new SqlParameter { ParameterName = "@RetryMessageSubscribers", SqlDbType = SqlDbType.VarChar, Value = retryMessageSubscribers.ToSqlString() }, new SqlParameter { ParameterName = "@RetryMessageId", SqlDbType = SqlDbType.Int, Value = retryMessageId }, new SqlParameter { ParameterName = "@Environment", SqlDbType = SqlDbType.VarChar, Value = environment != null?environment:SqlString.Null } }; AddData(insertQuery, sqlParameters); }
public void MessagingPublisherLog(IMessageEnvelope envelope, string publisherType, bool isSuccess, string message, System.Exception occurredException) { string environment = ConfigurationHelper.GetEnvironment(envelope); JSONMessageSerializer serializer = new JSONMessageSerializer(); string envelopeString = serializer.SerializeEnvelope(envelope); string occuredExceptionStack = occurredException != null?ExceptionStub.CreateExceptionStubXML(occurredException) : string.Empty; const string insertQuery = @"INSERT INTO [Ensemble].[MessagingPublisherLog] ([MessageUID],[MessageSentOn],[MessageType],[Topic],[Originator],[UserName],[ReplyTo],[ReplyOf],[PublisherType] ,[IsSuccess],[Message],[MessageEnvelope],[ExceptionType],[ExceptionStack],[Environment]) VALUES (@MessageUID,@MessageSentOn, @MessageType,@Topic,@Originator, @UserName, @ReplyTo, @ReplyOf, @PublisherType, @IsSuccess, @Message, @MessageEnvelope, @ExceptionType, @ExceptionStack, @Environment)"; IList <SqlParameter> sqlParameters = new List <SqlParameter> { new SqlParameter { ParameterName = "@MessageUID", SqlDbType = SqlDbType.VarChar, Value = envelope.MessageUID.ToString().ToSqlString() }, new SqlParameter { ParameterName = "@MessageSentOn", SqlDbType = SqlDbType.DateTime, Value = envelope.MessageSentOn.ToSqlDateTime() }, new SqlParameter { ParameterName = "@MessageType", SqlDbType = SqlDbType.VarChar, Value = envelope.MessageType.ToSqlString() }, new SqlParameter { ParameterName = "@Topic", SqlDbType = SqlDbType.VarChar, Value = envelope.Topic.ToSqlString() }, new SqlParameter { ParameterName = "@Originator", SqlDbType = SqlDbType.VarChar, Value = envelope.Originator.ToSqlString() }, new SqlParameter { ParameterName = "@UserName", SqlDbType = SqlDbType.VarChar, Value = envelope.User.ToSqlString() }, new SqlParameter { ParameterName = "@ReplyTo", SqlDbType = SqlDbType.VarChar, Value = envelope.ReplyTo.ToSqlString() }, new SqlParameter { ParameterName = "@ReplyOf", SqlDbType = SqlDbType.VarChar, Value = envelope.ReplyOf.ToString().ToSqlString() }, new SqlParameter { ParameterName = "@PublisherType", SqlDbType = SqlDbType.VarChar, Value = publisherType.ToSqlString() }, new SqlParameter { ParameterName = "@IsSuccess", SqlDbType = SqlDbType.Bit, Value = isSuccess }, new SqlParameter { ParameterName = "@Message", SqlDbType = SqlDbType.VarChar, Value = message.ToSqlString() }, new SqlParameter { ParameterName = "@MessageEnvelope", SqlDbType = SqlDbType.VarChar, Value = envelopeString }, new SqlParameter { ParameterName = "@ExceptionType", SqlDbType = SqlDbType.VarChar, Value = occurredException != null?occurredException.GetType().FullName : SqlString.Null }, new SqlParameter { ParameterName = "@ExceptionStack", SqlDbType = SqlDbType.Xml, Value = occuredExceptionStack }, new SqlParameter { ParameterName = "@Environment", SqlDbType = SqlDbType.VarChar, Value = environment != null?environment : SqlString.Null } }; AddData(insertQuery, sqlParameters); }
public void MessagingHostLog(Guid?messageUId, DateTime?loggedOn, string hostInstance, string busType, bool isSuccess, string message, System.Exception occurredException, string environment) { var occuredExceptionStck = occurredException != null?ExceptionStub.CreateExceptionStubXML(occurredException) : string.Empty; const string insertQuery = @"INSERT INTO [Ensemble].[MessagingHostLog] ([MessageUID],[LoggedOn],[HostInstance],[BusType],[IsSuccess],[Message],[ExceptionType],[ExceptionStack],[Environment]) VALUES (@MessageUID,@LoggedOn, @HostInstance,@BusType,@IsSuccess, @Message, @ExceptionType, @ExceptionStack,@Environment)"; SqlString sqlString = SqlString.Null; SqlDateTime sqlDateTime = SqlDateTime.Null; IList <SqlParameter> sqlParameters = new List <SqlParameter> { new SqlParameter { ParameterName = "@MessageUID", SqlDbType = SqlDbType.VarChar, Value = messageUId.HasValue ? messageUId.Value.ToString() : SqlString.Null }, new SqlParameter { ParameterName = "@LoggedOn", SqlDbType = SqlDbType.DateTime, Value = loggedOn.HasValue && (loggedOn.Value != DateTime.MinValue) ?loggedOn.Value:SqlDateTime.Null }, new SqlParameter { ParameterName = "@HostInstance", SqlDbType = SqlDbType.VarChar, Value = hostInstance.ToSqlString() }, new SqlParameter { ParameterName = "@BusType", SqlDbType = SqlDbType.VarChar, Value = busType.ToSqlString() }, new SqlParameter { ParameterName = "@IsSuccess", SqlDbType = SqlDbType.Bit, Value = isSuccess }, new SqlParameter { ParameterName = "@Message", SqlDbType = SqlDbType.VarChar, Value = message.ToSqlString() }, new SqlParameter { ParameterName = "@ExceptionType", SqlDbType = SqlDbType.VarChar, Value = occurredException != null?occurredException.GetType().FullName : SqlString.Null }, new SqlParameter { ParameterName = "@ExceptionStack", SqlDbType = SqlDbType.Xml, Value = occuredExceptionStck }, new SqlParameter { ParameterName = "@Environment", SqlDbType = SqlDbType.VarChar, Value = environment != null?environment : SqlString.Null } }; AddData(insertQuery, sqlParameters); }