USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_3

The save 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 indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DONORID	uniqueidentifier	IN	Linked constituent
@LOGGEDINUSER	bit	IN	Blackbaud Internet Solutions user was logged in
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN	Processor
@BBNCID	int	IN	Blackbaud Internet Solutions ID
@BBNCTRANID	int	IN	Blackbaud Internet Solutions transaction ID
@ADDEDBY	nvarchar(255)	IN	Added by hidden
@BBNCDONORNAME	nvarchar(154)	IN	Blackbaud Internet Solutions donor name
@REGISTRATIONDATE	datetime	IN	Date
@DONORINFORMATION	xml	IN	Biographical
@DONORADDRESSINFORMATION	xml	IN	Billing address
@DONORADDRESSUPDATE	bit	IN	Address update
@DONORADDRESSADD	bit	IN	Address add
@DONORADDRESSMAKEPRIMARY	bit	IN	Make this new address the primary address
@DONORADDRESSTYPECODEID	uniqueidentifier	IN	Previous address type
@PHONETYPES	xml	IN	Phone type codes hidden
@REGISTRATIONS	xml	IN	Registrations
@GUESTS	xml	IN	Guests
@GIFTINFORMATION	xml	IN	Gift information
@ORIGINPAGENAME	nvarchar(1000)	IN	Blackbaud Internet Solutions page name hidden
@ORIGINPAGEID	int	IN	Blackbaud Internet Solutions page ID hidden
@SEQUENCE	int	IN	Sequence
@DONORADDRESSINFORMATIONALLFIELDS	xml	IN	Billing address all fields
@DONORIDAUTOMATCH	nvarchar(255)	IN	Linked constituent auto-match
@DONORINFORMATIONALLFIELDS	xml	IN	Biographical all fields
@ORIGINALDONORID	uniqueidentifier	IN	Original donor ID
@DONORSECURITYID	uniqueidentifier	IN	Donor constituent security group
@GUESTSECURITYID	uniqueidentifier	IN	Donor constituent security group
@DONORSITEID	uniqueidentifier	IN	Donor site
@GUESTSITEID	uniqueidentifier	IN	Guest site
@ADDITIONALDONATION	xml	IN	Additional Donation
@UNPAIDEVENTREGISTRATIONPAYMENT	bit	IN	Unpaid event registration payment
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system
@ATTRIBUTECURRENCYID	uniqueidentifier	IN	Attribute currency

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_3
(@ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @DONORID uniqueidentifier,
                        @LOGGEDINUSER bit,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
                        @BBNCID int,
                        @BBNCTRANID int,
                        @ADDEDBY nvarchar(255),
                        @BBNCDONORNAME nvarchar(154),
                        @REGISTRATIONDATE datetime,
                        @DONORINFORMATION xml,
                        @DONORADDRESSINFORMATION xml,
                        @DONORADDRESSUPDATE bit,
                        @DONORADDRESSADD bit,
                        @DONORADDRESSMAKEPRIMARY bit,
                        @DONORADDRESSTYPECODEID uniqueidentifier,
                        @PHONETYPES xml,
                        @REGISTRATIONS xml,
                        @GUESTS xml,
                        @GIFTINFORMATION xml,
                        @ORIGINPAGENAME nvarchar(1000),
                        @ORIGINPAGEID int,
                        @SEQUENCE int,
                        @DONORADDRESSINFORMATIONALLFIELDS xml,
                        @DONORIDAUTOMATCH nvarchar(255),
                        @DONORINFORMATIONALLFIELDS xml,
                        @ORIGINALDONORID uniqueidentifier,
                        @DONORSECURITYID uniqueidentifier,
                        @GUESTSECURITYID uniqueidentifier,
                        @DONORSITEID uniqueidentifier,
                        @GUESTSITEID uniqueidentifier,
                        @ADDITIONALDONATION xml,
                        @UNPAIDEVENTREGISTRATIONPAYMENT bit,
                        @PDACCOUNTSYSTEMID uniqueidentifier,
                        @ATTRIBUTECURRENCYID uniqueidentifier                        
)
as
begin
    declare @DONORORGANIZATIONID as uniqueidentifier
    declare    @DONORORGANIZATIONIDAUTOMATCH as  nvarchar(255)
    declare @APPEALCAMPAIGNS as xml

    exec USP_DATAFORMTEMPLATE_EDITLOAD_BBNCEVENTREGISTRATIONBATCHROW_2 @ID =@ID,@DONORORGANIZATIONID =@DONORORGANIZATIONID output ,@DONORORGANIZATIONIDAUTOMATCH =@DONORORGANIZATIONIDAUTOMATCH output,@APPEALCAMPAIGNS =@APPEALCAMPAIGNS

    exec USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_4 @ID,
                        @CHANGEAGENTID,
                        @DONORID,
                        @LOGGEDINUSER,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID,
                        @BBNCID,
                        @BBNCTRANID,
                        @ADDEDBY,
                        @BBNCDONORNAME,
                        @REGISTRATIONDATE,
                        @DONORINFORMATION,
                        @DONORADDRESSINFORMATION,
                        @DONORADDRESSUPDATE,
                        @DONORADDRESSADD,
                        @DONORADDRESSMAKEPRIMARY,
                        @DONORADDRESSTYPECODEID,
                        @PHONETYPES,
                        @REGISTRATIONS,
                        @GUESTS,
                        @GIFTINFORMATION,
                        @ORIGINPAGENAME,
                        @ORIGINPAGEID,
                        @SEQUENCE,
                        @DONORADDRESSINFORMATIONALLFIELDS,
                        @DONORIDAUTOMATCH ,
                        @DONORINFORMATIONALLFIELDS ,
                        @ORIGINALDONORID ,
                        @DONORSECURITYID ,
                        @GUESTSECURITYID ,
                        @DONORSITEID ,
                        @GUESTSITEID ,
                        @ADDITIONALDONATION ,
                        @UNPAIDEVENTREGISTRATIONPAYMENT ,
                        @PDACCOUNTSYSTEMID,
                        @ATTRIBUTECURRENCYID ,                        
                        @DONORORGANIZATIONID ,
                        @DONORORGANIZATIONIDAUTOMATCH,
                        @APPEALCAMPAIGNS
end