USP_FAFEVENT_GETREGISTRATIONOPTIONGOALS_ADDFROMXML
Used to add a set of records defined by UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS from the given xml string.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTPRICEID | uniqueidentifier | IN | |
| @XML | xml | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @CHANGEDATE | datetime | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 2/1/2011 9:06:16 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.9.1001.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_FAFEVENT_GETREGISTRATIONOPTIONGOALS_ADDFROMXML
(
@EVENTPRICEID uniqueidentifier,
@XML xml,
@CHANGEAGENTID uniqueidentifier = null,
@CHANGEDATE datetime = null
)
as
set nocount on;
if @CHANGEAGENTID is null
exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
if @CHANGEDATE is null
set @CHANGEDATE = getdate()
-- build a temporary table containing the values from the XML
declare @TempTbl table (
[COMMUNICATIONS] int,
[DONORRETENTION] decimal(7, 4),
[ID] varchar(36),
[ISNOTLOWERCOMMUNICATION] bit,
[ISNOTLOWERDONORRETENTION] bit,
[ISNOTLOWERFUNDRAISING] bit,
[ISNOTLOWERRECRUITEMENT] bit,
[ISNOTLOWERTARGETFUNDRAISING] bit,
[ISNOTLOWERTEAMMEMBERRETENTION] bit,
[ISNOTLOWERTEAMMEMBERS] bit,
[ISNOTLOWERTEAMRETENTION] bit,
[ISNOTLOWERTEAMS] bit,
[ISNOTLOWERUNIT] bit,
[ISNOTLOWERVOLUNTEERRECRUITEMENT] bit,
[LABELFORUNIT] nvarchar(50),
[MINFUNDRAISING] money,
[PARTICIPANTMUSTPAYBALANCE] bit,
[PARTICIPANTPAYSBALANCEMESSAGE] nvarchar(1000),
[RECRUITEMENT] int,
[REGTYPEGOALCODE] tinyint,
[TARGETFUNDRAISING] money,
[TEAMMEMBERRETENTION] decimal(7, 4),
[TEAMMEMBERS] int,
[TEAMRETENTION] decimal(7, 4),
[TEAMS] int,
[UNIT] int,
[VOLUNTEERRECRUITEMENT] int)
insert into @TempTbl select
[COMMUNICATIONS],
[DONORRETENTION],
[ID],
[ISNOTLOWERCOMMUNICATION],
[ISNOTLOWERDONORRETENTION],
[ISNOTLOWERFUNDRAISING],
[ISNOTLOWERRECRUITEMENT],
[ISNOTLOWERTARGETFUNDRAISING],
[ISNOTLOWERTEAMMEMBERRETENTION],
[ISNOTLOWERTEAMMEMBERS],
[ISNOTLOWERTEAMRETENTION],
[ISNOTLOWERTEAMS],
[ISNOTLOWERUNIT],
[ISNOTLOWERVOLUNTEERRECRUITEMENT],
[LABELFORUNIT],
[MINFUNDRAISING],
[PARTICIPANTMUSTPAYBALANCE],
[PARTICIPANTPAYSBALANCEMESSAGE],
[RECRUITEMENT],
[REGTYPEGOALCODE],
[TARGETFUNDRAISING],
[TEAMMEMBERRETENTION],
[TEAMMEMBERS],
[TEAMRETENTION],
[TEAMS],
[UNIT],
[VOLUNTEERRECRUITEMENT]
from dbo.UFN_FAFEVENT_GETREGISTRATIONOPTIONGOALS_FROMITEMLISTXML(@XML)
update @TempTbl set ID = newid() where (ID is null) or (ID = '00000000-0000-0000-0000-000000000000');
if @@Error <> 0
return 1;
-- insert new items
insert into [FAFREGISTRATIONTYPEGOAL]
([EVENTPRICEID],
[COMMUNICATIONS],
[DONORRETENTION],
[ID],
[ISNOTLOWERCOMMUNICATION],
[ISNOTLOWERDONORRETENTION],
[ISNOTLOWERFUNDRAISING],
[ISNOTLOWERRECRUITEMENT],
[ISNOTLOWERTARGETFUNDRAISING],
[ISNOTLOWERTEAMMEMBERRETENTION],
[ISNOTLOWERTEAMMEMBERS],
[ISNOTLOWERTEAMRETENTION],
[ISNOTLOWERTEAMS],
[ISNOTLOWERUNIT],
[ISNOTLOWERVOLUNTEERRECRUITEMENT],
[LABELFORUNIT],
[MINFUNDRAISING],
[PARTICIPANTMUSTPAYBALANCE],
[PARTICIPANTPAYSBALANCEMESSAGE],
[RECRUITEMENT],
[REGTYPEGOALCODE],
[TARGETFUNDRAISING],
[TEAMMEMBERRETENTION],
[TEAMMEMBERS],
[TEAMRETENTION],
[TEAMS],
[UNIT],
[VOLUNTEERRECRUITEMENT],
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED)
select @EVENTPRICEID,
[COMMUNICATIONS],
[DONORRETENTION],
[ID],
[ISNOTLOWERCOMMUNICATION],
[ISNOTLOWERDONORRETENTION],
[ISNOTLOWERFUNDRAISING],
[ISNOTLOWERRECRUITEMENT],
[ISNOTLOWERTARGETFUNDRAISING],
[ISNOTLOWERTEAMMEMBERRETENTION],
[ISNOTLOWERTEAMMEMBERS],
[ISNOTLOWERTEAMRETENTION],
[ISNOTLOWERTEAMS],
[ISNOTLOWERUNIT],
[ISNOTLOWERVOLUNTEERRECRUITEMENT],
[LABELFORUNIT],
[MINFUNDRAISING],
[PARTICIPANTMUSTPAYBALANCE],
[PARTICIPANTPAYSBALANCEMESSAGE],
[RECRUITEMENT],
[REGTYPEGOALCODE],
[TARGETFUNDRAISING],
[TEAMMEMBERRETENTION],
[TEAMMEMBERS],
[TEAMRETENTION],
[TEAMS],
[UNIT],
[VOLUNTEERRECRUITEMENT],
@CHANGEAGENTID,
@CHANGEAGENTID,
@CHANGEDATE,
@CHANGEDATE
from @TempTbl as [temp]
if @@Error <> 0
return 2;
return 0;