spAddUpdate_ShoppingCartMembership

Parameters

Parameter	Parameter Type	Mode
@PKID	int	IN
@ShoppingCartID	int	IN
@TransactionXml	ntext	IN
@AcknowledgementXml	ntext	IN
@Amount	decimal(30, 6)	IN
@BenefitsHTML	ntext	IN
@AllowsMatchingGifts	bit	IN
@CartSendMembershipAcknowledgementAlways	bit	IN

Definition

Copy



        CREATE procedure [dbo].[spAddUpdate_ShoppingCartMembership] (
                @PKID int,
                @ShoppingCartID int,
                @TransactionXml ntext,
                @AcknowledgementXml ntext,
                @Amount decimal(30,6),
                @BenefitsHTML ntext,
                @AllowsMatchingGifts bit,
                @CartSendMembershipAcknowledgementAlways bit
            ) as
                if (@PKID <= 0)
                    insert into dbo.ShoppingCartMembership (
                        ShoppingCartID,
                        TransactionXml,
                        AcknowledgementXml,
                        Amount,
                        BenefitsHTML,
                        AllowsMatchingGifts,
                        CartSendMembershipAcknowledgementAlways
                    ) values (
                        @ShoppingCartID,
                        @TransactionXml,
                        @AcknowledgementXml,
                        @Amount,
                        @BenefitsHTML,
                        @AllowsMatchingGifts,
                        @CartSendMembershipAcknowledgementAlways
                    )
                else
                    update dbo.ShoppingCartMembership set
                        UpdateDate = getutcdate(),
                        TransactionXml = @TransactionXml,
                        AcknowledgementXml = @AcknowledgementXml,
                        Amount = @Amount,
                        BenefitsHTML = @BenefitsHTML,
                        AllowsMatchingGifts = @AllowsMatchingGifts,
                        CartSendMembershipAcknowledgementAlways = @CartSendMembershipAcknowledgementAlways
                    where ShoppingCartID = @ShoppingCartID and ID = @PKID;