USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPFORMCMSSETTINGS

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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPFORMCMSSETTINGS
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @CHILDDISPLAYHTML nvarchar(max) = '',
    @PROJECTDISPLAYHTML nvarchar(max) = '',
    @ATTRIBUTEITEMSLIST xml = null,
    @DESIGNATIONLIST xml = null,
    @DEFAULTDESIGNATIONID uniqueidentifier = null,
    @DEFAULTDESIGNATION int = 0,
    @APPEALSLIST xml = null,
    @REQUIREAPPEAL bit = 0,
    @SOLESPONSORSHIPENABLED bit = 0,
    @GIFTSPONSORSHIPENABLED bit = 0,
    @ECARDSENABLED bit = 0,
    @ADDITIONALGIFTENABLED bit = 0,
    @MULTIPLEGIFTSENABLED bit = 0,
    @MINIMUMGIFTAMOUNT decimal(20,4) = 0,
    @CONSTITUENCYID uniqueidentifier = null,
    @GENERALRECURRENCEENABLED bit = 0,
    @SCHEDULEDENDDATEENABLED bit = 0,
    @RECURRENCEDATAIDLIST xml = null,
    @ITEMEXPIRATION int = 0,
    @PAYMENTPARTPAGE int = 0,
    @DIRECTDEBITENABLED bit = 0,
    @CHECKENABLED bit = 0,
    @FORMITEMEXPIRATION int = 0,
    @ACKNOWLEDGEMENTHTML nvarchar(max) = '',
    @FORCESTARTDATE bit = 0,
    @PDACCOUNTSYSTEMID uniqueidentifier = null,
        @SUPPORTSCHECKOUTONLY 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.SPONSORSHIPFORMCMSSETTINGS
        (ID, CHILDDISPLAYHTML, PROJECTDISPLAYHTML, ATTRIBUTEITEMSLIST, DESIGNATIONLIST, DEFAULTDESIGNATIONID, DEFAULTDESIGNATION, APPEALSLIST, REQUIREAPPEAL, SOLESPONSORSHIPENABLED, GIFTSPONSORSHIPENABLED, ECARDSENABLED, ADDITIONALGIFTENABLED, MULTIPLEGIFTSENABLED, MINIMUMGIFTAMOUNT, CONSTITUENCYID, GENERALRECURRENCEENABLED, SCHEDULEDENDDATEENABLED, RECURRENCEDATAIDLIST, ITEMEXPIRATION, PAYMENTPARTPAGE, DIRECTDEBITENABLED, CHECKENABLED, FORMITEMEXPIRATION, ACKNOWLEDGEMENTHTML, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, FORCESTARTDATE, PDACCOUNTSYSTEMID,SUPPORTSCHECKOUTONLY)
    values
        (@ID, @CHILDDISPLAYHTML, @PROJECTDISPLAYHTML, @ATTRIBUTEITEMSLIST, @DESIGNATIONLIST, @DEFAULTDESIGNATIONID, @DEFAULTDESIGNATION, @APPEALSLIST, @REQUIREAPPEAL, @SOLESPONSORSHIPENABLED, @GIFTSPONSORSHIPENABLED, @ECARDSENABLED, @ADDITIONALGIFTENABLED, @MULTIPLEGIFTSENABLED, @MINIMUMGIFTAMOUNT, @CONSTITUENCYID, @GENERALRECURRENCEENABLED, @SCHEDULEDENDDATEENABLED, @RECURRENCEDATAIDLIST, @ITEMEXPIRATION, @PAYMENTPARTPAGE, @DIRECTDEBITENABLED, @CHECKENABLED, @FORMITEMEXPIRATION, @ACKNOWLEDGEMENTHTML, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE,@FORCESTARTDATE, @PDACCOUNTSYSTEMID,@SUPPORTSCHECKOUTONLY)
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0