USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_6

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DONORID	uniqueidentifier	IN
@LOGGEDINUSER	bit	IN
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN
@BBNCID	int	IN
@BBNCTRANID	int	IN
@ADDEDBY	nvarchar(255)	IN
@BBNCDONORNAME	nvarchar(154)	IN
@REGISTRATIONDATE	datetime	IN
@DONORINFORMATION	xml	IN
@DONORADDRESSINFORMATION	xml	IN
@DONORADDRESSUPDATE	bit	IN
@DONORADDRESSADD	bit	IN
@DONORADDRESSMAKEPRIMARY	bit	IN
@DONORADDRESSTYPECODEID	uniqueidentifier	IN
@PHONETYPES	xml	IN
@REGISTRATIONS	xml	IN
@GUESTS	xml	IN
@GIFTINFORMATION	xml	IN
@ORIGINPAGENAME	nvarchar(1000)	IN
@ORIGINPAGEID	int	IN
@SEQUENCE	int	IN
@DONORADDRESSINFORMATIONALLFIELDS	xml	IN
@DONORIDAUTOMATCH	nvarchar(255)	IN
@DONORINFORMATIONALLFIELDS	xml	IN
@ORIGINALDONORID	uniqueidentifier	IN
@DONORSECURITYID	uniqueidentifier	IN
@GUESTSECURITYID	uniqueidentifier	IN
@DONORSITEID	uniqueidentifier	IN
@GUESTSITEID	uniqueidentifier	IN
@ADDITIONALDONATION	xml	IN
@UNPAIDEVENTREGISTRATIONPAYMENT	bit	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	IN
@ATTRIBUTECURRENCYID	uniqueidentifier	IN
@DONORORGANIZATIONID	uniqueidentifier	IN
@DONORORGANIZATIONIDAUTOMATCH	nvarchar(255)	IN
@APPEALCAMPAIGNS	xml	IN
@BATCHSEPARATION	xml	IN
@TRANSACTIONSOURCE	xml	IN
@CONSENT	xml	IN

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCEVENTREGISTRATIONBATCHROW_6
                    (
                        @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,                        
                        @DONORORGANIZATIONID uniqueidentifier,
                        @DONORORGANIZATIONIDAUTOMATCH nvarchar(255),
                        @APPEALCAMPAIGNS XML,
                        @BATCHSEPARATION xml,
                        @TRANSACTIONSOURCE xml,
                        @CONSENT xml
                    )
                    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;

                            declare @ISORGANIZATION as bit 
                        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;

                            declare @UPDATEDGIFTINFORMATION as xml ='<GIFTINFORMATIONS/>';
                            set @UPDATEDGIFTINFORMATION.modify('insert sql:variable("@GIFTINFORMATION") as last into (GIFTINFORMATIONS)[1]') ;
                            set @UPDATEDGIFTINFORMATION.modify('insert sql:variable("@APPEALCAMPAIGNS") as last into (GIFTINFORMATIONS)[1]') ;

                            declare @UPDATEDDONORINFORMATION as xml ='<DONORINFORMATIONS/>';
                            set @UPDATEDDONORINFORMATION.modify('insert sql:variable("@DONORINFORMATION") as last into (DONORINFORMATIONS)[1]') ;
                            set @UPDATEDDONORINFORMATION.modify('insert sql:variable("@BATCHSEPARATION") as last into (DONORINFORMATIONS)[1]') ;
                            set @UPDATEDDONORINFORMATION.modify('insert sql:variable("@TRANSACTIONSOURCE") as last into (DONORINFORMATIONS)[1]') ;

                            update
                                dbo.BATCHBBNCEVENTREGISTRATION
                            set
                                [DONORID] = case when @ISORGANIZATION =1 then @DONORORGANIZATIONID else @DONORID end,
                                [LOGGEDINUSER] = @LOGGEDINUSER,
                                [NETCOMMUNITYTRANSACTIONPROCESSORID] = @NETCOMMUNITYTRANSACTIONPROCESSORID,
                                [BBNCID] = @BBNCID,
                                [BBNCTRANID] = @BBNCTRANID,
                                [ADDEDBY] = @ADDEDBY,
                                [BBNCDONORNAME] = @BBNCDONORNAME,
                                [REGISTRATIONDATE] = @REGISTRATIONDATE,
                                [DONORINFORMATION] = @UPDATEDDONORINFORMATION,
                                [DONORINFORMATIONALLFIELDS] = @DONORINFORMATIONALLFIELDS,
                                [DONORADDRESSINFORMATION] = @DONORADDRESSINFORMATION,
                                [DONORADDRESSINFORMATIONALLFIELDS] = @DONORADDRESSINFORMATIONALLFIELDS,
                                [DONORADDRESSUPDATE] = @DONORADDRESSUPDATE,
                                [DONORADDRESSADD] = @DONORADDRESSADD,
                                [DONORADDRESSMAKEPRIMARY] = @DONORADDRESSMAKEPRIMARY,
                                [DONORADDRESSTYPECODEID] = @DONORADDRESSTYPECODEID,
                                [PHONETYPES] = @PHONETYPES,
                                [REGISTRATIONS] = @REGISTRATIONS,
                                [GUESTS] = @GUESTS,
                                [GIFTINFORMATION] = @UPDATEDGIFTINFORMATION,
                                [ORIGINPAGENAME] = @ORIGINPAGENAME,
                                [ORIGINPAGEID] = @ORIGINPAGEID,
                                [DONORIDAUTOMATCH] =case when @ISORGANIZATION =1 then @DONORORGANIZATIONIDAUTOMATCH else @DONORIDAUTOMATCH end,
                                [DONORSECURITYID] = @DONORSECURITYID,
                                [GUESTSECURITYID] = @GUESTSECURITYID,
                                [DONORSITEID] = @DONORSITEID,
                                [GUESTSITEID] = @GUESTSITEID,
                                [ADDITIONALDONATION] = @ADDITIONALDONATION,
                                [SEQUENCE] = @SEQUENCE,
                                [CHANGEDBYID] = @CHANGEAGENTID,
                                [DATECHANGED] = @CURRENTDATE,
                                [UNPAIDEVENTREGISTRATIONPAYMENT] = @UNPAIDEVENTREGISTRATIONPAYMENT,
                                [PDACCOUNTSYSTEMID] = @PDACCOUNTSYSTEMID,
                                [ATTRIBUTECURRENCYID] = @ATTRIBUTECURRENCYID,
                                [CONSENT] = @CONSENT
                            where ID = @ID;

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

                        return 0;