USP_BBNC_COMMITEVENTREGISTRATIONMAPREGISTRANT

Maps an event registrant from a Blackbaud Internet Solutions event registration transaction to a registrant registration.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@REGISTRANTID	uniqueidentifier	IN
@REGISTRANTREGISTRATIONID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_COMMITEVENTREGISTRATIONMAPREGISTRANT
            (
                @ID uniqueidentifier = null output,
                @REGISTRANTID uniqueidentifier = null,
                @REGISTRANTREGISTRATIONID uniqueidentifier = 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.REGISTRANTREGISTRATIONMAP
                    (
                        ID,
                        REGISTRANTID,
                        REGISTRANTREGISTRATIONID,
                        --Packages are not currently supported by BBNC, REGISTRANTPACKAGEID is null

                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED
                    )
                    values
                    (
                        @ID,
                        @REGISTRANTID,
                        @REGISTRANTREGISTRATIONID,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CHANGEDATE,
                        @CHANGEDATE
                    )
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;