USP_DATAFORMTEMPLATE_EDIT_BBNCDONATIONBATCHROW_1_3

The save procedure used by the edit dataform template "NetCommunity Donation 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.
@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	Donor address information: update
@DONORADDRESSINFORMATIONCREATENEW	bit	IN	Donor address information: create new
@DONORADDRESSINFORMATIONMAKEPRIMARY	bit	IN	Donor address information: make primary
@DONORADDRESSINFORMATIONADDRESSTYPECODEID	uniqueidentifier	IN	Donor address information: 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
@SEQUENCE	int	IN	Sequence

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBNCDONATIONBATCHROW_1_3
                    (
                        @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,

                        @SEQUENCE int
                    )
                    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


                            --JamesWill CR268488-022807

                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE,

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

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

                            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;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;