spAddUpdate_TargetedContentPart

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@Name	nvarchar(100)	IN
@SiteContentID	int	IN
@CurrentUsersID	int	IN
@Guid	uniqueidentifier	IN
Definition

Copy


        CREATE PROCEDURE [dbo].[spAddUpdate_TargetedContentPart]
        (
            @PKID            int output,
            @Name            nvarchar(100),
            @SiteContentID        int,    
            @CurrentUsersID        int,
            @Guid            uniqueidentifier
        )
        AS

                begin transaction

                if (@PKID<=0)

                begin
                    INSERT INTO TargetedContentPart
                    (
                    [Name],
                    [SiteContentID],
                    [Guid]
                    )
                    VALUES
                    (
                    @Name,
                    @SiteContentID,
                    @Guid
                    )

                    SELECT @PKID = @@Identity

                    exec spAuditThis @CurrentUsersID, 1, @Guid, 20
                end 
                else 
                begin

                    UPDATE TargetedContentPart SET
                        [Name] = @Name,
                        [Guid]            = @Guid
                    WHERE ID=@PKID
                    exec spAuditThis @CurrentUsersID, 2, @Guid, 20
                end

                commit transaction