spAddUpdate_ClientMemberships

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@SiteContentID	int	IN
@CurrentUsersID	int	IN
@Guid	uniqueidentifier	IN
@EmailTemplateID	int	IN
@MerchantAccount	int	IN
@XMLData	ntext	IN
@ShoppingCartPageID	int	IN
@CartMessage	ntext	IN
@CartSendMembershipAcknowledgementAlways	bit	IN
@AcknowledgementBlock	nvarchar(max)	IN
@RecurrenceOptionsTruePledge	ntext	IN
Definition

Copy

                CREATE procedure [dbo].[spAddUpdate_ClientMemberships]
            (
                @PKID int output,
                @SiteContentID    int,        
                @CurrentUsersID    int,
                @Guid uniqueidentifier,
                @EmailTemplateID int,
                @MerchantAccount int, 
                @XMLData nText,
                @ShoppingCartPageID int,
                @CartMessage ntext,
                @CartSendMembershipAcknowledgementAlways bit,
                @AcknowledgementBlock nvarchar(max),
                @RecurrenceOptionsTruePledge ntext
            )
            as

                begin transaction;

                if (@PKID<=0) begin

                    insert INTO ClientMemberships
                    (
                        SiteContentID,
                        OwnerID,
                        Guid,
                        EmailTemplateID,
                        MerchantAccount, 
                        XMLData,
                        ShoppingCartPageID,
                        CartMessage,
                        CartSendMembershipAcknowledgementAlways,
                        AcknowledgementBlock,
                        RecurrenceOptionsTruePledge
                    )values(
                        @SiteContentID,
                        @CurrentUsersID,
                        @Guid,
                        @EmailTemplateID,
                        @MerchantAccount,
                        @XMLData,
                        @ShoppingCartPageID,
                        @CartMessage,
                        @CartSendMembershipAcknowledgementAlways,
                        @AcknowledgementBlock,
                        @RecurrenceOptionsTruePledge
                    )

                    select @PKID = @@Identity;

                    exec spAuditThis @CurrentUsersID, 1, @Guid, 24;

                end else begin

                    update ClientMemberships set
                        EmailTemplateID = @EmailTemplateID,
                        MerchantAccount = @MerchantAccount,
                        XMLData    = @XMLData,
                        ShoppingCartPageID = @ShoppingCartPageID,
                        CartMessage = @CartMessage,
                        CartSendMembershipAcknowledgementAlways = @CartSendMembershipAcknowledgementAlways,
                        AcknowledgementBlock = @AcknowledgementBlock,
                        RecurrenceOptionsTruePledge = @RecurrenceOptionsTruePledge 
                    where ID=@PKID;

                    exec spAuditThis @CurrentUsersID, 2, @Guid, 24;

                end

                commit transaction;