USP_DATAFORMTEMPLATE_ADD_WIDGETGALLERY

The save procedure used by the add dataform template "Widget Gallery Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@WIDGETID	int	IN	WidgetID
@NAME	nvarchar(250)	IN	Name
@DESCRIPTION	nvarchar(1000)	IN	Description
@DEFAULTTEXT	nvarchar(4000)	IN	DefaultText
@ISACTIVE	bit	IN	IsActive
@PARENTWIDGETID	int	IN	ParentWidgetID

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_WIDGETGALLERY
                (
                    @ID uniqueidentifier = null output,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @WIDGETID int,
                    @NAME nvarchar(250),
                    @DESCRIPTION nvarchar(1000) = '',
                    @DEFAULTTEXT nvarchar(4000) = '',
                    @ISACTIVE bit = 1,
                    @PARENTWIDGETID int = null
                )
                as

                set nocount on;

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

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

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

            --    IF @WIDGETID IS NULL    -- First 9999 are reserved for BB default widgets
            --    SELECT @WIDGETID = ISNULL(MAX(WIDGETID),9999) + 1 FROM dbo.WIDGETGALLERY WHERE WIDGETID > 9999

                begin try
                    -- handle inserting the data
                    insert into dbo.WIDGETGALLERY
                        (ID, WIDGETID, NAME, DESCRIPTION, DEFAULTTEXT, ISACTIVE, PARENTWIDGETID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values
                        (@ID, @WIDGETID, @NAME, @DESCRIPTION, @DEFAULTTEXT, @ISACTIVE, @PARENTWIDGETID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

                return 0