USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_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	BBNC user was logged in
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN	Processor
@BBNCID	int	IN	NetCommunity ID
@BBNCTRANID	int	IN	NetCommunity transaction ID
@ADDEDBY	nvarchar(255)	IN	Added by hidden
@BBNCDONORNAME	nvarchar(154)	IN	NetCommunity 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(50)	IN	BBNC page name hidden
@ORIGINPAGEID	int	IN	BBNC 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

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_2
(
    @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(50),
    @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
)

as
  set nocount on;

    declare @PDACCOUNTSYSTEMID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BBNCEVENTREGISTRATIONBATCHROW_2
        @ID = @ID,
        @PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_3
        @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

  return 0;