USP_DATAFORMTEMPLATE_EDITLOAD_BBNCEVENTREGISTRATIONBATCHROW_2

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

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
@DONORSITEID	uniqueidentifier	INOUT	Donor site
@GUESTSITEID	uniqueidentifier	INOUT	Guest site
@ADDITIONALDONATION	xml	INOUT	Additional Donation
@UNPAIDEVENTREGISTRATIONPAYMENT	bit	INOUT	Unpaid event registration payment
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT	Account system
@ATTRIBUTECURRENCYID	uniqueidentifier	INOUT	Attribute currency
@DONORORGANIZATIONNAME	nvarchar(154)	INOUT
@DONORORGANIZATIONID	uniqueidentifier	INOUT
@DONORORGANIZATIONIDAUTOMATCH	nvarchar(255)	INOUT
@ISORGANIZATION	bit	INOUT
@APPEALCAMPAIGNS	xml	INOUT
@BATCHSEPARATION	xml	INOUT
@TRANSACTIONSOURCE	xml	INOUT
@CONSENT	xml	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCEVENTREGISTRATIONBATCHROW_2
                    (

                        @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,
                        @DONORSITEID uniqueidentifier = null output,
                        @GUESTSITEID uniqueidentifier = null output,
                        @ADDITIONALDONATION xml = null output,
                        @UNPAIDEVENTREGISTRATIONPAYMENT bit = null output,
                        @PDACCOUNTSYSTEMID uniqueidentifier = null output,
                        @ATTRIBUTECURRENCYID uniqueidentifier = null output,
                        @DONORORGANIZATIONNAME nvarchar(154) = null output,
                        @DONORORGANIZATIONID uniqueidentifier = null output,
                        @DONORORGANIZATIONIDAUTOMATCH nvarchar(255) = null output,
                        @ISORGANIZATION bit = null output,
                        @APPEALCAMPAIGNS xml = null output,
                        @BATCHSEPARATION xml = null output,
                        @TRANSACTIONSOURCE xml = null output,
                        @CONSENT xml = null output
                    )
                    as
                        set nocount on;

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

                        select @ISORGANIZATION = cast(isnull([BATCHBBNCEVENTREGISTRATION].GIFTINFORMATION.exist('/GIFTINFORMATIONS/GIFTINFORMATION[ITEM[FIELDKEY/text() = "ISCORPORATE" and NEWVALUE/text() = "True"]]'),0) as bit)

                        from
                            dbo.BATCHBBNCEVENTREGISTRATION
                        where
                            BATCHBBNCEVENTREGISTRATION.ID = @ID;

                        select
                            @DATALOADED = 1,
                            @DONORID = case when @ISORGANIZATION =0 then [DONORID] else Null end,
                            @ORIGINALDONORID = [DONORID],
                            @LOGGEDINUSER = [LOGGEDINUSER],
                            @NETCOMMUNITYTRANSACTIONPROCESSORID = [NETCOMMUNITYTRANSACTIONPROCESSORID],
                            @BBNCID = [BBNCID],
                            @BBNCTRANID = [BBNCTRANID],
                            @ADDEDBY = [ADDEDBY],
                            @ADDEDBYFORDISPLAY = [ADDEDBY],
                            @BBNCDONORNAME = [BBNCDONORNAME],
                            @DONORNAME = case when @ISORGANIZATION =0 then case when [DONORID] is null then [BBNCDONORNAME] else dbo.UFN_CONSTITUENT_BUILDNAME([DONORID]) end else Null end,
                            @REGISTRATIONDATE = [REGISTRATIONDATE],
                            @DONORINFORMATION = case when DONORINFORMATION.exist('/DONORINFORMATIONS') = 1 
                                                    then 
                                                        case when DONORINFORMATION.exist('/DONORINFORMATIONS/DONORINFORMATION') = 1
                                                             then DONORINFORMATION.query('/DONORINFORMATIONS/DONORINFORMATION')
                                                             else
                                                                null
                                                             end
                                                    else 
                                                        DONORINFORMATION
                                                    end,
                            @DONORINFORMATIONALLFIELDS = [DONORINFORMATIONALLFIELDS],
                            @DONORADDRESSINFORMATION = [DONORADDRESSINFORMATION],
                            @DONORADDRESSINFORMATIONALLFIELDS = [DONORADDRESSINFORMATIONALLFIELDS],
                            @DONORADDRESSUPDATE = [DONORADDRESSUPDATE],
                            @DONORADDRESSADD = [DONORADDRESSADD],
                            @DONORADDRESSMAKEPRIMARY = [DONORADDRESSMAKEPRIMARY],
                            @DONORADDRESSTYPECODEID = [DONORADDRESSTYPECODEID],
                            @PHONETYPES = [PHONETYPES],
                            @REGISTRATIONS = [REGISTRATIONS],
                            @GUESTS = [GUESTS],
                            @GIFTINFORMATION = case when GIFTINFORMATION.exist('/GIFTINFORMATIONS') = 1 
                                                    then 
                                                        case when GIFTINFORMATION.exist('/GIFTINFORMATIONS/GIFTINFORMATION') = 1
                                                             then GIFTINFORMATION.query('/GIFTINFORMATIONS/GIFTINFORMATION')
                                                             else
                                                                null
                                                             end
                                                    else 
                                                        GIFTINFORMATION
                                                    end,
                            @ORIGINPAGENAME = [ORIGINPAGENAME],
                            @ORIGINPAGEID = [ORIGINPAGEID],
                            @ORIGINPAGENAMEFORDISPLAY = [ORIGINPAGENAME],
                            @ORIGINPAGEIDFORDISPLAY = [ORIGINPAGEID],
                            @DONORIDAUTOMATCH = case when @ISORGANIZATION =0 then [DONORIDAUTOMATCH] else Null end,
                            @DONORSECURITYID = [DONORSECURITYID],
                            @GUESTSECURITYID = [GUESTSECURITYID],
                            @DONORSITEID = [DONORSITEID],
                            @GUESTSITEID = [GUESTSITEID],
                            @ADDITIONALDONATION = [ADDITIONALDONATION],
                            @UNPAIDEVENTREGISTRATIONPAYMENT = [UNPAIDEVENTREGISTRATIONPAYMENT],
                            @SEQUENCE = [BATCHBBNCEVENTREGISTRATION].[SEQUENCE],
                            @TSLONG = [BATCHBBNCEVENTREGISTRATION].[TSLONG],
                            @PDACCOUNTSYSTEMID = [BATCHBBNCEVENTREGISTRATION].[PDACCOUNTSYSTEMID],
                            @ATTRIBUTECURRENCYID = [BATCHBBNCEVENTREGISTRATION].[ATTRIBUTECURRENCYID],
                            @DONORORGANIZATIONID = case when @ISORGANIZATION =1 then [DONORID] else Null end,
                            @DONORORGANIZATIONNAME =case when @ISORGANIZATION =1 then  case when [DONORID] is null then [BBNCDONORNAME] else dbo.UFN_CONSTITUENT_BUILDNAME([DONORID]) end else Null end,
                            @DONORORGANIZATIONIDAUTOMATCH = case when @ISORGANIZATION =1 then [DONORIDAUTOMATCH] else Null end,
                            @APPEALCAMPAIGNS = case when GIFTINFORMATION.exist('/GIFTINFORMATIONS') = 1 
                                                    then 
                                                        case when GIFTINFORMATION.exist('/GIFTINFORMATIONS/APPEALCAMPAIGNS') = 1
                                                             then GIFTINFORMATION.query('/GIFTINFORMATIONS/APPEALCAMPAIGNS')
                                                             else
                                                                null
                                                             end
                                                    else 
                                                        null
                                                    end,
                         @BATCHSEPARATION = case when DONORINFORMATION.exist('/DONORINFORMATIONS') = 1 
                                                    then 
                                                        case when DONORINFORMATION.exist('/DONORINFORMATIONS/BATCHSEPARATION') = 1
                                                             then DONORINFORMATION.query('/DONORINFORMATIONS/BATCHSEPARATION')
                                                             else
                                                                null
                                                    end
                                                    else 
                                                        null
                                                    end,
                     @TRANSACTIONSOURCE = case when DONORINFORMATION.exist('/DONORINFORMATIONS') = 1 
                                                    then 
                                                        case when DONORINFORMATION.exist('/DONORINFORMATIONS/TRANSACTIONSOURCE') = 1
                                                             then DONORINFORMATION.query('/DONORINFORMATIONS/TRANSACTIONSOURCE')
                                                             else
                                                                null
                                                    end
                                                    else 
                                                        null
                                                    end,
                                                 @CONSENT= CONSENT
                        from
                            dbo.BATCHBBNCEVENTREGISTRATION
                        where
                            BATCHBBNCEVENTREGISTRATION.ID = @ID;

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

                        return 0;