USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPFORMCMSSETTINGS

The load procedure used by the edit dataform template "SponsorshipFormCMSSettings Edit 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.
@CHILDDISPLAYHTML	nvarchar(max)	INOUT	Childdisplayhtml
@PROJECTDISPLAYHTML	nvarchar(max)	INOUT	Projectdisplayhtml
@ATTRIBUTEITEMSLIST	xml	INOUT	Attributeitemslist
@DESIGNATIONLIST	xml	INOUT	Designationlist
@DEFAULTDESIGNATIONID	uniqueidentifier	INOUT	Defaultdesignationid
@DEFAULTDESIGNATION	int	INOUT	Defaultdesignation
@APPEALSLIST	xml	INOUT	Appealslist
@REQUIREAPPEAL	bit	INOUT	Requireappeal
@SOLESPONSORSHIPENABLED	bit	INOUT	Solesponsorshipenabled
@GIFTSPONSORSHIPENABLED	bit	INOUT	Giftsponsorshipenabled
@ECARDSENABLED	bit	INOUT	Ecardsenabled
@ADDITIONALGIFTENABLED	bit	INOUT	Additionalgiftenabled
@MULTIPLEGIFTSENABLED	bit	INOUT	Multiplegiftsenabled
@MINIMUMGIFTAMOUNT	decimal(20, 4)	INOUT	Minimumgiftamount
@CONSTITUENCYID	uniqueidentifier	INOUT	Constituencyid
@GENERALRECURRENCEENABLED	bit	INOUT	Generalrecurrenceenabled
@SCHEDULEDENDDATEENABLED	bit	INOUT	Scheduledenddateenabled
@RECURRENCEDATAIDLIST	xml	INOUT	Recurrencedataidlist
@ITEMEXPIRATION	int	INOUT	Itemexpiration
@PAYMENTPARTPAGE	int	INOUT	Paymentpartpage
@DIRECTDEBITENABLED	bit	INOUT	Directdebitenabled
@CHECKENABLED	bit	INOUT	CheckEnabled
@FORMITEMEXPIRATION	int	INOUT	FormItemExpiration
@ACKNOWLEDGEMENTHTML	nvarchar(max)	INOUT	Acknowledgement HTML
@FORCESTARTDATE	bit	INOUT	ForceStartDate
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT
@SUPPORTSCHECKOUTONLY	bit	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPFORMCMSSETTINGS
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @CHILDDISPLAYHTML nvarchar(max) = null output,
    @PROJECTDISPLAYHTML nvarchar(max) = null output,
    @ATTRIBUTEITEMSLIST xml = null output,
    @DESIGNATIONLIST xml = null output,
    @DEFAULTDESIGNATIONID uniqueidentifier = null output,
    @DEFAULTDESIGNATION int = null output,
    @APPEALSLIST xml = null output,
    @REQUIREAPPEAL bit = null output,
    @SOLESPONSORSHIPENABLED bit = null output,
    @GIFTSPONSORSHIPENABLED bit = null output,
    @ECARDSENABLED bit = null output,
    @ADDITIONALGIFTENABLED bit = null output,
    @MULTIPLEGIFTSENABLED bit = null output,
    @MINIMUMGIFTAMOUNT decimal(20,4) = null output,
    @CONSTITUENCYID uniqueidentifier = null output,
    @GENERALRECURRENCEENABLED bit = null output,
    @SCHEDULEDENDDATEENABLED bit = null output,
    @RECURRENCEDATAIDLIST xml = null output,
    @ITEMEXPIRATION int = null output,
    @PAYMENTPARTPAGE int = null output,
    @DIRECTDEBITENABLED bit = null output,
    @CHECKENABLED bit = null output,
    @FORMITEMEXPIRATION int = null output,
    @ACKNOWLEDGEMENTHTML nvarchar(max) = null output,
    @FORCESTARTDATE bit = null output,
    @PDACCOUNTSYSTEMID uniqueidentifier = null output,
        @SUPPORTSCHECKOUTONLY 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.

    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,
        @CHILDDISPLAYHTML = CHILDDISPLAYHTML, 
        @PROJECTDISPLAYHTML = PROJECTDISPLAYHTML, 
        @ATTRIBUTEITEMSLIST = ATTRIBUTEITEMSLIST, 
        @DESIGNATIONLIST = DESIGNATIONLIST, 
        @DEFAULTDESIGNATIONID = DEFAULTDESIGNATIONID, 
        @DEFAULTDESIGNATION = DEFAULTDESIGNATION, 
        @APPEALSLIST = APPEALSLIST, 
        @REQUIREAPPEAL = REQUIREAPPEAL, 
        @SOLESPONSORSHIPENABLED = SOLESPONSORSHIPENABLED, 
        @GIFTSPONSORSHIPENABLED = GIFTSPONSORSHIPENABLED, 
        @ECARDSENABLED = ECARDSENABLED, 
        @ADDITIONALGIFTENABLED = ADDITIONALGIFTENABLED, 
        @MULTIPLEGIFTSENABLED = MULTIPLEGIFTSENABLED, 
        @MINIMUMGIFTAMOUNT = MINIMUMGIFTAMOUNT, 
        @CONSTITUENCYID = CONSTITUENCYID, 
        @GENERALRECURRENCEENABLED = GENERALRECURRENCEENABLED, 
        @SCHEDULEDENDDATEENABLED = SCHEDULEDENDDATEENABLED, 
        @RECURRENCEDATAIDLIST = RECURRENCEDATAIDLIST, 
        @ITEMEXPIRATION = ITEMEXPIRATION, 
        @PAYMENTPARTPAGE = PAYMENTPARTPAGE, 
        @DIRECTDEBITENABLED = DIRECTDEBITENABLED, 
        @CHECKENABLED = CHECKENABLED,
        @FORMITEMEXPIRATION = FORMITEMEXPIRATION,
        @ACKNOWLEDGEMENTHTML = ACKNOWLEDGEMENTHTML,
        @FORCESTARTDATE = FORCESTARTDATE,
        @PDACCOUNTSYSTEMID = PDACCOUNTSYSTEMID,
                @SUPPORTSCHECKOUTONLY=SUPPORTSCHECKOUTONLY
    from dbo.SPONSORSHIPFORMCMSSETTINGS
    where ID = @ID

    return 0;