USP_DATAFORMTEMPLATE_ADD_CONSTITUENCYREFRESHPROCESS

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_CONSTITUENCYREFRESHPROCESS
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @CURRENTAPPUSERID uniqueidentifier,
    @NAME nvarchar(100) = '',
    @DESCRIPTION nvarchar(255) = '',
    @CONSTITUENCIES xml = '',
    @INCLUDEALLUSERDEFINEDCONSTITUENCIES bit = 1,
    @IDSETREGISTERID uniqueidentifier = null
)
as
    set nocount on;

    declare @CURRENTDATE datetime;

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

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

    set @CURRENTDATE = getdate();

    begin try
        insert into dbo.CONSTITUENCYREFRESHPROCESS
        (
            ID,
            NAME,
            DESCRIPTION,
            IDSETREGISTERID,
            INCLUDEALLUSERDEFINEDCONSTITUENCIES,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED
        )
        values
        (
            @ID,
            @NAME,
            @DESCRIPTION,
            @IDSETREGISTERID,
            @INCLUDEALLUSERDEFINEDCONSTITUENCIES,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @CURRENTDATE,
            @CURRENTDATE
        );

        exec dbo.USP_CONSTITUENCYREFRESHPROCESS_GETCONSTITUENCIES_ADDFROMXML @CONSTITUENCYREFRESHPROCESSID = @ID,
                                                                            @XML = @CONSTITUENCIES,
                                                                            @CHANGEAGENTID = @CHANGEAGENTID,
                                                                            @CHANGEDATE = @CURRENTDATE;

        exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD @CHANGEAGENTID = @CHANGEAGENTID, 
                                                @BUSINESSPROCESSCATALOGID = '138ffc16-980c-41da-87ee-eb5c26b0238e', 
                                                @BUSINESSPROCESSPARAMETERSETID = @ID, 
                                                @OWNERID = @CURRENTAPPUSERID;

    end try

    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;