USP_DATAFORMTEMPLATE_VIEW_FAFEVENTDONATIONOPTIONSCONFIG

The load procedure used by the view dataform template "FAF Event Donation Options Config View 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.
@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	tinyint	INOUT	Choice of Allow donor to select start date
@STARTDATEONORBEFOREGIFT	datetime	INOUT	Start date must be before
@ISSTARTDATESAMEASDAYTOSUBMITGIFT	bit	INOUT	Start date will be the day the form is submitted
@DONORONORBEFOREDATEGIFT	datetime	INOUT	Donors must schedule recurring gifts to end on or before the 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	tinyint	INOUT	Choice of Allow donor to select start date
@STARTDATEONORBEFOREPLEDGE	datetime	INOUT	Start date must be before
@ISSTARTDATESAMEASDAYTOSUBMITPLEDGE	bit	INOUT	Start date will be the 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
@ISALLOWDONORTOSELECTSTARTDATEGIFT_ZERO	varchar(3)	INOUT	Allow donor to select start date
@ISALLOWDONORTOSELECTSTARTDATEGIFT_ONE	varchar(3)	INOUT	Donor start date gift when one
@ISALLOWDONORTOSELECTSTARTDATEPLEDGE_ZERO	varchar(3)	INOUT	Allow donor to select start date
@ISALLOWDONORTOSELECTSTARTDATEPLEDGE_ONE	varchar(3)	INOUT	Start date will be the day the form is submitted
@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_VIEW_FAFEVENTDONATIONOPTIONSCONFIG 
(
    @ID uniqueidentifier,
    @DATALOADED bit = 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 tinyint = 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 tinyint = 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,
    @ISALLOWDONORTOSELECTSTARTDATEGIFT_ZERO varchar(3) = null output,
    @ISALLOWDONORTOSELECTSTARTDATEGIFT_ONE varchar(3) = null output,
    @ISALLOWDONORTOSELECTSTARTDATEPLEDGE_ZERO varchar(3) = null output, 
    @ISALLOWDONORTOSELECTSTARTDATEPLEDGE_ONE varchar(3) = null output,

    @UNCONFIRMEDPARTICIPANTGIFTENTRY bit = null output,
    @ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR bit = null output,
     @ISALLOWHOUSEHOLDDONATIONS bit = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 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.

    select @DATALOADED = 1,
           @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,                 
      @ISALLOWDONORTOSELECTSTARTDATEGIFT_ZERO = case when ISALLOWDONORTOSELECTSTARTDATEGIFT = 0 then 'Yes' else 'No' end,
      @ISALLOWDONORTOSELECTSTARTDATEGIFT_ONE  = case when ISALLOWDONORTOSELECTSTARTDATEGIFT = 1 then 'Yes' else 'No' end,
      @ISALLOWDONORTOSELECTSTARTDATEPLEDGE_ZERO  = case when ISALLOWDONORTOSELECTSTARTDATEPLEDGE = 0 then 'Yes' else 'No' end,
      @ISALLOWDONORTOSELECTSTARTDATEPLEDGE_ONE  = case when ISALLOWDONORTOSELECTSTARTDATEPLEDGE = 1 then 'Yes' else 'No' end,

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

    from dbo.FAFEVENTDONATIONOPTIONSCONFIG
    where EVENTID = @ID

    return 0;