USP_UIWIDGETCATALOG_ADDTOCATEGORY

Assigns a category to a UI widget.

Parameters

Parameter	Parameter Type	Mode
@UIWIDGETCATALOGID	uniqueidentifier	IN
@CATEGORYNAME	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_UIWIDGETCATALOG_ADDTOCATEGORY(
    @UIWIDGETCATALOGID uniqueidentifier,
    @CATEGORYNAME nvarchar(100),
    @CHANGEAGENTID uniqueidentifier = null
)
as
begin
    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    declare @UIWIDGETCATEGORYID uniqueidentifier;

    select @UIWIDGETCATEGORYID = ID from dbo.UIWIDGETCATEGORY where NAME = @CATEGORYNAME;

    if @UIWIDGETCATEGORYID is null
    begin
        set @UIWIDGETCATEGORYID = newid();
        insert into dbo.UIWIDGETCATEGORY (ID, NAME, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
        values (@UIWIDGETCATEGORYID, @CATEGORYNAME, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate());
    end;

    insert into dbo.UIWIDGETCATEGORYLINK (UIWIDGETCATALOGID, UIWIDGETCATEGORYID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values (@UIWIDGETCATALOGID, @UIWIDGETCATEGORYID, @CHANGEAGENTID, @CHANGEAGENTID, getdate(), getdate());

end