USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS_2

The save procedure used by the edit dataform template "SponsorshipFormCMSSettings Edit 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.
@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

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CHILDDISPLAYHTML nvarchar(max),
    @PROJECTDISPLAYHTML nvarchar(max),
    @ATTRIBUTEITEMSLIST xml,
    @DESIGNATIONLIST xml,
    @DEFAULTDESIGNATIONID uniqueidentifier,
    @DEFAULTDESIGNATION int,
    @APPEALSLIST xml,
    @REQUIREAPPEAL bit,
    @SOLESPONSORSHIPENABLED bit,
    @GIFTSPONSORSHIPENABLED bit,
    @ECARDSENABLED bit,
    @ADDITIONALGIFTENABLED bit,
    @MULTIPLEGIFTSENABLED bit,
    @MINIMUMGIFTAMOUNT decimal(20,4),
    @CONSTITUENCYID uniqueidentifier,
    @GENERALRECURRENCEENABLED bit,
    @SCHEDULEDENDDATEENABLED bit,
    @RECURRENCEDATAIDLIST xml,
    @ITEMEXPIRATION int,
    @PAYMENTPARTPAGE int,
    @DIRECTDEBITENABLED bit,
    @CHECKENABLED bit,
    @FORMITEMEXPIRATION int,
    @ACKNOWLEDGEMENTHTML nvarchar(max),
    @FORCESTARTDATE bit
)

as
  set nocount on;

    declare @PDACCOUNTSYSTEMID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPFORMCMSSETTINGS
        @ID = @ID,
        @PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS_3
        @ID,
        @CHANGEAGENTID,
        @CHILDDISPLAYHTML,
        @PROJECTDISPLAYHTML,
        @ATTRIBUTEITEMSLIST,
        @DESIGNATIONLIST,
        @DEFAULTDESIGNATIONID,
        @DEFAULTDESIGNATION,
        @APPEALSLIST,
        @REQUIREAPPEAL,
        @SOLESPONSORSHIPENABLED,
        @GIFTSPONSORSHIPENABLED,
        @ECARDSENABLED,
        @ADDITIONALGIFTENABLED,
        @MULTIPLEGIFTSENABLED,
        @MINIMUMGIFTAMOUNT,
        @CONSTITUENCYID,
        @GENERALRECURRENCEENABLED,
        @SCHEDULEDENDDATEENABLED,
        @RECURRENCEDATAIDLIST,
        @ITEMEXPIRATION,
        @PAYMENTPARTPAGE,
        @DIRECTDEBITENABLED,
        @CHECKENABLED,
        @FORMITEMEXPIRATION,
        @ACKNOWLEDGEMENTHTML,
        @FORCESTARTDATE,
        @PDACCOUNTSYSTEMID

  return 0;