spAddUpdate_CMSRedirect

Parameters

Parameter	Parameter Type	Mode
@PKID	uniqueidentifier	INOUT
@ClientUserID	int	IN
@OriginalURL	nvarchar(1024)	IN
@TargetPageID	int	IN
@TargetTabID	int	IN
@TargetURL	nvarchar(1024)	IN

Definition

Copy


            CREATE PROCEDURE [dbo].[spAddUpdate_CMSRedirect]
    (
    @PKID uniqueidentifier output,
    @ClientUserID int,
    @OriginalURL nvarchar (1024),
    @TargetPageID int,
    @TargetTabID int,
    @TargetURL nvarchar (1024)    
    )
    AS
    BEGIN

    if @PKID is null
        set @PKID = newid()

    IF not exists(select * from dbo.CMSREDIRECT where [ID]= @PKID)
      BEGIN
      INSERT INTO dbo.[CMSRedirect]
      (
      ID,
      ClientUserID,
      OriginalURL,
      TargetPageID,
      TargetTabID,    
      TargetURL
      )
      VALUES
      (
      @PKID,
      @ClientUserID,
      @OriginalURL,
      @TargetPageID,
      isnull(@TargetTabID,''),      
      isnull(@TargetURL,'')      
      )

      END
      ELSE

      UPDATE [CMSRedirect] SET
      ClientUserID =@ClientUserID,
      OriginalURL=@OriginalURL,
      TargetPageID=@TargetPageID,
      TargetTabID=isnull(@TargetTabID,''),      
      TargetURL=isnull(@TargetURL,'')      
      WHERE [ID]=@PKID

      END