spTransactions_UpdateDonationTransactionStatus

Parameters

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

Definition

Copy



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

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

    Declare @BBNCTransactionsPKID int
    Set @BBNCTransactionsPKID = 0

    Declare @TransactionType nvarchar(100)
    Set @TransactionType = '{5705B543-4033-4a3a-BBCD-A731403EE1E6}'

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