USP_DATAFORMTEMPLATE_EDIT_FAFEVENTDONATIONOPTIONSCONFIG

The save 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 indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EVENTID	uniqueidentifier	IN	EventID
@ALLOWGIFTTYPEONETIMEDONATION	bit	IN	One-time donation
@ALLOWGIFTTYPERECURRING	bit	IN	Recurring
@ALLOWGIFTTYPEPLEDGE	bit	IN	Pledge
@ISENABLEDONATIONS	bit	IN	One-time donation
@ISENABLERECURRINGGIFTS	bit	IN	Recurring
@ISENABLEPLEDGES	bit	IN	Pledge
@ISALLOWTEAMDONATIONS	bit	IN	Team
@ISALLOWCOMPANYDONATIONS	bit	IN	Company
@ISALLOWEVENTDONATIONS	bit	IN	Event
@MINIMUMDONATIONAMOUNT	money	IN	Minimum
@MAXIMUMTRANSACTIONAMOUNT	money	IN	Maximum
@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	Bimonthly
@ISFREQUENCYAVAILONLINESEMIMONTHLYGIFT	bit	IN	Semi-monthly
@ISFREQUENCYAVAILONLINEBIWEEKLYGIFT	bit	IN	Biweekly
@ISFREQUENCYAVAILONLINEWEEKLYGIFT	bit	IN	Weekly
@ISALLOWDONORTOSELECTSTARTDATEGIFT	bit	IN	Choices of 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 this date
@ISFREQUENCYAVAILONLINEMONTHLYPLEDGE	bit	IN	Monthly
@ISFREQUENCYAVAILONLINEANNUALLYPLEDGE	bit	IN	Annually
@ISFREQUENCYAVAILONLINESEMIANNUALLYPLEDGE	bit	IN	Semi-annually
@ISFREQUENCYAVAILONLINEQUARTERLYPLEDGE	bit	IN	Quarterly
@ISFREQUENCYAVAILONLINEBIMONTHLYPLEDGE	bit	IN	Bimonthly
@ISFREQUENCYAVAILONLINESEMIMONTHLYPLEDGE	bit	IN	Semi-monthly
@ISFREQUENCYAVAILONLINEBIWEEKLYPLEDGE	bit	IN	Biweekly
@ISFREQUENCYAVAILONLINEWEEKLYPLEDGE	bit	IN	Weekly
@ISALLOWDONORTOSELECTSTARTDATEPLEDGE	bit	IN	Choices of 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 schedule last pledge payment on or before this date
@ISFREQUENCYAVAILONLINESINGLEPLEDGE	bit	IN	Single payment
@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	Matching gift claims
@UNCONFIRMEDPARTICIPANTGIFTENTRY	bit	IN	Unconfirmed participant gift entry
@ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR	bit	IN	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	IN

Definition

Copy



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

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

    set nocount on;
   exec dbo.USP_DATAFORMTEMPLATE_EDIT_FAFEVENTDONATIONOPTIONSCONFIG_2
    @ID,
      @CHANGEAGENTID,
    @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,

    @ISUNPAIDPLEDGES,
    @ISUNPAIDRECURRINGGIFTS,
    @ISSPONSORSHIPREVENUE,
    @ISUNPAIDSPONSORSHIPREVENUE,
    @ISREGISTRATIONREVENUE,
    @ISPENDINGMATCHINGGIFTS,
    @UNCONFIRMEDPARTICIPANTGIFTENTRY,
    @ISALLOWPARTENTERCASHCHECKERECEIVEDDONOR,
    @ISALLOWHOUSEHOLDDONATIONS

    return 0;