USP_LISTBUILDERINSTANCE_CREATEORUPDATEDEFINITION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@PAGEID	uniqueidentifier	IN
@TABID	uniqueidentifier	IN
@SECTIONID	uniqueidentifier	IN
@QUERYDEFINITIONXML	xml	IN
@APPUSERID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
Definition

Copy


        create procedure dbo.USP_LISTBUILDERINSTANCE_CREATEORUPDATEDEFINITION
        (
            @ID uniqueidentifier,
            @NAME nvarchar(100),
            @DESCRIPTION nvarchar(255),
            @PAGEID uniqueidentifier,
            @TABID uniqueidentifier,
            @SECTIONID uniqueidentifier,
            @QUERYDEFINITIONXML xml,
            @APPUSERID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier
        )
        as
        begin

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

            declare @CURRENTDATE datetime = getdate();

            if not exists(select 1 from dbo.LISTBUILDERINSTANCE where ID = @ID)
            begin

                -- Insert new

                insert into dbo.LISTBUILDERINSTANCE
                (
                    ID,
                    NAME,
                    DESCRIPTION,
                    PAGEID,
                    TABID,
                    SECTIONID,
                    QUERYDEFINITIONXML,
                    ADDEDBYID,
                    CHANGEDBYID,
                    DATEADDED,
                    DATECHANGED
                )
                values
                (
                    @ID,
                    @NAME,
                    @DESCRIPTION,
                    @PAGEID,
                    @TABID,
                    @SECTIONID,
                    @QUERYDEFINITIONXML,
                    @CHANGEAGENTID,
                    @CHANGEAGENTID,
                    @CURRENTDATE,
                    @CURRENTDATE
                );

            end

            else
            begin
                -- Update existing


                update dbo.LISTBUILDERINSTANCE
                set
                    NAME = @NAME,
                    DESCRIPTION = @DESCRIPTION,
                    PAGEID = @PAGEID,
                    TABID = @TABID,
                    SECTIONID = @SECTIONID,
                    QUERYDEFINITIONXML = @QUERYDEFINITIONXML,
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where ID = @ID;
            end

        end