USP_DATAFORMTEMPLATE_ADD_BBNCSIGNUPBATCHROW
The save procedure used by the add dataform template "NetCommunity Signup 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. |
| @LINKID | uniqueidentifier | IN | Linked Constituent |
| @NETCOMMUNITYTRANSACTIONPROCESSORID | uniqueidentifier | IN | Processor |
| @ISORGANIZATION | tinyint | IN | Constituent type |
| @BBNCTRANID | int | IN | Blackbaud Internet Solutions transaction ID |
| @BBNCCONSTITNAME | nvarchar(154) | IN | Blackbaud Internet Solutions Constituent name |
| @ADDEDBY | nvarchar(255) | IN | Added by hidden |
| @BBNCADDRESS | nvarchar(300) | IN | Blackbaud Internet Solutions address |
| @BIOGRAPHICAL | xml | IN | Biographical |
| @PREFERREDADDRESS | xml | IN | Preferred address |
| @PREFERREDADDRESSUPDATE | bit | IN | Update the primary address with the downloaded information |
| @PREFERREDADDRESSADD | bit | IN | Add the downloaded information as a new address for this constituent |
| @PREFERREDADDRESSMAKEPRIMARY | bit | IN | Make this new address the primary address |
| @PREFERREDADDRESSTYPECODEID | uniqueidentifier | IN | Previous address type |
| @PHONETYPES | xml | IN | Phone type codes hidden |
| @CONSTITUENTATTRIBUTES | xml | IN | Constituent attributes |
| @SEQUENCE | int | IN | Sequence |
| @BBNCUSERID | int | IN | Blackbaud Internet Solutions user ID |
| @SIGNUPTRANSACTIONDATE | datetime | IN | Signup date |
| @LINKIDAUTOMATCH | nvarchar(255) | IN | Auto-match |
| @BBNCID | int | IN | Blackbaud Internet Solutions ID |
| @BIOGRAPHICALALLFIELDS | xml | IN | Biographical all fields |
| @PREFERREDADDRESSALLFIELDS | xml | IN | Preferred address all fields |
| @ORIGINALLINKID | uniqueidentifier | IN | Original link ID |
| @LINKEDCONSTITUENTSECURITYID | uniqueidentifier | IN | Linked constituent security group |
| @LINKEDCONSTITUENTSITEID | uniqueidentifier | IN | Linked constituent site |
| @ATTRIBUTECURRENCYID | uniqueidentifier | IN | Attribute currency |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BBNCSIGNUPBATCHROW
(
@ID uniqueidentifier = null output,
@BATCHID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@LINKID uniqueidentifier = null,
@NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
@ISORGANIZATION tinyint = 0,
@BBNCTRANID int,
@BBNCCONSTITNAME nvarchar(154),
@ADDEDBY nvarchar(255),
@BBNCADDRESS nvarchar(300) = '',
@BIOGRAPHICAL xml = null,
@PREFERREDADDRESS xml = null,
@PREFERREDADDRESSUPDATE bit = 1,
@PREFERREDADDRESSADD bit = 0,
@PREFERREDADDRESSMAKEPRIMARY bit = 0,
@PREFERREDADDRESSTYPECODEID uniqueidentifier = null,
@PHONETYPES xml = null,
@CONSTITUENTATTRIBUTES xml = null,
@SEQUENCE int,
@BBNCUSERID int = null,
@SIGNUPTRANSACTIONDATE datetime = null,
@LINKIDAUTOMATCH nvarchar(255) = null,
@BBNCID int = 0,
@BIOGRAPHICALALLFIELDS xml = null,
@PREFERREDADDRESSALLFIELDS xml = null,
@ORIGINALLINKID uniqueidentifier = null,
@LINKEDCONSTITUENTSECURITYID uniqueidentifier = null,
@LINKEDCONSTITUENTSITEID uniqueidentifier = null,
@ATTRIBUTECURRENCYID 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 @LINKIDAUTOMATCH is null
set @LINKIDAUTOMATCH = N'';
insert into dbo.BATCHBBNCSIGNUP
(
[ID],
[BATCHID],
[LINKID],
[NETCOMMUNITYTRANSACTIONPROCESSORID],
[ISORGANIZATION],
[BBNCID],
[BBNCTRANID],
[BBNCCONSTITNAME],
[BBNCADDRESS],
[ADDEDBY],
[BBNCUSERID],
[SIGNUPTRANSACTIONDATE],
[BIOGRAPHICAL],
[BIOGRAPHICALALLFIELDS],
[PREFERREDADDRESS],
[PREFERREDADDRESSALLFIELDS],
[PREFERREDADDRESSUPDATE],
[PREFERREDADDRESSADD],
[PREFERREDADDRESSMAKEPRIMARY],
[PREFERREDADDRESSTYPECODEID],
[PHONETYPES],
[CONSTITUENTATTRIBUTES],
[LINKIDAUTOMATCH],
[LINKEDCONSTITUENTSECURITYID],
[LINKEDCONSTITUENTSITEID],
[ATTRIBUTECURRENCYID],
[SEQUENCE],
[ADDEDBYID],
[CHANGEDBYID],
[DATEADDED],
[DATECHANGED]
)
values
(
@ID,
@BATCHID,
@LINKID,
@NETCOMMUNITYTRANSACTIONPROCESSORID,
0, --JamesWill CR272725-041307 2007/05/09 Signups will always be individuals
@BBNCID,
@BBNCTRANID,
@BBNCCONSTITNAME,
@BBNCADDRESS,
@ADDEDBY,
@BBNCUSERID,
@SIGNUPTRANSACTIONDATE,
@BIOGRAPHICAL,
@BIOGRAPHICALALLFIELDS,
@PREFERREDADDRESS,
@PREFERREDADDRESSALLFIELDS,
@PREFERREDADDRESSUPDATE,
@PREFERREDADDRESSADD,
@PREFERREDADDRESSMAKEPRIMARY,
@PREFERREDADDRESSTYPECODEID,
@PHONETYPES,
@CONSTITUENTATTRIBUTES,
@LINKIDAUTOMATCH,
@LINKEDCONSTITUENTSECURITYID,
@LINKEDCONSTITUENTSITEID,
@ATTRIBUTECURRENCYID,
@SEQUENCE,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
);
delete from dbo.BBNCUNSUCCESSFULDOWNLOADTRANSACTION
where
ID = @BBNCID;
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;