spAddUpdate_ShoppingCart

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@ShoppingCartPartID	int	IN
@ClientUsersID	int	IN
@CookieID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.spAddUpdate_ShoppingCart (
                @PKID int output,
                @ShoppingCartPartID int,
                @ClientUsersID int,
                @CookieID uniqueidentifier
            ) as
                if (@PKID <= 0) begin
                    insert into dbo.ShoppingCart (
                        ShoppingCartPartID,
                        ClientUsersID,
                        CookieID
                    ) values (
                        @ShoppingCartPartID,
                        @ClientUsersID,
                        @CookieID
                    );

                    select @PKID = @@Identity;

                end    else begin
                    update dbo.ShoppingCart set
                        ShoppingCartPartID = @ShoppingCartPartID,
                        ClientUsersID = @ClientUsersID,
                        UpdateDate = getUTCDate(),
                        CookieID = @CookieID
                    where ID=@PKID;
                end;