USP_DATAFORMTEMPLATE_ADD_PLEDGEREMINDERPROCESS_3

The save procedure used by the add dataform template "Pledge Reminder Process Add Form 3".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@DESCRIPTION	nvarchar(255)	IN	Description
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN	Selection type
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@DATETYPECODE	tinyint	IN	Calculate amounts as of
@DATE	datetime	IN	Process date
@BUSINESSPROCESSVIEWID	uniqueidentifier	IN	Output format
@LETTERFILENAME	nvarchar(255)	IN	Letter template
@LETTERFILE	varbinary	IN	File
@LABELFILENAME	nvarchar(255)	IN	Label template
@LABELFILE	varbinary	IN	LABELFILE
@MARKREMINDERSSENT	bit	IN	Mark reminders sent when process completes
@SENTDATETYPECODE	tinyint	IN	Sent date
@SENTDATE	datetime	IN	Sent date
@EXCLUSIONDATETYPECODE	tinyint	IN	Consider exclusions as of
@EXCLUSIONASOFDATE	datetime	IN	Consider exclusions as of
@EXCLUDEDECEASED	bit	IN	Exclude deceased constituents
@EXCLUDEINACTIVE	bit	IN	Exclude inactive constituents
@EXCLUSIONS	xml	IN	Exclusions
@CUSTOMPARAMETERDATAFORMITEM	xml	IN
@ISRECURRINGGIFTS	bit	IN
@ISPLEDGES	bit	IN
@OUTPUTGROUPINGCODE	tinyint	IN	Output grouping
@EXPORTDEFINITIONID	uniqueidentifier	IN	Export definition
@SITEID	uniqueidentifier	IN	Site

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PLEDGEREMINDERPROCESS_3
                    (
                        @ID uniqueidentifier = null output,        
                        @CURRENTAPPUSERID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,    
                        @NAME nvarchar(100)='', 
                        @IDSETREGISTERID uniqueidentifier = null, 
                        @DESCRIPTION nvarchar(255)='', 
                        @CREATEOUTPUTIDSET bit = 0,
                        @OUTPUTIDSETRECORDTYPEID uniqueidentifier = null,
                        @OUTPUTIDSETNAME nvarchar(100) = '', 
                        @OVERWRITEOUTPUTIDSET bit = 0,
                        @DATETYPECODE tinyint = 0,
                        @DATE datetime = null,                        
                        @BUSINESSPROCESSVIEWID uniqueidentifier = null,
                        @LETTERFILENAME nvarchar(255) = null,
                        @LETTERFILE varbinary(max) = null,
                        @LABELFILENAME nvarchar(255) = null,
                        @LABELFILE varbinary(max) = null,
                        @MARKREMINDERSSENT bit = 0,
                        @SENTDATETYPECODE tinyint = 0,
                        @SENTDATE datetime = null,
                        @EXCLUSIONDATETYPECODE tinyint = 0,
                        @EXCLUSIONASOFDATE datetime = null,
                        @EXCLUDEDECEASED bit = 1,
                        @EXCLUDEINACTIVE bit = 1,
                        @EXCLUSIONS xml = null,
                        @CUSTOMPARAMETERDATAFORMITEM xml = null,
                        --@OVERRIDEREQUIREDEXCLUSIONS bit = 0,

                        --@REQUIREDEXCLUSIONS xml = null

                        @ISRECURRINGGIFTS bit = 0,
                        @ISPLEDGES bit = 0,
                        @OUTPUTGROUPINGCODE tinyint = 0,
                        @EXPORTDEFINITIONID uniqueidentifier = null,
                        @SITEID 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();

                        if @DATE is null
                            set @DATE = getdate();

                        begin try

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

                            insert into dbo.PLEDGEREMINDERPROCESS
                                (ID, NAME, DESCRIPTION, IDSETREGISTERID, CREATEOUTPUTIDSET, OUTPUTIDSETRECORDTYPEID, OUTPUTIDSETNAME, OVERWRITEOUTPUTIDSET, DATETYPECODE, DATE, BUSINESSPROCESSVIEWID, LETTERFILENAME, LETTERFILE, LABELFILENAME, LABELFILE, MARKREMINDERSSENT, SENTDATETYPECODE, SENTDATE, ISRECURRINGGIFTS, ISPLEDGES, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, CUSTOMPARAMETERDATAFORMITEM, OUTPUTGROUPINGCODE, EXPORTDEFINITIONID)
                            values
                                (@ID, @NAME, @DESCRIPTION, @IDSETREGISTERID, @CREATEOUTPUTIDSET, @OUTPUTIDSETRECORDTYPEID, @OUTPUTIDSETNAME, @OVERWRITEOUTPUTIDSET, @DATETYPECODE, @DATE, @BUSINESSPROCESSVIEWID, @LETTERFILENAME, @LETTERFILE, @LABELFILENAME, @LABELFILE, @MARKREMINDERSSENT, @SENTDATETYPECODE, @SENTDATE, @ISRECURRINGGIFTS, @ISPLEDGES, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE, @CUSTOMPARAMETERDATAFORMITEM, @OUTPUTGROUPINGCODE, @EXPORTDEFINITIONID);

                                exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD @CHANGEAGENTID = @CHANGEAGENTID, 
                                                                        @BUSINESSPROCESSCATALOGID = '84414BD2-3196-4697-998A-2493C29A302A', 
                                                                        @BUSINESSPROCESSPARAMETERSETID = @ID, 
                                                                        @OWNERID = @CURRENTAPPUSERID,
                                                                        @SITEID = @SITEID;

                                exec dbo.USP_BUSINESSPROCESSCOMMPREF_ADD @CHANGEAGENTID = @CHANGEAGENTID,
                                                                        @BUSINESSPROCESSCATALOGID = '84414BD2-3196-4697-998A-2493C29A302A',
                                                                        @BUSINESSPROCESSPARAMETERSETID = @ID,
                                                                        @EXCLUSIONDATETYPECODE = @EXCLUSIONDATETYPECODE,
                                                                        @EXCLUSIONASOFDATE = @EXCLUSIONASOFDATE,
                                                                        @EXCLUDEDECEASED = @EXCLUDEDECEASED,
                                                                        @EXCLUDEINACTIVE = @EXCLUDEINACTIVE,
                                                                        @EXCLUSIONS = @EXCLUSIONS,
                                                                        --@OVERRIDEREQUIREDEXCLUSIONS = @OVERRIDEREQUIREDEXCLUSIONS,

                                                                        --@REQUIREDEXCLUSIONS = @REQUIREDEXCLUSIONS,

                                                                        @CURRENTAPPUSERID = @CURRENTAPPUSERID;

                        end try

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

                        return 0;