spTransactions_InsertEventReg

Parameters

Parameter	Parameter Type	Mode
@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

Definition

Copy



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

    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

    begin tran    

    if @UserID=0 set @UserID=NULL

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


    --This will save the transaction into the BBNCTransactions Table
    Declare @BBNCTransactionsPKID int
    Set @BBNCTransactionsPKID = 0

    Declare @TransactionPKID int
    Set @TransactionPKID = @@identity

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

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

    if @@error = 0
    begin
    commit tran
    return @TransactionPKID
    end
    else
    begin
    rollback tran
    return 0
    end

    END