spTransactions_AddUpdateEventReg

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ClientEventID	int	IN
@UserID	int	IN
@xmlData	ntext	IN
@EmailID	int	IN
@GiftAmount	numeric(30, 6)	IN
@GiftPaymentMethod	int	IN
@GiftCurrencyType	int	IN
@TransactionGUID	uniqueidentifier	IN
@BackOfficeUserID	int	IN
@Status	int	IN
@EmailJobRecipientID	int	IN
Definition

Copy


            CREATE PROCEDURE [dbo].[spTransactions_AddUpdateEventReg]
            (
                @PKID int output,
                @ClientEventID int,
                @UserID int,
                @xmlData ntext,
                @EmailID int, 
                @GiftAmount numeric(30,6), 
                @GiftPaymentMethod int, 
                @GiftCurrencyType int,
                @TransactionGUID uniqueidentifier,
                @BackOfficeUserID int,
                @Status int,
                @EmailJobRecipientID int
            )
            AS

                if datalength(@xmlData)<8 
                begin
                    RAISERROR ('Unable to insert transaction -EventTransactions.XMLObjectData cannot be a zero-length string and must be well formed XML',16,1)
                    return 0
                end

                if @UserID=0 set @UserID=NULL
                if @EmailJobRecipientID <= 0 set @EmailJobRecipientID = NULL

                begin transaction

                if (@PKID<=0)

                begin
                    insert into dbo.EventTransactions
                    (ClientEventsID,AddedByUserID,XMLObjectData,EmailID,GiftAmount,GiftPaymentMethod,GiftCurrencyType,TransactionGUID,[Status],[EmailJobRecipientID]) 
                    values
                    (@ClientEventID,@UserID,@xmlData,@EmailID,@GiftAmount, @GiftPaymentMethod, @GiftCurrencyType,@TransactionGUID,@Status,@EmailJobRecipientID)

                    SELECT @PKID = SCOPE_IDENTITY()

                end 
                else 
                begin
                    UPDATE dbo.EventTransactions SET
                        ClientEventsID         =@ClientEventID,
                        AddedByUserID         =@UserID,
                        XMLObjectData         =@xmlData,
                        EmailID            = @EmailID,
                        GiftAmount        = @GiftAmount,
                        GiftPaymentMethod    = @GiftPaymentMethod,
                        GiftCurrencyType    = @GiftCurrencyType,
                        TransactionGUID     =@TransactionGUID,
                        [Status]            =@Status,
                        [EmailJobRecipientID] = @EmailJobRecipientID
                    WHERE EventTransactionsID=@PKID
                end

                if @Status = 1
                    begin

                        --This will save the transaction into the BBNCTransactions Table

                    Declare @BBNCTransactionsPKID int
                    Set @BBNCTransactionsPKID = 0

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

                    if @Status=1
                    begin
                        exec spTransactions_InsertTransaction @BBNCTransactionsPKID, @PKID, @TransactionType, @xmlData, @UserID, @BackOfficeUserID
                    end

                end        

                commit transaction