USP_DATAFORMTEMPLATE_ADD_FAFEVENTDONATIONOPTIONSCONFIG

The save procedure used by the add dataform template "FAF Event Donation Options Config 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.
@EVENTID	uniqueidentifier	IN	Event
@ALLOWGIFTTYPEONETIMEDONATION	bit	IN	Allow gift type one-time donation
@ALLOWGIFTTYPERECURRING	bit	IN	Allow gift type recurring
@ALLOWGIFTTYPEPLEDGE	bit	IN	Allow gift type pledge
@ISENABLEDONATIONS	bit	IN	Enable donations
@ISENABLERECURRINGGIFTS	bit	IN	Enable recurring gifts
@ISENABLEPLEDGES	bit	IN	Enable pledges
@ISALLOWTEAMDONATIONS	bit	IN	Allow gifts team
@ISALLOWCOMPANYDONATIONS	bit	IN	Allow gifts company
@ISALLOWEVENTDONATIONS	bit	IN	Allow gifts event
@MINIMUMDONATIONAMOUNT	money	IN	Minimum donation amount
@MAXIMUMTRANSACTIONAMOUNT	money	IN	Maximum transaction amount
@ISALLOWDONATIONSFROMORGS	bit	IN	Allow gifts from organizations
@ISFREQUENCYAVAILONLINEMONTHLYGIFT	bit	IN	Monthly
@ISFREQUENCYAVAILONLINEANNUALLYGIFT	bit	IN	Annually
@ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT	bit	IN	Semi-Annually
@ISFREQUENCYAVAILONLINEQUARTERLYGIFT	bit	IN	Quarterly
@ISFREQUENCYAVAILONLINEBIMONTHLYGIFT	bit	IN	Bi-Monthly
@ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT	bit	IN	Semi-Monthly
@ISFREQUENCYAVAILONLINEBIWEEKLYGIFT	bit	IN	Bi-Weekly
@ISFREQUENCYAVAILONLINEWEEKLYGIFT	bit	IN	Weekly
@ISALLOWDONORTOSELECTSTARTDATEGIFT	tinyint	IN	Allow donor to select start date
@STARTDATEONORBEFOREGIFT	datetime	IN	Start date must be before
@ISSTARTDATESAMEASDAYTOSUBMITGIFT	bit	IN	Start date will be day the form is submitted
@DONORONORBEFOREDATEGIFT	datetime	IN	Donors must schedule recurring gifts to end on or before the date
@ISFREQUENCYAVAILONLINEMONTHLYPLEDGE	bit	IN	Monthly
@ISFREQUENCYAVAILONLINEANNUALLYPLEDGE	bit	IN	Annually
@ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE	bit	IN	Semi-Annually
@ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE	bit	IN	Quarterly
@ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE	bit	IN	Monthly
@ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE	bit	IN	Bi-Monthly
@ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE	bit	IN	Bi-Weekly
@ISFREQUENCYAVAILONLINEWEEKLYPLEDGE	bit	IN	Weekly
@ISALLOWDONORTOSELECTSTARTDATEPLEDGE	tinyint	IN	Allow donor to select start date
@STARTDATEONORBEFOREPLEDGE	datetime	IN	Start date must be before
@ISSTARTDATESAMEASDAYTOSUBMITPLEDGE	bit	IN	Start date will be day the form is submitted
@DONORONORBEFOREDATEPLEDGE	datetime	IN	Donors must last pledge payment on or before this date
@ISFREQUENCYAVAILONLINESINGLEPLEDGE	bit	IN	Single Pledge
@ISFREQUENCYAVAILONLINESINGLEGIFT	bit	IN	Single Gift
@ISUNPAIDPLEDGES	bit	IN	Unpaid pledges
@ISUNPAIDRECURRINGGIFTS	bit	IN	Unpaid recurring gifts
@ISSPONSORSHIPREVENUE	bit	IN	Sponsorship revenue
@ISUNPAIDSPONSORSHIPREVENUE	bit	IN	Unpaid sponsorship revenue
@ISREGISTRATIONREVENUE	bit	IN	Registration revenue
@ISPENDINGMATCHINGGIFTS	bit	IN	Pending matching gifts
@UNCONFIRMEDPARTICIPANTGIFTENTRY	bit	IN
@ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR	bit	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FAFEVENTDONATIONOPTIONSCONFIG
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @EVENTID uniqueidentifier,
    @ALLOWGIFTTYPEONETIMEDONATION bit = 0,
    @ALLOWGIFTTYPERECURRING bit = 0,
    @ALLOWGIFTTYPEPLEDGE bit = 0,
    @ISENABLEDONATIONS bit = 0,
    @ISENABLERECURRINGGIFTS bit = 0,
    @ISENABLEPLEDGES bit = 0,
    @ISALLOWTEAMDONATIONS bit = 0,
    @ISALLOWCOMPANYDONATIONS bit = 0,
    @ISALLOWEVENTDONATIONS bit = 0,
    @MINIMUMDONATIONAMOUNT money = 0,
    @MAXIMUMTRANSACTIONAMOUNT money = 0,
    @ISALLOWDONATIONSFROMORGS bit = 0,
    @ISFREQUENCYAVAILONLINEMONTHLYGIFT bit = 0,
    @ISFREQUENCYAVAILONLINEANNUALLYGIFT bit = 0,
    @ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT bit = 0,
    @ISFREQUENCYAVAILONLINEQUARTERLYGIFT bit = 0,
    @ISFREQUENCYAVAILONLINEBIMONTHLYGIFT bit = 0,
    @ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT bit = 0,
    @ISFREQUENCYAVAILONLINEBIWEEKLYGIFT bit = 0,
    @ISFREQUENCYAVAILONLINEWEEKLYGIFT bit = 0,
    @ISALLOWDONORTOSELECTSTARTDATEGIFT tinyint= 0,
    @STARTDATEONORBEFOREGIFT datetime = null,
    @ISSTARTDATESAMEASDAYTOSUBMITGIFT bit = 0,
    @DONORONORBEFOREDATEGIFT datetime = null,
    @ISFREQUENCYAVAILONLINEMONTHLYPLEDGE bit = 0,
    @ISFREQUENCYAVAILONLINEANNUALLYPLEDGE bit = 0,
    @ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE bit = 0,
    @ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE bit = 0,
    @ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE bit = 0,
    @ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE bit = 0,
    @ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE bit = 0,
    @ISFREQUENCYAVAILONLINEWEEKLYPLEDGE bit = 0,
    @ISALLOWDONORTOSELECTSTARTDATEPLEDGE tinyint = 0,
    @STARTDATEONORBEFOREPLEDGE datetime = null,
    @ISSTARTDATESAMEASDAYTOSUBMITPLEDGE bit = 0,
    @DONORONORBEFOREDATEPLEDGE datetime = null,
    @ISFREQUENCYAVAILONLINESINGLEPLEDGE bit = 0, 
    @ISFREQUENCYAVAILONLINESINGLEGIFT bit = 0,

    @ISUNPAIDPLEDGES bit = 0,
    @ISUNPAIDRECURRINGGIFTS bit = 0,
    @ISSPONSORSHIPREVENUE bit = 0,
    @ISUNPAIDSPONSORSHIPREVENUE bit = 0,
    @ISREGISTRATIONREVENUE bit = 0,
    @ISPENDINGMATCHINGGIFTS bit= 0,

    @UNCONFIRMEDPARTICIPANTGIFTENTRY bit = 0,
    @ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR bit= 0
)
as

set nocount on;

if @ID is null
    set @ID = newid()

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

begin try
    -- handle inserting the data
    insert into dbo.FAFEVENTDONATIONOPTIONSCONFIG
        (ID, EVENTID, ALLOWGIFTTYPEONETIMEDONATION, ALLOWGIFTTYPERECURRING, ALLOWGIFTTYPEPLEDGE, ISENABLEDONATIONS, ISENABLERECURRINGGIFTS, ISENABLEPLEDGES, 
        ISALLOWTEAMDONATIONS, ISALLOWCOMPANYDONATIONS, ISALLOWEVENTDONATIONS, MINIMUMDONATIONAMOUNT, MAXIMUMTRANSACTIONAMOUNT, ISALLOWDONATIONSFROMORGS, 
        ISFREQUENCYAVAILONLINEMONTHLYGIFT, ISFREQUENCYAVAILONLINEANNUALLYGIFT, ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT, ISFREQUENCYAVAILONLINEQUARTERLYGIFT, 
        ISFREQUENCYAVAILONLINEBIMONTHLYGIFT, ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT, ISFREQUENCYAVAILONLINEBIWEEKLYGIFT, ISFREQUENCYAVAILONLINEWEEKLYGIFT, 
        ISALLOWDONORTOSELECTSTARTDATEGIFT, STARTDATEONORBEFOREGIFT, ISSTARTDATESAMEASDAYTOSUBMITGIFT, DONORONORBEFOREDATEGIFT, ISFREQUENCYAVAILONLINEMONTHLYPLEDGE, 
        ISFREQUENCYAVAILONLINEANNUALLYPLEDGE, ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE, ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE, ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE, 
        ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE, ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE, ISFREQUENCYAVAILONLINEWEEKLYPLEDGE, ISALLOWDONORTOSELECTSTARTDATEPLEDGE, 
        STARTDATEONORBEFOREPLEDGE, ISSTARTDATESAMEASDAYTOSUBMITPLEDGE, DONORONORBEFOREDATEPLEDGE, 
        ISUNPAIDPLEDGES, ISUNPAIDRECURRINGGIFTS, ISSPONSORSHIPREVENUE, ISUNPAIDSPONSORSHIPREVENUE, ISREGISTRATIONREVENUE, ISPENDINGMATCHINGGIFTS,
        ISFREQUENCYAVAILONLINESINGLEPLEDGE, ISFREQUENCYAVAILONLINESINGLEGIFT, UNCONFIRMEDPARTICIPANTGIFTENTRY,ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR,
        ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
    values
        (@ID, @EVENTID, @ALLOWGIFTTYPEONETIMEDONATION, @ALLOWGIFTTYPERECURRING, @ALLOWGIFTTYPEPLEDGE, @ISENABLEDONATIONS, @ISENABLERECURRINGGIFTS, @ISENABLEPLEDGES, 
        @ISALLOWTEAMDONATIONS, @ISALLOWCOMPANYDONATIONS, @ISALLOWEVENTDONATIONS, @MINIMUMDONATIONAMOUNT, @MAXIMUMTRANSACTIONAMOUNT, @ISALLOWDONATIONSFROMORGS, 
        @ISFREQUENCYAVAILONLINEMONTHLYGIFT, @ISFREQUENCYAVAILONLINEANNUALLYGIFT, @ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT, @ISFREQUENCYAVAILONLINEQUARTERLYGIFT, 
        @ISFREQUENCYAVAILONLINEBIMONTHLYGIFT, @ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT, @ISFREQUENCYAVAILONLINEBIWEEKLYGIFT, @ISFREQUENCYAVAILONLINEWEEKLYGIFT, 
        @ISALLOWDONORTOSELECTSTARTDATEGIFT, @STARTDATEONORBEFOREGIFT, @ISSTARTDATESAMEASDAYTOSUBMITGIFT, @DONORONORBEFOREDATEGIFT, @ISFREQUENCYAVAILONLINEMONTHLYPLEDGE, 
        @ISFREQUENCYAVAILONLINEANNUALLYPLEDGE, @ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE, @ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE, @ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE,
        @ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE, @ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE, @ISFREQUENCYAVAILONLINEWEEKLYPLEDGE, @ISALLOWDONORTOSELECTSTARTDATEPLEDGE, 
        @STARTDATEONORBEFOREPLEDGE, @ISSTARTDATESAMEASDAYTOSUBMITPLEDGE, @DONORONORBEFOREDATEPLEDGE, 
        @ISUNPAIDPLEDGES, @ISUNPAIDRECURRINGGIFTS, @ISSPONSORSHIPREVENUE, @ISUNPAIDSPONSORSHIPREVENUE, @ISREGISTRATIONREVENUE, @ISPENDINGMATCHINGGIFTS,
        @ISFREQUENCYAVAILONLINESINGLEPLEDGE, @ISFREQUENCYAVAILONLINESINGLEGIFT, @UNCONFIRMEDPARTICIPANTGIFTENTRY, @ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR,
        @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0