spTransactions_UpdateEventTransactionStatus

Parameters

Parameter	Parameter Type	Mode
@PKID	int	IN
@STATUS	int	IN
@BackOfficeUserID	int	IN

Definition

Copy



CREATE PROCEDURE [dbo].[spTransactions_UpdateEventTransactionStatus]
    ( @PKID int, @STATUS int, @BackOfficeUserID int) AS
UPDATE [dbo].[EventTransactions] SET [Status] = @Status WHERE [EventTransactionsID] = @PKID
IF @STATUS=1
BEGIN
    Declare @xmlData nvarchar(max)
    Set @xmlData = (SELECT [XMLObjectData] FROM [dbo].[EventTransactions] WHERE [EventTransactionsID] = @PKID)

    Declare @UserID int
    Set @UserID = (SELECT [AddedByUserID] FROM [dbo].[EventTransactions] WHERE [EventTransactionsID] = @PKID)

    Declare @BBNCTransactionsPKID int
    Set @BBNCTransactionsPKID = 0

    Declare @TransactionType nvarchar(100)
    Set @TransactionType = '{172A5D9A-5241-493c-A2C2-EAC164C095B0}'

    exec spTransactions_InsertTransaction @BBNCTransactionsPKID, @PKID, @TransactionType, @xmlData, @UserID, @BackOfficeUserID
END