USP_FAFEVENT_GETREVENUEOPTION_ADDFROMXML
Used to add a set of records defined by UFN_FAFEVENT_GETREVENUEOPTION 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: 11/30/2010 11:25:47 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.8.2022.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_FAFEVENT_GETREVENUEOPTION_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 (
[ALLOWGIFTTYPEONETIMEDONATION] bit,
[ALLOWGIFTTYPEPLEDGE] bit,
[ALLOWGIFTTYPERECURRING] bit,
[COPYBATCHGUID] uniqueidentifier,
[COPYSOURCEID] uniqueidentifier,
[DONORONORBEFOREDATEGIFT] datetime,
[DONORONORBEFOREDATEPLEDGE] datetime,
[ID] varchar(36),
[ISALLOWCOMPANYDONATIONS] bit,
[ISALLOWDONATIONSFROMORGS] bit,
[ISALLOWDONORTOSELECTSTARTDATEGIFT] tinyint,
[ISALLOWDONORTOSELECTSTARTDATEPLEDGE] tinyint,
[ISALLOWEVENTDONATIONS] bit,
[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR] bit,
[ISALLOWTEAMDONATIONS] bit,
[ISENABLEDONATIONS] bit,
[ISENABLEPLEDGES] bit,
[ISENABLERECURRINGGIFTS] bit,
[ISFREQUENCYAVAILONLINEANNUALLYGIFT] bit,
[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT] bit,
[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT] bit,
[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINEMONTHLYGIFT] bit,
[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINEQUARTERLYGIFT] bit,
[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT] bit,
[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT] bit,
[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE] bit,
[ISFREQUENCYAVAILONLINESINGLEGIFT] bit,
[ISFREQUENCYAVAILONLINESINGLEPLEDGE] bit,
[ISFREQUENCYAVAILONLINEWEEKLYGIFT] bit,
[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE] bit,
[ISPENDINGMATCHINGGIFTS] bit,
[ISREGISTRATIONREVENUE] bit,
[ISSPONSORSHIPREVENUE] bit,
[ISSTARTDATESAMEASDAYTOSUBMITGIFT] bit,
[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE] bit,
[ISUNPAIDPLEDGES] bit,
[ISUNPAIDRECURRINGGIFTS] bit,
[ISUNPAIDSPONSORSHIPREVENUE] bit,
[MAXIMUMTRANSACTIONAMOUNT] money,
[MINIMUMDONATIONAMOUNT] money,
[STARTDATEONORBEFOREGIFT] datetime,
[STARTDATEONORBEFOREPLEDGE] datetime,
[UNCONFIRMEDPARTICIPANTGIFTENTRY] bit)
insert into @TempTbl select
[ALLOWGIFTTYPEONETIMEDONATION],
[ALLOWGIFTTYPEPLEDGE],
[ALLOWGIFTTYPERECURRING],
[COPYBATCHGUID],
[COPYSOURCEID],
[DONORONORBEFOREDATEGIFT],
[DONORONORBEFOREDATEPLEDGE],
[ID],
[ISALLOWCOMPANYDONATIONS],
[ISALLOWDONATIONSFROMORGS],
[ISALLOWDONORTOSELECTSTARTDATEGIFT],
[ISALLOWDONORTOSELECTSTARTDATEPLEDGE],
[ISALLOWEVENTDONATIONS],
[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR],
[ISALLOWTEAMDONATIONS],
[ISENABLEDONATIONS],
[ISENABLEPLEDGES],
[ISENABLERECURRINGGIFTS],
[ISFREQUENCYAVAILONLINEANNUALLYGIFT],
[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE],
[ISFREQUENCYAVAILONLINEMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEQUARTERLYGIFT],
[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT],
[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINESINGLEGIFT],
[ISFREQUENCYAVAILONLINESINGLEPLEDGE],
[ISFREQUENCYAVAILONLINEWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE],
[ISPENDINGMATCHINGGIFTS],
[ISREGISTRATIONREVENUE],
[ISSPONSORSHIPREVENUE],
[ISSTARTDATESAMEASDAYTOSUBMITGIFT],
[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE],
[ISUNPAIDPLEDGES],
[ISUNPAIDRECURRINGGIFTS],
[ISUNPAIDSPONSORSHIPREVENUE],
[MAXIMUMTRANSACTIONAMOUNT],
[MINIMUMDONATIONAMOUNT],
[STARTDATEONORBEFOREGIFT],
[STARTDATEONORBEFOREPLEDGE],
[UNCONFIRMEDPARTICIPANTGIFTENTRY]
from dbo.UFN_FAFEVENT_GETREVENUEOPTION_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 [FAFEVENTDONATIONOPTIONSCONFIG]
([EVENTID],
[ALLOWGIFTTYPEONETIMEDONATION],
[ALLOWGIFTTYPEPLEDGE],
[ALLOWGIFTTYPERECURRING],
[COPYBATCHGUID],
[COPYSOURCEID],
[DONORONORBEFOREDATEGIFT],
[DONORONORBEFOREDATEPLEDGE],
[ID],
[ISALLOWCOMPANYDONATIONS],
[ISALLOWDONATIONSFROMORGS],
[ISALLOWDONORTOSELECTSTARTDATEGIFT],
[ISALLOWDONORTOSELECTSTARTDATEPLEDGE],
[ISALLOWEVENTDONATIONS],
[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR],
[ISALLOWTEAMDONATIONS],
[ISENABLEDONATIONS],
[ISENABLEPLEDGES],
[ISENABLERECURRINGGIFTS],
[ISFREQUENCYAVAILONLINEANNUALLYGIFT],
[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE],
[ISFREQUENCYAVAILONLINEMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEQUARTERLYGIFT],
[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT],
[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINESINGLEGIFT],
[ISFREQUENCYAVAILONLINESINGLEPLEDGE],
[ISFREQUENCYAVAILONLINEWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE],
[ISPENDINGMATCHINGGIFTS],
[ISREGISTRATIONREVENUE],
[ISSPONSORSHIPREVENUE],
[ISSTARTDATESAMEASDAYTOSUBMITGIFT],
[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE],
[ISUNPAIDPLEDGES],
[ISUNPAIDRECURRINGGIFTS],
[ISUNPAIDSPONSORSHIPREVENUE],
[MAXIMUMTRANSACTIONAMOUNT],
[MINIMUMDONATIONAMOUNT],
[STARTDATEONORBEFOREGIFT],
[STARTDATEONORBEFOREPLEDGE],
[UNCONFIRMEDPARTICIPANTGIFTENTRY],
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED)
select @EVENTID,
[ALLOWGIFTTYPEONETIMEDONATION],
[ALLOWGIFTTYPEPLEDGE],
[ALLOWGIFTTYPERECURRING],
[COPYBATCHGUID],
[COPYSOURCEID],
[DONORONORBEFOREDATEGIFT],
[DONORONORBEFOREDATEPLEDGE],
[ID],
[ISALLOWCOMPANYDONATIONS],
[ISALLOWDONATIONSFROMORGS],
[ISALLOWDONORTOSELECTSTARTDATEGIFT],
[ISALLOWDONORTOSELECTSTARTDATEPLEDGE],
[ISALLOWEVENTDONATIONS],
[ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR],
[ISALLOWTEAMDONATIONS],
[ISENABLEDONATIONS],
[ISENABLEPLEDGES],
[ISENABLERECURRINGGIFTS],
[ISFREQUENCYAVAILONLINEANNUALLYGIFT],
[ISFREQUENCYAVAILONLINEANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEBIWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE],
[ISFREQUENCYAVAILONLINEMONTHLYGIFT],
[ISFREQUENCYAVAILONLINEMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINEQUARTERLYGIFT],
[ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT],
[ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE],
[ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT],
[ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE],
[ISFREQUENCYAVAILONLINESINGLEGIFT],
[ISFREQUENCYAVAILONLINESINGLEPLEDGE],
[ISFREQUENCYAVAILONLINEWEEKLYGIFT],
[ISFREQUENCYAVAILONLINEWEEKLYPLEDGE],
[ISPENDINGMATCHINGGIFTS],
[ISREGISTRATIONREVENUE],
[ISSPONSORSHIPREVENUE],
[ISSTARTDATESAMEASDAYTOSUBMITGIFT],
[ISSTARTDATESAMEASDAYTOSUBMITPLEDGE],
[ISUNPAIDPLEDGES],
[ISUNPAIDRECURRINGGIFTS],
[ISUNPAIDSPONSORSHIPREVENUE],
[MAXIMUMTRANSACTIONAMOUNT],
[MINIMUMDONATIONAMOUNT],
[STARTDATEONORBEFOREGIFT],
[STARTDATEONORBEFOREPLEDGE],
[UNCONFIRMEDPARTICIPANTGIFTENTRY],
@CHANGEAGENTID,
@CHANGEAGENTID,
@CHANGEDATE,
@CHANGEDATE
from @TempTbl as [temp]
if @@Error <> 0
return 2;
return 0;