USP_DATAFORMTEMPLATE_ADD_GIFTAIDREFRESHPROCESS

create procedure dbo.USP_DATAFORMTEMPLATE_ADD_GIFTAIDREFRESHPROCESS
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @CURRENTAPPUSERID uniqueidentifier,
    @NAME nvarchar(100) = '',
    @DESCRIPTION nvarchar(255) = '',
    @IDSETREGISTERID uniqueidentifier = null,
    @SITEID uniqueidentifier = 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 = getdate();

begin try
    if (@SITEID is not null) 
    begin
        if dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, @SITEID) = 0 begin
            raiserror ('ERR_SITE_NOACCESS',13,1);
            return 1;
        end
    end

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

    exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD 
        @CHANGEAGENTID = @CHANGEAGENTID, 
        @BUSINESSPROCESSCATALOGID = '9c973934-79a3-4a74-9ea5-fc432cfa7e9d', 
        @BUSINESSPROCESSPARAMETERSETID = @ID, 
        @OWNERID = @CURRENTAPPUSERID, 
        @SITEID = @SITEID;
end try

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

return 0