spTransactions_UpdateMembershipTransactionStatus

Parameters

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

Definition

Copy



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

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

    Declare @BBNCTransactionsPKID int
    Set @BBNCTransactionsPKID = 0

    Declare @TransactionType nvarchar(100)
    Set @TransactionType = '{D7D6143F-823D-4c74-AC2F-947CC96B7008}'

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