USP_BBNC_COMMITEVENTREGISTRATIONREGISTRANT

Adds an event registrant from a Blackbaud Internet Solutions event registration transaction to the system from a given batch.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CONSTITUENTID	uniqueidentifier	IN
@EVENTID	uniqueidentifier	IN
@GUESTOFREGISTRANTID	uniqueidentifier	IN
@WILLNOTATTEND	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
Definition

Copy


            CREATE procedure dbo.USP_BBNC_COMMITEVENTREGISTRATIONREGISTRANT
            (
                @ID uniqueidentifier = null output,
                @CONSTITUENTID uniqueidentifier = null,
                @EVENTID uniqueidentifier = null,
                @GUESTOFREGISTRANTID uniqueidentifier = null,
                @WILLNOTATTEND bit = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
                set nocount on;

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

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

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

                begin try
                    insert into dbo.REGISTRANT
                    (
                        ID,
                        CONSTITUENTID,
                        EVENTID,
                        GUESTOFREGISTRANTID,
                        WILLNOTATTEND,
                        ONLINEREGISTRANT,
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    )
                    values
                    (
                        @ID,
                        @CONSTITUENTID,
                        @EVENTID,
                        @GUESTOFREGISTRANTID,
                        @WILLNOTATTEND,
                        1, --Online registrant

                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CHANGEDATE,
                        @CHANGEDATE
                    )

                    --Default event restriction options for added registrants

                    insert into dbo.REGISTRANTRESTRICTIONOPTION(REGISTRANTID, EVENTRESTRICTIONOPTIONID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                        select
                            @ID,
                            CONSTITUENTRESTRICTIONOPTION.EVENTRESTRICTIONOPTIONID,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CHANGEDATE,
                            @CHANGEDATE
                        from dbo.CONSTITUENTRESTRICTIONOPTION
                        where CONSTITUENTRESTRICTIONOPTION.CONSTITUENTID = @CONSTITUENTID;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;