USP_DATAFORMTEMPLATE_ADD_BBNCMEMBERSHIPBATCHROW
The save procedure used by the add dataform template "NetCommunity Membership Batch Row Add Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @BATCHID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @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 |
| @EMAILSUBJECT | nvarchar(4000) | IN | Email subject |
| @EMAILID | int | IN | Email ID |
| @ADDEDBY | nvarchar(255) | IN | Added by hidden |
| @SEQUENCE | int | IN | Sequence |
| @MEMBERSHIPID | uniqueidentifier | IN | Membership |
| @MEMBERSHIPLEVELID | uniqueidentifier | IN | Membership level |
| @MEMBERSHIPLEVELTERMID | uniqueidentifier | IN | Membership level term |
| @MEMBERSHIPLEVELTYPECODEID | uniqueidentifier | IN | Membership level type |
| @MEMBERSHIPPROGRAMID | uniqueidentifier | IN | Membership program |
| @MEMBERSHIPPROGRAMINFO | xml | IN | Membership program info |
| @PAYMENTINFO | xml | IN | Payment info |
| @MEMBERSINFO | xml | IN | Members info |
| @MEMBERSECURITYID | uniqueidentifier | IN | Member constituent security group |
| @MEMBERSITEID | uniqueidentifier | IN | Guest site |
| @PDACCOUNTSYSTEMID | uniqueidentifier | IN | Account system |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BBNCMEMBERSHIPBATCHROW
(
@ID uniqueidentifier output,
@CHANGEAGENTID uniqueidentifier,
@BATCHID uniqueidentifier,
@NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
@BBNCID int,
@BBNCTRANID int,
@ORIGINPAGE nvarchar(1000),
@ORIGINPAGEID int,
@EMAILSUBJECT nvarchar(4000) = '',
@EMAILID int = 0,
@ADDEDBY nvarchar(255),
@SEQUENCE int = 0,
@MEMBERSHIPID uniqueidentifier = null,
@MEMBERSHIPLEVELID uniqueidentifier = null,
@MEMBERSHIPLEVELTERMID uniqueidentifier = null,
@MEMBERSHIPLEVELTYPECODEID uniqueidentifier = null,
@MEMBERSHIPPROGRAMID uniqueidentifier = null,
@MEMBERSHIPPROGRAMINFO xml = null,
@PAYMENTINFO xml = null,
@MEMBERSINFO xml = null,
@MEMBERSECURITYID uniqueidentifier = null,
@MEMBERSITEID uniqueidentifier = null,
@PDACCOUNTSYSTEMID uniqueidentifier = null
)
as
set nocount on;
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
declare @CHANGEDATE datetime;
set @CHANGEDATE = getdate();
if @ID is null
set @ID = newid();
begin try
insert into dbo.BBNCDOWNLOADEDTRANSACTION
(
[ID]
)
values
(
@BBNCID
);
insert into dbo.BATCHBBNCMEMBERSHIP
(
ID,
BATCHID,
NETCOMMUNITYTRANSACTIONPROCESSORID,
ADDEDBY,
SEQUENCE,
BBNCID,
BBNCTRANID,
ORIGINPAGE,
ORIGINPAGEID,
EMAILSUBJECT,
EMAILID,
MEMBERSHIPID,
MEMBERSHIPLEVELID,
MEMBERSHIPLEVELTERMID,
MEMBERSHIPLEVELTYPECODEID,
MEMBERSHIPPROGRAMID,
MEMBERSHIPPROGRAMINFO,
PAYMENTINFO,
MEMBERSECURITYID,
MEMBERSITEID,
PDACCOUNTSYSTEMID,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED
)
values
(
@ID,
@BATCHID,
@NETCOMMUNITYTRANSACTIONPROCESSORID,
@ADDEDBY,
@SEQUENCE,
@BBNCID,
@BBNCTRANID,
@ORIGINPAGE,
@ORIGINPAGEID,
@EMAILSUBJECT,
@EMAILID,
@MEMBERSHIPID,
@MEMBERSHIPLEVELID,
@MEMBERSHIPLEVELTERMID,
@MEMBERSHIPLEVELTYPECODEID,
@MEMBERSHIPPROGRAMID,
@MEMBERSHIPPROGRAMINFO,
@PAYMENTINFO,
@MEMBERSECURITYID,
@MEMBERSITEID,
@PDACCOUNTSYSTEMID,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CHANGEDATE,
@CHANGEDATE
);
insert into dbo.BATCHBBNCMEMBERSHIPMEMBER(ID, BATCHBBNCMEMBERSHIPID, SEQUENCE, MEMBERID, MEMBERCONSTITUENTID, MEMBERISPRIMARY, MEMBERUPDATEADDRESS, MEMBERADDADDRESS, MEMBERMAKEADDRESSPRIMARY, MEMBERADDRESSTYPECODEID,
MEMBERBIOINFO, MEMBERBIOINFOALL, MEMBERPHONETYPES,
MEMBERADDRESSINFO, MEMBERADDRESSINFOALL,
ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
select
newid(), @ID, SEQUENCE,
MEMBERID, MEMBERCONSTITUENTID,
MEMBERISPRIMARY, MEMBERUPDATEADDRESS, MEMBERADDADDRESS, MEMBERMAKEADDRESSPRIMARY, MEMBERADDRESSTYPECODEID,
MEMBERBIOINFO, MEMBERBIOINFOALL, MEMBERPHONETYPES,
MEMBERADDRESSINFO, MEMBERADDRESSINFOALL,
@CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE
from dbo.UFN_BATCHBBNCMEMBERSHIP_GETMEMBERS_FROMITEMLISTXML(@MEMBERSINFO);
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;