USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS

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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS
(
    @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)
)
as
    set nocount on;

  declare @FORCESTARTDATE bit;

  exec USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPFORMCMSSETTINGS
    @ID = @ID,
    @FORCESTARTDATE = @FORCESTARTDATE output;

  exec USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPFORMCMSSETTINGS_2
      @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;

  return 0;