USP_DATAFORMTEMPLATE_EDITLOAD_FAFEVENTDONATIONOPTIONSCONFIG

The load procedure used by the edit dataform template "FAF Event Donation Options Config Edit Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@EVENTID	uniqueidentifier	INOUT	EventID
@ALLOWGIFTTYPEONETIMEDONATION	bit	INOUT	One-time donation
@ALLOWGIFTTYPERECURRING	bit	INOUT	Recurring
@ALLOWGIFTTYPEPLEDGE	bit	INOUT	Pledge
@ISENABLEDONATIONS	bit	INOUT	One-time donation
@ISENABLERECURRINGGIFTS	bit	INOUT	Recurring
@ISENABLEPLEDGES	bit	INOUT	Pledge
@ISALLOWTEAMDONATIONS	bit	INOUT	Team
@ISALLOWCOMPANYDONATIONS	bit	INOUT	Company
@ISALLOWEVENTDONATIONS	bit	INOUT	Event
@MINIMUMDONATIONAMOUNT	money	INOUT	Minimum
@MAXIMUMTRANSACTIONAMOUNT	money	INOUT	Maximum
@ISALLOWDONATIONSFROMORGS	bit	INOUT	Allow gifts from organizations
@ISFREQUENCYAVAILONLINEMONTHLYGIFT	bit	INOUT	Monthly
@ISFREQUENCYAVAILONLINEANNUALLYGIFT	bit	INOUT	Annually
@ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT	bit	INOUT	Semi-annually
@ISFREQUENCYAVAILONLINEQUARTERLYGIFT	bit	INOUT	Quarterly
@ISFREQUENCYAVAILONLINEBIMONTHLYGIFT	bit	INOUT	Bimonthly
@ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT	bit	INOUT	Semi-monthly
@ISFREQUENCYAVAILONLINEBIWEEKLYGIFT	bit	INOUT	Biweekly
@ISFREQUENCYAVAILONLINEWEEKLYGIFT	bit	INOUT	Weekly
@ISALLOWDONORTOSELECTSTARTDATEGIFT	bit	INOUT	Choices of Allow donor to select start date
@STARTDATEONORBEFOREGIFT	datetime	INOUT	Start date must be before
@ISSTARTDATESAMEASDAYTOSUBMITGIFT	bit	INOUT	Start date will be day the form is submitted
@DONORONORBEFOREDATEGIFT	datetime	INOUT	Donors must schedule recurring gifts to end on or before this date
@ISFREQUENCYAVAILONLINEMONTHLYPLEDGE	bit	INOUT	Monthly
@ISFREQUENCYAVAILONLINEANNUALLYPLEDGE	bit	INOUT	Annually
@ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE	bit	INOUT	Semi-annually
@ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE	bit	INOUT	Quarterly
@ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE	bit	INOUT	Bimonthly
@ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE	bit	INOUT	Semi-monthly
@ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE	bit	INOUT	Biweekly
@ISFREQUENCYAVAILONLINEWEEKLYPLEDGE	bit	INOUT	Weekly
@ISALLOWDONORTOSELECTSTARTDATEPLEDGE	bit	INOUT	Choices of Allow donor to select start date
@STARTDATEONORBEFOREPLEDGE	datetime	INOUT	Start date must be before
@ISSTARTDATESAMEASDAYTOSUBMITPLEDGE	bit	INOUT	Start date will be day the form is submitted
@DONORONORBEFOREDATEPLEDGE	datetime	INOUT	Donors must schedule last pledge payment on or before this date
@ISFREQUENCYAVAILONLINESINGLEPLEDGE	bit	INOUT	Single payment
@ISFREQUENCYAVAILONLINESINGLEGIFT	bit	INOUT	Single Gift
@ISUNPAIDPLEDGES	bit	INOUT	Unpaid pledges
@ISUNPAIDRECURRINGGIFTS	bit	INOUT	Unpaid recurring gifts
@ISSPONSORSHIPREVENUE	bit	INOUT	Sponsorship revenue
@ISUNPAIDSPONSORSHIPREVENUE	bit	INOUT	Unpaid sponsorship revenue
@ISREGISTRATIONREVENUE	bit	INOUT	Registration revenue
@ISPENDINGMATCHINGGIFTS	bit	INOUT	Matching gift claims
@UNCONFIRMEDPARTICIPANTGIFTENTRY	bit	INOUT	Unconfirmed participant gift entry
@ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR	bit	INOUT	Allow participants to enter cash and checks from donors. These gifts will not become revenue until they are confirmed by the administrator. If checked the ?Donation entry? area of the participant HQ will be enabled.
@ISALLOWHOUSEHOLDDONATIONS	bit	INOUT

Definition

Copy


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

    @ISUNPAIDPLEDGES bit = null output,
    @ISUNPAIDRECURRINGGIFTS bit = null output,
    @ISSPONSORSHIPREVENUE bit = null output,
    @ISUNPAIDSPONSORSHIPREVENUE bit = null output,
    @ISREGISTRATIONREVENUE bit = null output,
    @ISPENDINGMATCHINGGIFTS bit = null output,
    @UNCONFIRMEDPARTICIPANTGIFTENTRY bit = null output,
    @ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR bit = null output,
    @ISALLOWHOUSEHOLDDONATIONS bit = null output
)
as

    set nocount on;

    -- be sure to set these, in case the select returns no rows
    set @DATALOADED = 0
    set @TSLONG = 0

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.  Also note that we fetch the TSLONG so that concurrency
    -- can be considered.

    --Check to see there is an existing record for this eventid and add default value if no record is found.
    IF NOT EXISTS (SELECT EVENTID FROM FAFEVENTDONATIONOPTIONSCONFIG WHERE EVENTID=@ID)
    BEGIN
        DECLARE @CHANGEAGENTID uniqueidentifier = null
        DECLARE @CURRENTDATE datetime
        set @CURRENTDATE = getdate()

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

        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, 
            ISFREQUENCYAVAILONLINESINGLEPLEDGE, ISFREQUENCYAVAILONLINESINGLEGIFT, UNCONFIRMEDPARTICIPANTGIFTENTRY,ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR, 
            ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, ISALLOWHOUSEHOLDDONATIONS)
        values
            (newid(), @ID, 0, 0, 0, 1, 1, 1, 
            1, 1, 1, 5, 0, 0, 
            1, 0, 0, 0, 
            0, 0, 0, 0, 
            1, null, 0, null, 0, 
            0, 0, 0, 0,
            0, 0, 0, 1, 
            null, 0, null, 
            1, 0, 1, 1, 
            @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE, 1)    
    END

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @EVENTID = EVENTID, 
        @ALLOWGIFTTYPEONETIMEDONATION = ALLOWGIFTTYPEONETIMEDONATION,
        @ALLOWGIFTTYPERECURRING = ALLOWGIFTTYPERECURRING,
        @ALLOWGIFTTYPEPLEDGE = ALLOWGIFTTYPEPLEDGE,
        @ISENABLEDONATIONS = ISENABLEDONATIONS,
        @ISENABLERECURRINGGIFTS = ISENABLERECURRINGGIFTS,
        @ISENABLEPLEDGES = ISENABLEPLEDGES,
        @ISALLOWTEAMDONATIONS = ISALLOWTEAMDONATIONS, 
        @ISALLOWCOMPANYDONATIONS = ISALLOWCOMPANYDONATIONS, 
        @ISALLOWEVENTDONATIONS = ISALLOWEVENTDONATIONS, 
        @MINIMUMDONATIONAMOUNT = MINIMUMDONATIONAMOUNT, 
        @MAXIMUMTRANSACTIONAMOUNT = MAXIMUMTRANSACTIONAMOUNT, 
        @ISALLOWDONATIONSFROMORGS = ISALLOWDONATIONSFROMORGS, 
        @ISFREQUENCYAVAILONLINEMONTHLYGIFT = ISFREQUENCYAVAILONLINEMONTHLYGIFT, 
        @ISFREQUENCYAVAILONLINEANNUALLYGIFT = ISFREQUENCYAVAILONLINEANNUALLYGIFT, 
        @ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT = ISFREQUENCYAVAILONLINESEMIANNUALLYGIFT, 
        @ISFREQUENCYAVAILONLINEQUARTERLYGIFT = ISFREQUENCYAVAILONLINEQUARTERLYGIFT, 
        @ISFREQUENCYAVAILONLINEBIMONTHLYGIFT = ISFREQUENCYAVAILONLINEBIMONTHLYGIFT, 
        @ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT = ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT, 
        @ISFREQUENCYAVAILONLINEBIWEEKLYGIFT = ISFREQUENCYAVAILONLINEBIWEEKLYGIFT, 
        @ISFREQUENCYAVAILONLINEWEEKLYGIFT = ISFREQUENCYAVAILONLINEWEEKLYGIFT, 
        @ISALLOWDONORTOSELECTSTARTDATEGIFT = ISALLOWDONORTOSELECTSTARTDATEGIFT, 
        @STARTDATEONORBEFOREGIFT = STARTDATEONORBEFOREGIFT, 
        @ISSTARTDATESAMEASDAYTOSUBMITGIFT = ISSTARTDATESAMEASDAYTOSUBMITGIFT, 
        @DONORONORBEFOREDATEGIFT = DONORONORBEFOREDATEGIFT, 
        @ISFREQUENCYAVAILONLINEMONTHLYPLEDGE = ISFREQUENCYAVAILONLINEMONTHLYPLEDGE, 
        @ISFREQUENCYAVAILONLINEANNUALLYPLEDGE = ISFREQUENCYAVAILONLINEANNUALLYPLEDGE, 
        @ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE = ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE, 
        @ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE = ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE, 
        @ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE = ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE, 
        @ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE = ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE, 
        @ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE = ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE, 
        @ISFREQUENCYAVAILONLINEWEEKLYPLEDGE = ISFREQUENCYAVAILONLINEWEEKLYPLEDGE, 
        @ISALLOWDONORTOSELECTSTARTDATEPLEDGE = ISALLOWDONORTOSELECTSTARTDATEPLEDGE, 
        @STARTDATEONORBEFOREPLEDGE = STARTDATEONORBEFOREPLEDGE, 
        @ISSTARTDATESAMEASDAYTOSUBMITPLEDGE = ISSTARTDATESAMEASDAYTOSUBMITPLEDGE, 
        @DONORONORBEFOREDATEPLEDGE = DONORONORBEFOREDATEPLEDGE,
        @ISFREQUENCYAVAILONLINESINGLEPLEDGE = ISFREQUENCYAVAILONLINESINGLEPLEDGE, 
        @ISFREQUENCYAVAILONLINESINGLEGIFT = ISFREQUENCYAVAILONLINESINGLEGIFT,

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

        @UNCONFIRMEDPARTICIPANTGIFTENTRY = UNCONFIRMEDPARTICIPANTGIFTENTRY, 
        @ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR = ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR,
        @ISALLOWHOUSEHOLDDONATIONS = ISALLOWHOUSEHOLDDONATIONS

    from dbo.FAFEVENTDONATIONOPTIONSCONFIG
    where EVENTID = @ID

    return 0;