USP_WEBDASHBOARDLAYOUT_CREATEORUPDATE

Creates or updates a layout for the web dashboard.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(1000)	IN
@CONTENTS	nvarchar(max)	IN
@PREVIEWIMAGE	varbinary	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_WEBDASHBOARDLAYOUT_CREATEORUPDATE(@ID uniqueidentifier output,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(1000),
    @CONTENTS nvarchar(max),
    @PREVIEWIMAGE varbinary(max) = null,
    @CHANGEAGENTID uniqueidentifier)
as
    set nocount on;

    if exists(select ID from dbo.WEBDASHBOARDLAYOUT where ID = @ID)
    begin
        update dbo.WEBDASHBOARDLAYOUT set NAME = @NAME,
            DESCRIPTION = @DESCRIPTION,
            CONTENTS = @CONTENTS,
            PREVIEWIMAGE = @PREVIEWIMAGE,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where ID = @ID;
    end
    else
    begin
        if @ID is null
            set @ID = newid();

        insert into dbo.WEBDASHBOARDLAYOUT (ID, 
            NAME, 
            DESCRIPTION, 
            CONTENTS,
            PREVIEWIMAGE,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED)
        values (@ID, 
            @NAME, 
            @DESCRIPTION, 
            @CONTENTS,
            @PREVIEWIMAGE,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            getdate(),
            getdate());
    end;