spTransactions_InsertMembershipTrans

Parameters

Parameter	Parameter Type	Mode
@ClientMembershipsID	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_InsertMembershipTrans]
    (
    @ClientMembershipsID 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 - membershipTransactions.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.MembershipTransactions
    (ClientMembershipsID,AddedByUserID,XMLObjectData, EmailID, GiftAmount, GiftPaymentMethod, GiftCurrencyType,TransactionGUID,[Status]) 
    values
    (@ClientMembershipsID,@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 = '{D7D6143F-823D-4c74-AC2F-947CC96B7008}'

    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