USP_BBNC_COMMITEVENTREGISTRATIONMARKREGISTRANTWILLATTEND

Update a registrant marking them as will attend if they are not already marked as such based on information from an event registration Blackbaud Internet Solutions transaction.

Parameters

Parameter	Parameter Type	Mode
@REGISTRANTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_COMMITEVENTREGISTRATIONMARKREGISTRANTWILLATTEND
            (
                @REGISTRANTID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
                set nocount on;

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

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

                begin try
                    update dbo.REGISTRANT set
                        [WILLNOTATTEND] = 0,
                        [CHANGEDBYID] = @CHANGEAGENTID,
                        [DATECHANGED] = @CHANGEDATE
                    where
                        [ID] = @REGISTRANTID
                        and [WILLNOTATTEND] = 1;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;