You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
50 lines
1.6 KiB
50 lines
1.6 KiB
|
|
GO
|
|
use FastMoneyPro_Remit;
|
|
|
|
GO
|
|
CREATE OR ALTER PROC PROC_REMIT_INBOUND_LOGS
|
|
(
|
|
@Flag VARCHAR(20)
|
|
, @SessionIdentifier VARCHAR(40) = NULL
|
|
, @ProcessIdentifier VARCHAR(40) = NULL
|
|
, @RequestedBy VARCHAR(80) = NULL
|
|
, @MethodName VARCHAR(50) = NULL
|
|
, @IpAddress VARCHAR(20) = NULL
|
|
, @PartnerSessionId VARCHAR(40) = NULL
|
|
, @RequestJson NVARCHAR(MAX) = NULL
|
|
, @ResponseJson NVARCHAR(MAX) = NULL
|
|
, @ResponseCode VARCHAR(5) = NULL
|
|
, @ResponseMessage NVARCHAR(500) = NULL
|
|
, @RowId BIGINT = NULL
|
|
)
|
|
AS;
|
|
SET NOCOUNT ON;
|
|
SET XACT_ABORT ON;
|
|
BEGIN TRY
|
|
BEGIN
|
|
DECLARE @ErrorMsg VARCHAR(MAX) = NULL
|
|
IF @Flag = 'I-LOG'
|
|
BEGIN
|
|
INSERT INTO TBL_REMIT_INBOUND_LOG (SessionIdentifier, ProcessIdentifier, RequestedBy, RequestedDate, MethodName, PartnerSessionId, RequestJson, IpAddress)
|
|
SELECT @SessionIdentifier, @ProcessIdentifier, @RequestedBy, GETDATE(), @MethodName, @PartnerSessionId, @RequestJson, @IpAddress
|
|
|
|
SET @RowId = @@IDENTITY;
|
|
EXEC SW_PROC_ERROR_HANDLER @ErrorCode = 100, @ErrorMessage = 'Success saving inbound log.', @Id = @RowId;
|
|
END
|
|
ELSE IF @Flag = 'U-LOG'
|
|
BEGIN
|
|
UPDATE TBL_REMIT_INBOUND_LOG SET ResponseCode = @ResponseCode, ResponseMessage = @ResponseMessage, ResponseJson = @ResponseJson
|
|
WHERE RowId = @RowId
|
|
|
|
EXEC SW_PROC_ERROR_HANDLER @ErrorCode = 100, @ErrorMessage = 'Success updating inbound log.', @Id = @RowId;
|
|
END
|
|
END
|
|
END TRY
|
|
BEGIN CATCH
|
|
IF @@TRANCOUNT>0
|
|
ROLLBACK TRANSACTION
|
|
|
|
SET @ErrorMsg = 'Exception executing SP: ' + ERROR_MESSAGE()
|
|
EXEC SW_PROC_ERROR_HANDLER @ErrorCode = 101, @ErrorMessage = @ErrorMsg, @Id = NULL;
|
|
END CATCH
|