USP_DATAFORMTEMPLATE_ADD_BBNCFUNDRAISERBATCHROW
The save procedure used by the add dataform template "NetCommunity Fundraiser 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 |
| @BBNCAPPEALID | int | IN | Blackbaud Internet Solutions appeal ID |
| @APPEALID | uniqueidentifier | IN | Appeal hidden |
| @NEWTEAMS | int | IN | New teams hidden |
| @NEWTEAMFUNDRAISERS | int | IN | New team fundraisers hidden |
| @CHANGEDTEAMS | int | IN | Changed teams hidden |
| @CHANGEDTEAMFUNDRAISERS | int | IN | Changed team fundraisers hidden |
| @TEAMS | xml | IN | Teams |
| @TEAMFUNDRAISERS | xml | IN | Team fundraisers hidden |
| @SEQUENCE | int | IN | Sequence |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BBNCFUNDRAISERBATCHROW
(
@ID uniqueidentifier = null output,
@BATCHID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@NETCOMMUNITYTRANSACTIONPROCESSORID uniqueidentifier,
@BBNCTRANID int,
@BBNCAPPEALID int,
@APPEALID uniqueidentifier,
@NEWTEAMS int = 0,
@NEWTEAMFUNDRAISERS int = 0,
@CHANGEDTEAMS int = 0,
@CHANGEDTEAMFUNDRAISERS int = 0,
@TEAMS xml = null,
@TEAMFUNDRAISERS xml = null,
@SEQUENCE int
)
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.BATCHBBNCFUNDRAISER
(
[ID],
[BATCHID],
[NETCOMMUNITYTRANSACTIONPROCESSORID],
[BBNCTRANID],
[BBNCAPPEALID],
[APPEALID],
[NEWTEAMS],
[NEWTEAMFUNDRAISERS],
[CHANGEDTEAMS],
[CHANGEDTEAMFUNDRAISERS],
[TEAMS],
[TEAMFUNDRAISERS],
[SEQUENCE],
[ADDEDBYID],
[CHANGEDBYID],
[DATEADDED],
[DATECHANGED]
)
values
(
@ID,
@BATCHID,
@NETCOMMUNITYTRANSACTIONPROCESSORID,
@BBNCTRANID,
@BBNCAPPEALID,
@APPEALID,
@NEWTEAMS,
@NEWTEAMFUNDRAISERS,
@CHANGEDTEAMS,
@CHANGEDTEAMFUNDRAISERS,
@TEAMS,
@TEAMFUNDRAISERS,
@SEQUENCE,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE
);
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;