spAddUpdate_ShoppingCartSummaryPart

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@SiteContentID	int	IN
@ShoppingCartPartID	int	IN
Definition

Copy


            create procedure dbo.spAddUpdate_ShoppingCartSummaryPart (
                @PKID                int output,
                @SiteContentID        int,
                @ShoppingCartPartID    int
            ) as
                begin transaction
                    if (@PKID<=0) begin
                        insert into ShoppingCartSummaryPart
                        (
                            SiteContentID,
                            ShoppingCartPartID
                        )
                        values
                        (
                            @SiteContentID,
                            @ShoppingCartPartID
                        );
                        select @PKID = @@Identity;
                    end else begin
                        update ShoppingCartSummaryPart set
                            SiteContentID = @SiteContentID,
                            ShoppingCartPartID = @ShoppingCartPartID
                        where 
                            ID = @PKID;
                    end
                commit transaction;