spAddUpdate_ShoppingCartEvent

Parameters

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

Definition

Copy



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