USP_WEBDASHBOARDFOLDER_ADD

Adds a web dashboard folder to the database.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(200)	IN
@DESCRIPTION	nvarchar(1000)	IN
@PARENTPATH	nvarchar(1000)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_WEBDASHBOARDFOLDER_ADD(@ID uniqueidentifier,
    @NAME nvarchar(200),
    @DESCRIPTION nvarchar(1000),
    @PARENTPATH nvarchar(1000),
    @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    if @CHANGEAGENTID is null
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @PATH nvarchar(1000);
    declare @PARENTID uniqueidentifier;
    declare @TEMPPARENTID uniqueidentifier;

    select @PARENTID = ID from dbo.WEBDASHBOARDFOLDER where PATH = @PARENTPATH;

    set @TEMPPARENTID = @PARENTID;
    set @PATH = '';

    while @TEMPPARENTID is not null
    begin
        select @TEMPPARENTID = PARENTID, @PATH = NAME + '/' + @PATH from dbo.WEBDASHBOARDFOLDER where ID = @TEMPPARENTID;
    end;

    set @PATH = @PATH + @NAME;

    if @ID is null
        set @ID = newid();

    insert into dbo.WEBDASHBOARDFOLDER (NAME,
        DESCRIPTION,
        PARENTID,
        PATH,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED)
    values (@NAME,
        @DESCRIPTION,
        @PARENTID,
        @PATH,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        getdate(),
        getdate());