USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_1_3

The save 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 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

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_1_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
                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime;

                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        set @CURRENTDATE = getdate();

                        begin try
                            exec dbo.USP_BBNC_ENCRYPTGIFTDATA @GIFTINFORMATION = @GIFTINFORMATION output, @KEYISALREADYOPEN = 1;

                            update
                                dbo.BATCHBBNCEVENTREGISTRATION
                            set
                                [DONORID] = @DONORID,
                                [LOGGEDINUSER] = @LOGGEDINUSER,
                                [NETCOMMUNITYTRANSACTIONPROCESSORID] = @NETCOMMUNITYTRANSACTIONPROCESSORID,
                                [BBNCID] = @BBNCID,
                                [BBNCTRANID] = @BBNCTRANID,
                                [ADDEDBY] = @ADDEDBY,
                                [BBNCDONORNAME] = @BBNCDONORNAME,
                                [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,
                                [DONORIDAUTOMATCH] = @DONORIDAUTOMATCH,
                                [DONORSECURITYID] = @DONORSECURITYID,
                                [GUESTSECURITYID] = @GUESTSECURITYID,
                                [SEQUENCE] = @SEQUENCE,
                                [CHANGEDBYID] = @CHANGEAGENTID,
                                [DATECHANGED] = @CURRENTDATE
                            where ID = @ID;

                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                        return 0;