USP_FAFEVENT_GETEVENTSPONSORSHIPOPTION_ADDFROMXML
Used to add a set of records defined by UFN_FAFEVENT_GETEVENTSPONSORSHIPOPTION from the given xml string.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN | |
| @XML | xml | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @CHANGEDATE | datetime | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:26:52 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_FAFEVENT_GETEVENTSPONSORSHIPOPTION_ADDFROMXML
(
@EVENTID 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 (
[ALLOWSPONSORWAIVEBENEFITS] bit,
[COMMUNICATIONS] int,
[COPYBATCHGUID] uniqueidentifier,
[COPYSOURCEID] uniqueidentifier,
[DESCRIPTION] nvarchar(1000),
[DISPLAYSPOTSAVAILABLE] bit,
[DONORRETENTION] decimal(7, 2),
[EARLYREGISTRATIONDATE] int,
[EARLYREGISTRATIONDISCOUNT] money,
[FEESAMOUNT] money,
[ID] varchar(36),
[ISACTIVE] bit,
[ISNOTAVAILABLEONLINEREG] bit,
[ISNOTLOWERCOMMUNICATION] bit,
[ISNOTLOWERDONORRETENTION] bit,
[ISNOTLOWERFUNDRAISINGGOAL] bit,
[ISNOTLOWERRECRUITEMENT] bit,
[ISNOTLOWERUNIT] bit,
[ISNOTLOWERVOLUNTEERRECRUITEMENT] bit,
[LABELFORUNITGOAL] nvarchar(50),
[LATEFEE] money,
[LATEFEEDATE] int,
[MINFUNDRAISINGGOAL] money,
[NAME] nvarchar(50),
[NUMBERAVAILABLE] int,
[RECRUITEMENT] int,
[SENDEVENTCONTACTALERTMAXREACHED] bit,
[SPONSORMUSTPAYBALANCE] bit,
[SPONSORPAYSBALANCEMESSAGE] nvarchar(1000),
[TAXDEDUCTIBLEAMOUNT] money,
[TURNONWAITLIST] bit,
[UNIT] int,
[VOLUNTEERRECRUITEMENT] int,
[WAITLISTMESSAGE] nvarchar(1000))
insert into @TempTbl select
[ALLOWSPONSORWAIVEBENEFITS],
[COMMUNICATIONS],
[COPYBATCHGUID],
[COPYSOURCEID],
[DESCRIPTION],
[DISPLAYSPOTSAVAILABLE],
[DONORRETENTION],
[EARLYREGISTRATIONDATE],
[EARLYREGISTRATIONDISCOUNT],
[FEESAMOUNT],
[ID],
[ISACTIVE],
[ISNOTAVAILABLEONLINEREG],
[ISNOTLOWERCOMMUNICATION],
[ISNOTLOWERDONORRETENTION],
[ISNOTLOWERFUNDRAISINGGOAL],
[ISNOTLOWERRECRUITEMENT],
[ISNOTLOWERUNIT],
[ISNOTLOWERVOLUNTEERRECRUITEMENT],
[LABELFORUNITGOAL],
[LATEFEE],
[LATEFEEDATE],
[MINFUNDRAISINGGOAL],
[NAME],
[NUMBERAVAILABLE],
[RECRUITEMENT],
[SENDEVENTCONTACTALERTMAXREACHED],
[SPONSORMUSTPAYBALANCE],
[SPONSORPAYSBALANCEMESSAGE],
[TAXDEDUCTIBLEAMOUNT],
[TURNONWAITLIST],
[UNIT],
[VOLUNTEERRECRUITEMENT],
[WAITLISTMESSAGE]
from dbo.UFN_FAFEVENT_GETEVENTSPONSORSHIPOPTION_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 [EVENTSPONSORSHIPTYPE]
([EVENTID],
[ALLOWSPONSORWAIVEBENEFITS],
[COMMUNICATIONS],
[COPYBATCHGUID],
[COPYSOURCEID],
[DESCRIPTION],
[DISPLAYSPOTSAVAILABLE],
[DONORRETENTION],
[EARLYREGISTRATIONDATE],
[EARLYREGISTRATIONDISCOUNT],
[FEESAMOUNT],
[ID],
[ISACTIVE],
[ISNOTAVAILABLEONLINEREG],
[ISNOTLOWERCOMMUNICATION],
[ISNOTLOWERDONORRETENTION],
[ISNOTLOWERFUNDRAISINGGOAL],
[ISNOTLOWERRECRUITEMENT],
[ISNOTLOWERUNIT],
[ISNOTLOWERVOLUNTEERRECRUITEMENT],
[LABELFORUNITGOAL],
[LATEFEE],
[LATEFEEDATE],
[MINFUNDRAISINGGOAL],
[NAME],
[NUMBERAVAILABLE],
[RECRUITEMENT],
[SENDEVENTCONTACTALERTMAXREACHED],
[SPONSORMUSTPAYBALANCE],
[SPONSORPAYSBALANCEMESSAGE],
[TAXDEDUCTIBLEAMOUNT],
[TURNONWAITLIST],
[UNIT],
[VOLUNTEERRECRUITEMENT],
[WAITLISTMESSAGE],
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED)
select @EVENTID,
[ALLOWSPONSORWAIVEBENEFITS],
[COMMUNICATIONS],
[COPYBATCHGUID],
[COPYSOURCEID],
[DESCRIPTION],
[DISPLAYSPOTSAVAILABLE],
[DONORRETENTION],
[EARLYREGISTRATIONDATE],
[EARLYREGISTRATIONDISCOUNT],
[FEESAMOUNT],
[ID],
[ISACTIVE],
[ISNOTAVAILABLEONLINEREG],
[ISNOTLOWERCOMMUNICATION],
[ISNOTLOWERDONORRETENTION],
[ISNOTLOWERFUNDRAISINGGOAL],
[ISNOTLOWERRECRUITEMENT],
[ISNOTLOWERUNIT],
[ISNOTLOWERVOLUNTEERRECRUITEMENT],
[LABELFORUNITGOAL],
[LATEFEE],
[LATEFEEDATE],
[MINFUNDRAISINGGOAL],
[NAME],
[NUMBERAVAILABLE],
[RECRUITEMENT],
[SENDEVENTCONTACTALERTMAXREACHED],
[SPONSORMUSTPAYBALANCE],
[SPONSORPAYSBALANCEMESSAGE],
[TAXDEDUCTIBLEAMOUNT],
[TURNONWAITLIST],
[UNIT],
[VOLUNTEERRECRUITEMENT],
[WAITLISTMESSAGE],
@CHANGEAGENTID,
@CHANGEAGENTID,
@CHANGEDATE,
@CHANGEDATE
from @TempTbl as [temp]
if @@Error <> 0
return 2;
return 0;