USP_DATAFORMTEMPLATE_ADD_BBNCDONATIONBATCHROW
The save procedure used by the add dataform template "NetCommunity Donation Batch Row Add Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @BATCHID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @NETCOMMUNITYTRANSACTIONPROCESSORID | uniqueidentifier | IN | Processor |
| @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 |
| @DONORINFORMATION | xml | IN | Donor information |
| @DONORADDRESSINFORMATION | xml | IN | Donor address information |
| @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 |
| @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 |
| @SEQUENCE | int | IN | Sequence |
| @DONORADDRESSINFORMATIONALLFIELDS | xml | IN | Donor address information all fields |
| @DONORADDRESSINFORMATIONADDRESSTYPECODEID | uniqueidentifier | IN | Previous address type |
| @DONORIDAUTOMATCH | nvarchar(255) | IN | Individual auto-match |
| @CORPORATEDONORIDAUTOMATCH | nvarchar(255) | IN | Corporate donor auto-match |
| @MGCONSTITUENTIDAUTOMATCH | nvarchar(255) | IN | MG auto-match |
| @ISTEAMFUNDRAISINGOFFLINEGIFT | bit | IN | Offline gift |
| @BBNCID | int | IN | Blackbaud Internet Solutions ID |
| @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 |
| @APPLICATIONS | xml | IN | Applications |
| @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 |
| @PDACCOUNTSYSTEMID | uniqueidentifier | IN | Account system |
| @ATTRIBUTECURRENCYID | uniqueidentifier | IN | Attribute currency |
| @CATEGORYCODEID | uniqueidentifier | IN | Revenue category |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BBNCDONATIONBATCHROW
(
@ID uniqueidentifier = null output,
@BATCHID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
@BBNCTRANID int,
@ORIGINPAGE nvarchar(1000) = null,
@ORIGINPAGEID int = 0,
@ORIGINAPPEALID uniqueidentifier = null,
@ADDEDBY nvarchar(255),
@DONORID uniqueidentifier = null,
@LOGGEDINUSER bit,
@CORPORATEDONORID uniqueidentifier = null,
@APPEALID uniqueidentifier = null,
@DONORINFORMATION xml = null,
@DONORADDRESSINFORMATION xml = null,
@PHONETYPES xml = null,
@GIFTINFORMATION xml = null,
@GIFTATTRIBUTEINFORMATION xml = null,
@MGINFORMATIONFROMMFO bit = 0,
@MGINFORMATION xml = null,
@MGCONSTITUENTID uniqueidentifier = null,
@DONORADDRESSINFORMATIONUPDATE bit = 0,
@DONORADDRESSINFORMATIONCREATENEW bit = 0,
@DONORADDRESSINFORMATIONMAKEPRIMARY bit = 0,
@DONOTRECEIPT bit = 0,
@DONOTACKNOWLEDGE bit = 0,
@UPDATEMGINFORMATIONFROMMFO bit = 0,
@SOLICITORS xml = null,
@SPLITS xml = null,
@SEQUENCE int = 0,
@DONORADDRESSINFORMATIONALLFIELDS xml = null,
@DONORADDRESSINFORMATIONADDRESSTYPECODEID uniqueidentifier = null,
@DONORIDAUTOMATCH nvarchar(255) = null,
@CORPORATEDONORIDAUTOMATCH nvarchar(255) = null,
@MGCONSTITUENTIDAUTOMATCH nvarchar(255) = null,
@ISTEAMFUNDRAISINGOFFLINEGIFT bit = null,
@BBNCID int = 0,
@DONORINFORMATIONALLFIELDS xml = null,
@ORIGINALDONORID uniqueidentifier = null,
@ORIGINALCORPORATEDONORID uniqueidentifier = null,
@DONORSECURITYID uniqueidentifier = null,
@CORPORATEDONORSECURITYID uniqueidentifier = null,
@MGCOMPANYSECURITYID uniqueidentifier = null,
@TRIBUTENAME nvarchar(500) = '',
@TRIBUTEDESCRIPTION nvarchar(500) = '',
@TRIBUTETYPECODEID uniqueidentifier = null,
@TRIBUTEID uniqueidentifier = null,
@APPLYTRIBUTETODONATION bit = 0,
@ADDTRIBUTEACKNOWLEDGEE bit = 0,
@TRIBUTEACKNOWLEDGEESECURITYID uniqueidentifier = null,
@UPDATETRIBUTEACKNOWLEDGEEADDRESS bit = 0,
@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 = null,
@DONORSITEID uniqueidentifier = null,
@CORPORATEDONORSITEID uniqueidentifier = null,
@MGCOMPANYSITEID uniqueidentifier = null,
@TRIBUTEACKNOWLEDGEESITEID uniqueidentifier = null,
@APPLICATIONS xml = null,
@REMOVESPOUSE bit = 0,
@SPOUSEINFORMATION xml = null,
@SAMESPOUSE bit = 1,
@SPOUSELINKID uniqueidentifier = null,
@SPOUSEOLDNAME nvarchar(200) = null,
@SPOUSESECURITYID uniqueidentifier = null,
@SPOUSESITEID uniqueidentifier = null,
@PDACCOUNTSYSTEMID uniqueidentifier = null,
@ATTRIBUTECURRENCYID uniqueidentifier = null,
@CATEGORYCODEID uniqueidentifier = null
)
as
set nocount on;
declare @CURRENTDATE datetime;
if @ID is null
set @ID = newid();
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CURRENTDATE = getdate();
begin try
insert into dbo.BBNCDOWNLOADEDTRANSACTION
(
[ID]
)
values
(
@BBNCID
);
if @ORIGINPAGE is null
set @ORIGINPAGE = N'';
if @DONORIDAUTOMATCH is null
set @DONORIDAUTOMATCH = N'';
if @CORPORATEDONORIDAUTOMATCH is null
set @CORPORATEDONORIDAUTOMATCH = N'';
if @MGCONSTITUENTIDAUTOMATCH is null
set @MGCONSTITUENTIDAUTOMATCH = N'';
if @TRIBUTENAME is null
set @TRIBUTENAME = N'';
if @TRIBUTEDESCRIPTION is null
set @TRIBUTEDESCRIPTION = N'';
if @TRIBUTEACKNOWLEDGEENAME is null
set @TRIBUTEACKNOWLEDGEENAME = N'';
if @TRIBUTEACKNOWLEDGEEEMAIL is null
set @TRIBUTEACKNOWLEDGEEEMAIL = N'';
if @TRIBUTEACKNOWLEDGEESTREETADDRESS is null
set @TRIBUTEACKNOWLEDGEESTREETADDRESS = N'';
if @TRIBUTEACKNOWLEDGEECITY is null
set @TRIBUTEACKNOWLEDGEECITY = N'';
if @TRIBUTEACKNOWLEDGEESTATE is null
set @TRIBUTEACKNOWLEDGEESTATE = N'';
if @TRIBUTEACKNOWLEDGEEPOSTCODE is null
set @TRIBUTEACKNOWLEDGEEPOSTCODE = N'';
if @TRIBUTEACKNOWLEDGEECOUNTRY is null
set @TRIBUTEACKNOWLEDGEECOUNTRY = N'';
if @APPLYTRIBUTETODONATION is null
set @APPLYTRIBUTETODONATION = 0;
exec dbo.USP_BBNC_ENCRYPTGIFTDATA @GIFTINFORMATION = @GIFTINFORMATION output, @KEYISALREADYOPEN = 1;
insert into dbo.BATCHBBNCDONATION
(
ID,
BATCHID,
NETCOMMUNITYTRANSACTIONPROCESSORID,
BBNCID,
BBNCTRANID,
ORIGINPAGE,
ORIGINPAGEID,
ORIGINAPPEALID,
ADDEDBY,
DONORID,
LOGGEDINUSER,
CORPORATEDONORID,
APPEALID,
ISTEAMFUNDRAISINGOFFLINEGIFT,
DONORINFORMATION,
DONORINFORMATIONALLFIELDS,
DONORADDRESSINFORMATION,
DONORADDRESSINFORMATIONALLFIELDS,
PHONETYPES,
GIFTINFORMATION,
GIFTATTRIBUTEINFORMATION,
MGINFORMATIONFROMMFO,
MGINFORMATION,
MGCONSTITUENTID,
DONORADDRESSINFORMATIONUPDATE,
DONORADDRESSINFORMATIONCREATENEW,
DONORADDRESSINFORMATIONMAKEPRIMARY,
DONORADDRESSINFORMATIONADDRESSTYPECODEID,
DONOTRECEIPT,
DONOTACKNOWLEDGE,
UPDATEMGINFORMATIONFROMMFO,
DONORIDAUTOMATCH,
CORPORATEDONORIDAUTOMATCH,
MGCONSTITUENTIDAUTOMATCH,
CATEGORYCODEID,
DONORSECURITYID,
CORPORATEDONORSECURITYID,
MGCOMPANYSECURITYID,
TRIBUTENAME,
TRIBUTEDESCRIPTION,
TRIBUTETYPECODEID,
TRIBUTEID,
APPLYTRIBUTETODONATION,
ADDTRIBUTEACKNOWLEDGEE,
TRIBUTEACKNOWLEDGEESECURITYID,
UPDATETRIBUTEACKNOWLEDGEEADDRESS,
TRIBUTEACKNOWLEDGEENAME,
TRIBUTEACKNOWLEDGEEEMAIL,
TRIBUTEACKNOWLEDGEESTREETADDRESS,
TRIBUTEACKNOWLEDGEECITY,
TRIBUTEACKNOWLEDGEESTATE,
TRIBUTEACKNOWLEDGEEPOSTCODE,
TRIBUTEACKNOWLEDGEECOUNTRY,
TRIBUTEACKNOWLEDGEEPHONE,
TRIBUTEACKNOWLEDGEELINKID,
DONORSITEID,
CORPORATEDONORSITEID,
MGCOMPANYSITEID,
TRIBUTEACKNOWLEDGEESITEID,
REMOVESPOUSE,
SPOUSEINFORMATION,
SAMESPOUSE,
SPOUSELINKID,
SPOUSEOLDNAME,
SPOUSESECURITYID,
SPOUSESITEID,
PDACCOUNTSYSTEMID,
ATTRIBUTECURRENCYID,
SEQUENCE,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED
)
values
(
@ID,
@BATCHID,
@NETCOMMUNITYTRANSACTIONPROCESSORID,
@BBNCID,
@BBNCTRANID,
@ORIGINPAGE,
@ORIGINPAGEID,
@ORIGINAPPEALID,
@ADDEDBY,
@DONORID,
@LOGGEDINUSER,
@CORPORATEDONORID,
@APPEALID,
@ISTEAMFUNDRAISINGOFFLINEGIFT,
@DONORINFORMATION,
@DONORINFORMATIONALLFIELDS,
@DONORADDRESSINFORMATION,
@DONORADDRESSINFORMATIONALLFIELDS,
@PHONETYPES,
@GIFTINFORMATION,
@GIFTATTRIBUTEINFORMATION,
@MGINFORMATIONFROMMFO,
@MGINFORMATION,
@MGCONSTITUENTID,
@DONORADDRESSINFORMATIONUPDATE,
@DONORADDRESSINFORMATIONCREATENEW,
@DONORADDRESSINFORMATIONMAKEPRIMARY,
@DONORADDRESSINFORMATIONADDRESSTYPECODEID,
@DONOTRECEIPT,
@DONOTACKNOWLEDGE,
0, --JamesWill CR275482-051707 2007/05/21 The update from MFO checkbox is no longer used
@DONORIDAUTOMATCH,
@CORPORATEDONORIDAUTOMATCH,
@MGCONSTITUENTIDAUTOMATCH,
@CATEGORYCODEID,
@DONORSECURITYID,
@CORPORATEDONORSECURITYID,
@MGCOMPANYSECURITYID,
@TRIBUTENAME,
@TRIBUTEDESCRIPTION,
@TRIBUTETYPECODEID,
@TRIBUTEID,
@APPLYTRIBUTETODONATION,
@ADDTRIBUTEACKNOWLEDGEE,
@TRIBUTEACKNOWLEDGEESECURITYID,
@UPDATETRIBUTEACKNOWLEDGEEADDRESS,
@TRIBUTEACKNOWLEDGEENAME,
@TRIBUTEACKNOWLEDGEEEMAIL,
@TRIBUTEACKNOWLEDGEESTREETADDRESS,
@TRIBUTEACKNOWLEDGEECITY,
@TRIBUTEACKNOWLEDGEESTATE,
@TRIBUTEACKNOWLEDGEEPOSTCODE,
@TRIBUTEACKNOWLEDGEECOUNTRY,
@TRIBUTEACKNOWLEDGEEPHONE,
@TRIBUTEACKNOWLEDGEELINKID,
@DONORSITEID,
@CORPORATEDONORSITEID,
@MGCOMPANYSITEID,
@TRIBUTEACKNOWLEDGEESITEID,
@REMOVESPOUSE,
@SPOUSEINFORMATION,
@SAMESPOUSE,
@SPOUSELINKID,
@SPOUSEOLDNAME,
@SPOUSESECURITYID,
@SPOUSESITEID,
@PDACCOUNTSYSTEMID,
@ATTRIBUTECURRENCYID,
@SEQUENCE,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
)
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_ADDFROMXML @ID, @SPLITS, @CHANGEAGENTID, @CURRENTDATE;
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);
delete from dbo.BBNCUNSUCCESSFULDOWNLOADTRANSACTION
where
ID = @BBNCID;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;