USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_1_1

The save procedure used by the edit dataform template "NetCommunity Event Registration Batch Row Edit Form 1.1".

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
@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	Address add make primary
@DONORADDRESSTYPECODEID	uniqueidentifier	IN	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

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_1_1
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @DONORID uniqueidentifier,
                        @LOGGEDINUSER bit,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
                        @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
                    )
                    as
                        set nocount on;

                        declare @CURRENTDATE datetime;

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

                        set @CURRENTDATE = getdate();

                        begin try
                            update
                                dbo.BATCHBBNCEVENTREGISTRATION
                            set
                                [DONORID] = @DONORID,
                                [LOGGEDINUSER] = @LOGGEDINUSER,
                                [NETCOMMUNITYTRANSACTIONPROCESSORID] = @NETCOMMUNITYTRANSACTIONPROCESSORID,
                                [BBNCTRANID] = @BBNCTRANID,
                                [ADDEDBY] = @ADDEDBY,
                                [BBNCDONORNAME] = @BBNCDONORNAME,
                                [REGISTRATIONDATE] = @REGISTRATIONDATE,
                                [DONORINFORMATION] = @DONORINFORMATION,
                                [DONORADDRESSINFORMATION] = @DONORADDRESSINFORMATION,
                                [DONORADDRESSINFORMATIONALLFIELDS] = @DONORADDRESSINFORMATIONALLFIELDS,
                                [DONORADDRESSUPDATE] = @DONORADDRESSUPDATE,
                                [DONORADDRESSADD] = @DONORADDRESSADD,
                                [DONORADDRESSMAKEPRIMARY] = @DONORADDRESSMAKEPRIMARY,
                                [DONORADDRESSTYPECODEID] = @DONORADDRESSTYPECODEID,
                                [PHONETYPES] = @PHONETYPES,
                                [REGISTRATIONS] = @REGISTRATIONS,
                                [GUESTS] = @GUESTS,
                                [GIFTINFORMATION] = @GIFTINFORMATION,
                                [ORIGINPAGENAME] = @ORIGINPAGENAME,
                                [ORIGINPAGEID] = @ORIGINPAGEID,
                                [SEQUENCE] = @SEQUENCE,
                                [CHANGEDBYID] = @CHANGEAGENTID,
                                [DATECHANGED] = @CURRENTDATE
                            where ID = @ID;

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

                        return 0;