USP_DATAFORMTEMPLATE_EDIT_BBNCDONATIONBATCHROW_6

The save procedure used by the edit dataform template "NetCommunity Donation Batch Row Edit Form 4".

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.
@NETCOMMUNITYTRANSACTIONPROCESSORID	uniqueidentifier	IN	Processor
@BBNCID	int	IN	Blackbaud Internet Solutions ID
@BBNCTRANID	int	IN	Blackbaud Internet Solutions transaction ID
@ORIGINPAGE	nvarchar(1000)	IN	Origin page
@ORIGINPAGEID	int	IN	Origin page ID
@ORIGINAPPEALID	uniqueidentifier	IN	Origin appeal ID
@ADDEDBY	nvarchar(255)	IN	Added by hidden
@DONORID	uniqueidentifier	IN	Individual
@LOGGEDINUSER	bit	IN	Blackbaud Internet Solutions user was logged in
@CORPORATEDONORID	uniqueidentifier	IN	Organization
@APPEALID	uniqueidentifier	IN	Appeal
@ISTEAMFUNDRAISINGOFFLINEGIFT	bit	IN	Offline gift
@DONORINFORMATION	xml	IN	Donor information
@DONORADDRESSINFORMATION	xml	IN	Donor address information
@DONORADDRESSINFORMATIONALLFIELDS	xml	IN	Donor address information all fields
@PHONETYPES	xml	IN	Phone type codes hidden
@GIFTINFORMATION	xml	IN	Gift information
@GIFTATTRIBUTEINFORMATION	xml	IN	Attribute information
@MGINFORMATIONFROMMFO	bit	IN	From MatchFinder Online
@MGINFORMATION	xml	IN	Matching gift information
@MGCONSTITUENTID	uniqueidentifier	IN	Matching gift constituent
@DONORADDRESSINFORMATIONUPDATE	bit	IN	Update address information
@DONORADDRESSINFORMATIONCREATENEW	bit	IN	Create new address
@DONORADDRESSINFORMATIONMAKEPRIMARY	bit	IN	Make address primary
@DONORADDRESSINFORMATIONADDRESSTYPECODEID	uniqueidentifier	IN	Previous address type
@DONOTRECEIPT	bit	IN	Do not receipt
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@UPDATEMGINFORMATIONFROMMFO	bit	IN	Update MG Info from MFO
@SOLICITORS	xml	IN	Solicitors
@SPLITS	xml	IN	Splits
@DONORIDAUTOMATCH	nvarchar(255)	IN	Individual auto-match
@CORPORATEDONORIDAUTOMATCH	nvarchar(255)	IN	Corporate donor auto-match
@MGCONSTITUENTIDAUTOMATCH	nvarchar(255)	IN	MG auto-match
@DONORINFORMATIONALLFIELDS	xml	IN	Donor information all fields
@ORIGINALDONORID	uniqueidentifier	IN	Original individual
@ORIGINALCORPORATEDONORID	uniqueidentifier	IN	Original organization
@DONORSECURITYID	uniqueidentifier	IN	Donor constituent security group
@CORPORATEDONORSECURITYID	uniqueidentifier	IN	Corporate donor security group
@MGCOMPANYSECURITYID	uniqueidentifier	IN	Matching gift company security group
@TRIBUTENAME	nvarchar(500)	IN	Tribute name
@TRIBUTEDESCRIPTION	nvarchar(500)	IN	Tribute description
@TRIBUTETYPECODEID	uniqueidentifier	IN	Tribute type
@TRIBUTEID	uniqueidentifier	IN	Tribute
@APPLYTRIBUTETODONATION	bit	IN	Apply tribute to donation
@ADDTRIBUTEACKNOWLEDGEE	bit	IN	Add acknowledgee to tribute
@TRIBUTEACKNOWLEDGEESECURITYID	uniqueidentifier	IN	Tribute acknowledgee security group
@UPDATETRIBUTEACKNOWLEDGEEADDRESS	bit	IN	Update acknowledgee's address
@TRIBUTEACKNOWLEDGEENAME	nvarchar(250)	IN	Acknowledgee name
@TRIBUTEACKNOWLEDGEEEMAIL	nvarchar(100)	IN	Acknowledgee email
@TRIBUTEACKNOWLEDGEESTREETADDRESS	nvarchar(300)	IN	Acknowledgee address
@TRIBUTEACKNOWLEDGEECITY	nvarchar(100)	IN	Acknowledgee city
@TRIBUTEACKNOWLEDGEESTATE	nvarchar(100)	IN	Acknowledgee state
@TRIBUTEACKNOWLEDGEEPOSTCODE	nvarchar(12)	IN	Acknowledgee post code
@TRIBUTEACKNOWLEDGEECOUNTRY	nvarchar(100)	IN	Acknowledgee country
@TRIBUTEACKNOWLEDGEEPHONE	nvarchar(100)	IN	Acknowledgee phone
@TRIBUTEACKNOWLEDGEELINKID	uniqueidentifier	IN	Existing constituent
@DONORSITEID	uniqueidentifier	IN	Donor site
@CORPORATEDONORSITEID	uniqueidentifier	IN	Corporate donor site
@MGCOMPANYSITEID	uniqueidentifier	IN	Matching gift company site
@TRIBUTEACKNOWLEDGEESITEID	uniqueidentifier	IN	Tribute acknowledgee site
@REMOVESPOUSE	bit	IN	Remove Spouse
@SPOUSEINFORMATION	xml	IN	Spouse information
@SAMESPOUSE	bit	IN	Update the existing spouse with the downloaded information
@SPOUSELINKID	uniqueidentifier	IN	Spouse
@SPOUSEOLDNAME	nvarchar(200)	IN	Previous spouse
@SPOUSESECURITYID	uniqueidentifier	IN	Spouse constituent security group
@SPOUSESITEID	uniqueidentifier	IN	Spouse site
@SEQUENCE	int	IN	Sequence
@APPLICATIONS	xml	IN	Applications
@PDACCOUNTSYSTEMID	uniqueidentifier	IN	Account system
@ATTRIBUTECURRENCYID	uniqueidentifier	IN	Attribute currency
@CATEGORYCODEID	uniqueidentifier	IN	Revenue category

Definition

Copy


                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDONATIONBATCHROW_6
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,
                        @NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
                        @BBNCID int,
                        @BBNCTRANID int,
                        @ORIGINPAGE nvarchar(1000),
                        @ORIGINPAGEID int,
                        @ORIGINAPPEALID uniqueidentifier,
                        @ADDEDBY nvarchar(255),
                        @DONORID uniqueidentifier,
                        @LOGGEDINUSER bit,
                        @CORPORATEDONORID uniqueidentifier,
                        @APPEALID uniqueidentifier,
                        @ISTEAMFUNDRAISINGOFFLINEGIFT bit,
                        @DONORINFORMATION xml,
                        @DONORADDRESSINFORMATION xml,
                        @DONORADDRESSINFORMATIONALLFIELDS xml,
                        @PHONETYPES xml,
                        @GIFTINFORMATION xml,
                        @GIFTATTRIBUTEINFORMATION xml,
                        @MGINFORMATIONFROMMFO bit,
                        @MGINFORMATION xml,
                        @MGCONSTITUENTID uniqueidentifier,

                        @DONORADDRESSINFORMATIONUPDATE bit,
                        @DONORADDRESSINFORMATIONCREATENEW bit,
                        @DONORADDRESSINFORMATIONMAKEPRIMARY bit,
                        @DONORADDRESSINFORMATIONADDRESSTYPECODEID uniqueidentifier,
                        @DONOTRECEIPT bit,
                        @DONOTACKNOWLEDGE bit,
                        @UPDATEMGINFORMATIONFROMMFO bit,

                        @SOLICITORS xml,
                        @SPLITS xml,

                        @DONORIDAUTOMATCH nvarchar(255),
                        @CORPORATEDONORIDAUTOMATCH nvarchar(255),
                        @MGCONSTITUENTIDAUTOMATCH nvarchar(255),

                        @DONORINFORMATIONALLFIELDS xml,
                        @ORIGINALDONORID uniqueidentifier,
                        @ORIGINALCORPORATEDONORID uniqueidentifier,

                        @DONORSECURITYID uniqueidentifier,
                        @CORPORATEDONORSECURITYID uniqueidentifier,
                        @MGCOMPANYSECURITYID uniqueidentifier,

                        @TRIBUTENAME nvarchar(500),
                        @TRIBUTEDESCRIPTION nvarchar(500),
                        @TRIBUTETYPECODEID uniqueidentifier,
                        @TRIBUTEID uniqueidentifier,
                        @APPLYTRIBUTETODONATION bit, 

                        @ADDTRIBUTEACKNOWLEDGEE bit,
                        @TRIBUTEACKNOWLEDGEESECURITYID uniqueidentifier,
                        @UPDATETRIBUTEACKNOWLEDGEEADDRESS bit,
                        @TRIBUTEACKNOWLEDGEENAME nvarchar(250),
                        @TRIBUTEACKNOWLEDGEEEMAIL nvarchar(100),
                        @TRIBUTEACKNOWLEDGEESTREETADDRESS nvarchar(300),
                        @TRIBUTEACKNOWLEDGEECITY nvarchar(100),
                        @TRIBUTEACKNOWLEDGEESTATE nvarchar(100),
                        @TRIBUTEACKNOWLEDGEEPOSTCODE nvarchar(12),
                        @TRIBUTEACKNOWLEDGEECOUNTRY nvarchar(100),
                        @TRIBUTEACKNOWLEDGEEPHONE nvarchar(100),
                        @TRIBUTEACKNOWLEDGEELINKID uniqueidentifier,

                        @DONORSITEID uniqueidentifier,
                        @CORPORATEDONORSITEID uniqueidentifier,
                        @MGCOMPANYSITEID uniqueidentifier,
                        @TRIBUTEACKNOWLEDGEESITEID uniqueidentifier,

                        @REMOVESPOUSE bit,
                        @SPOUSEINFORMATION xml,
                        @SAMESPOUSE bit,
                        @SPOUSELINKID uniqueidentifier,
                        @SPOUSEOLDNAME nvarchar(200),
                        @SPOUSESECURITYID uniqueidentifier,
                        @SPOUSESITEID uniqueidentifier,

                        @SEQUENCE int,


                        @APPLICATIONS xml,
                        @PDACCOUNTSYSTEMID uniqueidentifier,
                        @ATTRIBUTECURRENCYID uniqueidentifier,
                        @CATEGORYCODEID 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.BATCHBBNCDONATION
                        set NETCOMMUNITYTRANSACTIONPROCESSORID = @NETCOMMUNITYTRANSACTIONPROCESSORID,
                            BBNCID = @BBNCID,
                            BBNCTRANID = @BBNCTRANID,
                            ORIGINPAGE = @ORIGINPAGE,
                            ORIGINPAGEID = @ORIGINPAGEID,
                            ORIGINAPPEALID = @ORIGINAPPEALID,
                            ADDEDBY = @ADDEDBY,
                            DONORID = @DONORID,
                            LOGGEDINUSER = @LOGGEDINUSER,
                            CORPORATEDONORID = @CORPORATEDONORID,
                            APPEALID = @APPEALID,
                            ISTEAMFUNDRAISINGOFFLINEGIFT = @ISTEAMFUNDRAISINGOFFLINEGIFT,
                            DONORINFORMATION = @DONORINFORMATION,
                            DONORINFORMATIONALLFIELDS = @DONORINFORMATIONALLFIELDS,
                            DONORADDRESSINFORMATION = @DONORADDRESSINFORMATION,
                            DONORADDRESSINFORMATIONALLFIELDS = @DONORADDRESSINFORMATIONALLFIELDS,
                            PHONETYPES = @PHONETYPES,
                            GIFTINFORMATION = @GIFTINFORMATION,
                            GIFTATTRIBUTEINFORMATION = @GIFTATTRIBUTEINFORMATION,
                            MGINFORMATIONFROMMFO = @MGINFORMATIONFROMMFO,
                            MGINFORMATION = @MGINFORMATION,
                            MGCONSTITUENTID = @MGCONSTITUENTID,

                            DONORADDRESSINFORMATIONUPDATE = @DONORADDRESSINFORMATIONUPDATE,
                            DONORADDRESSINFORMATIONCREATENEW = @DONORADDRESSINFORMATIONCREATENEW,
                            DONORADDRESSINFORMATIONMAKEPRIMARY = @DONORADDRESSINFORMATIONMAKEPRIMARY,
                            DONORADDRESSINFORMATIONADDRESSTYPECODEID = @DONORADDRESSINFORMATIONADDRESSTYPECODEID,
                            DONOTRECEIPT = @DONOTRECEIPT,
                            DONOTACKNOWLEDGE = @DONOTACKNOWLEDGE,
                            UPDATEMGINFORMATIONFROMMFO = 0, --JamesWill CR275482-051707 2007/05/21 The update from MFO checkbox is no longer used
                            CATEGORYCODEID = @CATEGORYCODEID,

                            --JamesWill CR268488-022807
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE,

                            DONORIDAUTOMATCH = @DONORIDAUTOMATCH,
                            CORPORATEDONORIDAUTOMATCH = @CORPORATEDONORIDAUTOMATCH,
                            MGCONSTITUENTIDAUTOMATCH = @MGCONSTITUENTIDAUTOMATCH,

                            DONORSECURITYID = @DONORSECURITYID,
                            CORPORATEDONORSECURITYID = @CORPORATEDONORSECURITYID,
                            MGCOMPANYSECURITYID = @MGCOMPANYSECURITYID,

                            TRIBUTENAME = @TRIBUTENAME,
                            TRIBUTEDESCRIPTION = @TRIBUTEDESCRIPTION,
                            TRIBUTETYPECODEID = @TRIBUTETYPECODEID,
                            TRIBUTEID = @TRIBUTEID,
                            APPLYTRIBUTETODONATION = @APPLYTRIBUTETODONATION,

                            ADDTRIBUTEACKNOWLEDGEE = @ADDTRIBUTEACKNOWLEDGEE,
                            TRIBUTEACKNOWLEDGEESECURITYID = @TRIBUTEACKNOWLEDGEESECURITYID,
                            UPDATETRIBUTEACKNOWLEDGEEADDRESS= @UPDATETRIBUTEACKNOWLEDGEEADDRESS,
                            TRIBUTEACKNOWLEDGEENAME = @TRIBUTEACKNOWLEDGEENAME,
                            TRIBUTEACKNOWLEDGEEEMAIL = @TRIBUTEACKNOWLEDGEEEMAIL,
                            TRIBUTEACKNOWLEDGEESTREETADDRESS = @TRIBUTEACKNOWLEDGEESTREETADDRESS,
                            TRIBUTEACKNOWLEDGEECITY = @TRIBUTEACKNOWLEDGEECITY,
                            TRIBUTEACKNOWLEDGEESTATE = @TRIBUTEACKNOWLEDGEESTATE,
                            TRIBUTEACKNOWLEDGEEPOSTCODE = @TRIBUTEACKNOWLEDGEEPOSTCODE,
                            TRIBUTEACKNOWLEDGEECOUNTRY = @TRIBUTEACKNOWLEDGEECOUNTRY,
                            TRIBUTEACKNOWLEDGEEPHONE = @TRIBUTEACKNOWLEDGEEPHONE,
                            TRIBUTEACKNOWLEDGEELINKID = @TRIBUTEACKNOWLEDGEELINKID,

                            DONORSITEID = @DONORSITEID,
                            CORPORATEDONORSITEID = @CORPORATEDONORSITEID,
                            MGCOMPANYSITEID = @MGCOMPANYSITEID,
                            TRIBUTEACKNOWLEDGEESITEID = @TRIBUTEACKNOWLEDGEESITEID,

                            REMOVESPOUSE = @REMOVESPOUSE,
                            SPOUSEINFORMATION = @SPOUSEINFORMATION,
                            SAMESPOUSE = @SAMESPOUSE,
                            SPOUSELINKID = @SPOUSELINKID,
                            SPOUSEOLDNAME = @SPOUSEOLDNAME,
                            SPOUSESECURITYID = @SPOUSESECURITYID,
                            SPOUSESITEID = @SPOUSESITEID,

                            PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID,
                            ATTRIBUTECURRENCYID = @ATTRIBUTECURRENCYID,

                            SEQUENCE = @SEQUENCE
                        where ID = @ID;

                        declare @CONTEXTCACHE varbinary(128);
                        set @CONTEXTCACHE = CONTEXT_INFO();
                        set CONTEXT_INFO @CHANGEAGENTID;

                        delete from dbo.BATCHBBNCDONATIONSOLICITOR where BATCHBBNCDONATIONID = @ID;

                        if not @CONTEXTCACHE is null
                            set CONTEXT_INFO @CONTEXTCACHE;

                        insert into dbo.BATCHBBNCDONATIONSOLICITOR(ID, BATCHBBNCDONATIONID, FUNDRAISERID, SEQUENCE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                            select
                                coalesce(ID, newid()),
                                @ID,
                                FUNDRAISERID,
                                SEQUENCE,
                                @CHANGEAGENTID,
                                @CHANGEAGENTID,
                                @CURRENTDATE,
                                @CURRENTDATE
                            from dbo.UFN_BATCHBBNCDONATION_GETSOLICITORS_FROMITEMLISTXML(@SOLICITORS);

                        exec dbo.USP_BATCHBBNCDONATION_GETSPLITS_UPDATEFROMXML @ID, @SPLITS, @CHANGEAGENTID, @CURRENTDATE;


            set @CONTEXTCACHE = CONTEXT_INFO();
                        set CONTEXT_INFO @CHANGEAGENTID;

            delete from dbo.BATCHBBNCDONATIONGIFTAPPLICATION where BATCHBBNCDONATIONID = @ID;

            if not @CONTEXTCACHE is null
                            set CONTEXT_INFO @CONTEXTCACHE;

            insert into dbo.BATCHBBNCDONATIONGIFTAPPLICATION(ID, BATCHBBNCDONATIONID, SEQUENCE, APPLICATIONID, CONSTITUENTID, APPLIEDAMOUNT, OVERPAYMENTTYPECODE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, APPLICATIONCODE)
                            select
                                coalesce(ID, newid()),
                                @ID,
                                SEQUENCE,
                APPLICATIONID,
                          CONSTITUENTID,
                          APPLIEDAMOUNT,
                OVERPAYMENTTYPECODE,
                                @CHANGEAGENTID,
                                @CHANGEAGENTID,
                                @CURRENTDATE,
                                @CURRENTDATE,
                coalesce(APPLICATIONCODE, 0)
                            from dbo.UFN_BATCHBBNCDONATION_GETGIFTAPPLICATIONS_FROMITEMLISTXML(@APPLICATIONS);
          end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;