USP_DATAFORMTEMPLATE_EDITLOAD_BBNCEVENTREGISTRATIONBATCHROW_1_3

The load procedure used by the edit dataform template "NetCommunity Event Registration Batch Row Edit Form 1.3"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DONORID	uniqueidentifier	INOUT	Linked constituent
@LOGGEDINUSER	bit	INOUT	Blackbaud Internet Solutions user was logged in
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	INOUT	Processor
@BBNCID	int	INOUT	Blackbaud Internet Solutions ID
@BBNCTRANID	int	INOUT	Blackbaud Internet Solutions transaction ID
@ADDEDBY	nvarchar(255)	INOUT	Added by hidden
@ADDEDBYFORDISPLAY	nvarchar(255)	INOUT	Added by
@BBNCDONORNAME	nvarchar(154)	INOUT	Blackbaud Internet Solutions donor name
@DONORNAME	nvarchar(154)	INOUT	Donor name
@REGISTRATIONDATE	datetime	INOUT	Date
@DONORINFORMATION	xml	INOUT	Biographical
@DONORADDRESSINFORMATION	xml	INOUT	Billing address
@DONORADDRESSUPDATE	bit	INOUT	Address update
@DONORADDRESSADD	bit	INOUT	Address add
@DONORADDRESSMAKEPRIMARY	bit	INOUT	Make this new address the primary address
@DONORADDRESSTYPECODEID	uniqueidentifier	INOUT	Previous address type
@PHONETYPES	xml	INOUT	Phone type codes hidden
@REGISTRATIONS	xml	INOUT	Registrations
@GUESTS	xml	INOUT	Guests
@GIFTINFORMATION	xml	INOUT	Gift information
@ORIGINPAGENAME	nvarchar(1000)	INOUT	Blackbaud Internet Solutions page name hidden
@ORIGINPAGEID	int	INOUT	Blackbaud Internet Solutions page ID hidden
@ORIGINPAGENAMEFORDISPLAY	nvarchar(1000)	INOUT	Blackbaud Internet Solutions page name
@ORIGINPAGEIDFORDISPLAY	int	INOUT	Blackbaud Internet Solutions page ID
@SEQUENCE	int	INOUT	Sequence
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@DONORADDRESSINFORMATIONALLFIELDS	xml	INOUT	Billing address all fields
@DONORIDAUTOMATCH	nvarchar(255)	INOUT	Linked constituent auto-match
@DONORINFORMATIONALLFIELDS	xml	INOUT	Biographical all fields
@ORIGINALDONORID	uniqueidentifier	INOUT	Original donor ID
@DONORSECURITYID	uniqueidentifier	INOUT	Donor constituent security group
@GUESTSECURITYID	uniqueidentifier	INOUT	Donor constituent security group

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCEVENTREGISTRATIONBATCHROW_1_3
                    (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @DONORID uniqueidentifier = null output,
                        @LOGGEDINUSER bit = null output,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier = null output,
                        @BBNCID int = null output,
                        @BBNCTRANID int = null output,
                        @ADDEDBY nvarchar(255) = null output,
                        @ADDEDBYFORDISPLAY nvarchar(255) = null output,
                        @BBNCDONORNAME nvarchar(154) = null output,
                        @DONORNAME nvarchar(154) = null output,
                        @REGISTRATIONDATE datetime = null output,
                        @DONORINFORMATION xml = null output,
                        @DONORADDRESSINFORMATION xml = null output,
                        @DONORADDRESSUPDATE bit = null output,
                        @DONORADDRESSADD bit = null output,
                        @DONORADDRESSMAKEPRIMARY bit = null output,
                        @DONORADDRESSTYPECODEID uniqueidentifier = null output,
                        @PHONETYPES xml = null output,
                        @REGISTRATIONS xml = null output,
                        @GUESTS xml = null output,
                        @GIFTINFORMATION xml = null output,
                        @ORIGINPAGENAME nvarchar(1000) = null output,
                        @ORIGINPAGEID int = null output,
                        @ORIGINPAGENAMEFORDISPLAY nvarchar(1000) = null output,
                        @ORIGINPAGEIDFORDISPLAY int = null output,
                        @SEQUENCE int = null output,
                        @TSLONG bigint = 0 output,
                        @DONORADDRESSINFORMATIONALLFIELDS xml = null output,
                        @DONORIDAUTOMATCH nvarchar(255) = null output,
                        @DONORINFORMATIONALLFIELDS xml = null output,
                        @ORIGINALDONORID uniqueidentifier = null output,
                        @DONORSECURITYID uniqueidentifier = null output,
                        @GUESTSECURITYID uniqueidentifier = null output
                    )
                    as
                        set nocount on;

                        set @DATALOADED = 0;
                        set @TSLONG = 0;

                        select
                            @DATALOADED = 1,
                            @DONORID = [DONORID],
                            @ORIGINALDONORID = [DONORID],
                            @LOGGEDINUSER = [LOGGEDINUSER],
                            @NETCOMMUNITYTRANSACTIONPROCESSORID = [NETCOMMUNITYTRANSACTIONPROCESSORID],
                            @BBNCID = [BBNCID],
                            @BBNCTRANID = [BBNCTRANID],
                            @ADDEDBY = [ADDEDBY],
                            @ADDEDBYFORDISPLAY = [ADDEDBY],
                            @BBNCDONORNAME = [BBNCDONORNAME],
                            @DONORNAME = case when [DONORID] is null then [BBNCDONORNAME] else dbo.UFN_CONSTITUENT_BUILDNAME([DONORID]) end,
                            @REGISTRATIONDATE = [REGISTRATIONDATE],
                            @DONORINFORMATION = [DONORINFORMATION],
                            @DONORINFORMATIONALLFIELDS = [DONORINFORMATIONALLFIELDS],
                            @DONORADDRESSINFORMATION = [DONORADDRESSINFORMATION],
                            @DONORADDRESSINFORMATIONALLFIELDS = [DONORADDRESSINFORMATIONALLFIELDS],
                            @DONORADDRESSUPDATE = [DONORADDRESSUPDATE],
                            @DONORADDRESSADD = [DONORADDRESSADD],
                            @DONORADDRESSMAKEPRIMARY = [DONORADDRESSMAKEPRIMARY],
                            @DONORADDRESSTYPECODEID = [DONORADDRESSTYPECODEID],
                            @PHONETYPES = [PHONETYPES],
                            @REGISTRATIONS = [REGISTRATIONS],
                            @GUESTS = [GUESTS],
                            @GIFTINFORMATION = [GIFTINFORMATION],
                            @ORIGINPAGENAME = [ORIGINPAGENAME],
                            @ORIGINPAGEID = [ORIGINPAGEID],
                            @ORIGINPAGENAMEFORDISPLAY = [ORIGINPAGENAME],
                            @ORIGINPAGEIDFORDISPLAY = [ORIGINPAGEID],
                            @DONORIDAUTOMATCH = [DONORIDAUTOMATCH],
                            @DONORSECURITYID = [DONORSECURITYID],
                            @GUESTSECURITYID = [GUESTSECURITYID],
                            @SEQUENCE = [BATCHBBNCEVENTREGISTRATION].[SEQUENCE],
                            @TSLONG = [BATCHBBNCEVENTREGISTRATION].[TSLONG]
                        from
                            dbo.BATCHBBNCEVENTREGISTRATION
                        where
                            BATCHBBNCEVENTREGISTRATION.ID = @ID;

                        exec dbo.USP_BBNC_DECRYPTGIFTDATA @GIFTINFORMATION = @GIFTINFORMATION output, @KEYISALREADYOPEN = 1;

                        return 0;