spAddUpdate_UserPageManagerPageTemplate

Parameters

Parameter	Parameter Type	Mode
@PKID	int	INOUT
@UserPageManagerId	int	IN
@SitePageId	int	IN
@RealmTypeId	int	IN
@DisplayName	nvarchar(100)	IN

Definition

Copy


CREATE PROCEDURE [dbo].[spAddUpdate_UserPageManagerPageTemplate]
        (
            @PKID            int output    ,
            @UserPageManagerId int,
            @SitePageId        int        ,
            @RealmTypeId    int,
            @DisplayName     nvarchar(100)
        )
        AS

        if (@PKID<=0)
            begin
                INSERT INTO UserPageManagerPageTemplates
                (
                UserPageManagerID,
                SitePageID,
                RealmType,
                DisplayName
                )

                VALUES
                (
                @UserPageManagerId,
                @SitePageId,
                @RealmTypeId,
                @DisplayName
                )

                SELECT @PKID = @@Identity

            end    
        else
            begin
                UPDATE UserPageManagerPageTemplates
                set 
                UserPageManagerID = @UserPageManagerId,
                SitePageID = @SitePageId,
                RealmType = @RealmTypeId,
                DisplayName = @DisplayName

                where ID = @PKID
            end