USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPSTATUSCMSSETTINGS_4

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHILDHTMLCONTENT	nvarchar(max)	IN
@PROJECTHTMLCONTENT	nvarchar(max)	IN
@FILTERPROGRAM	bit	IN
@SELECTEDPROGRAMS	xml	IN
@NOTESAVAILABLILITYCODE	tinyint	IN
@NOTESCODESLIST	xml	IN
@ATTACHMENTSAVAILABILITYCODE	tinyint	IN
@ATTACHMENTCODESLIST	xml	IN
@MEDIALINKSAVAILABILITYCODE	tinyint	IN
@MEDIALINKCODESLIST	xml	IN
@EMAILENABLED	bit	IN
@EMAILCATEGORYID	uniqueidentifier	IN
@EMAILSUBCATEGORYID	uniqueidentifier	IN
@DEFAULTEMAILCATEGORYID	uniqueidentifier	IN
@DEFAULTEMAILSUBCATEGORYID	uniqueidentifier	IN
@DEFAULTEMAILADDRESS	UDT_EMAILADDRESS	IN
@EMAILTYPECODE	uniqueidentifier	IN
@EMAILFIELDLIMIT	int	IN
@EMAILTEMPLATESLIST	xml	IN
@EMAILPROGRAMLIST	xml	IN
@OUTPUTFIELDLIST	xml	IN
@PAYMENTPARTPAGE	int	IN
@SPONSORSHIPLISTFORMATCODE	tinyint	IN
@SUPPORTSCHECKOUTONLY	bit	IN

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPSTATUSCMSSETTINGS_4
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
  @CHILDHTMLCONTENT nvarchar(max),
  @PROJECTHTMLCONTENT nvarchar(max),
  @FILTERPROGRAM bit,
  @SELECTEDPROGRAMS xml,
  @NOTESAVAILABLILITYCODE tinyint,
  @NOTESCODESLIST xml,
  @ATTACHMENTSAVAILABILITYCODE tinyint,
  @ATTACHMENTCODESLIST xml,
  @MEDIALINKSAVAILABILITYCODE tinyint,
  @MEDIALINKCODESLIST xml,
  @EMAILENABLED bit,
  @EMAILCATEGORYID uniqueidentifier,
  @EMAILSUBCATEGORYID uniqueidentifier,
  @DEFAULTEMAILCATEGORYID uniqueidentifier,
  @DEFAULTEMAILSUBCATEGORYID uniqueidentifier,
  @DEFAULTEMAILADDRESS dbo.UDT_EMAILADDRESS,
  @EMAILTYPECODE uniqueidentifier,
  @EMAILFIELDLIMIT int,
  @EMAILTEMPLATESLIST xml,
  @EMAILPROGRAMLIST xml,
  @OUTPUTFIELDLIST xml,
  @PAYMENTPARTPAGE int,
  @SPONSORSHIPLISTFORMATCODE tinyint,
    @SUPPORTSCHECKOUTONLY bit
)
as

    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    begin try
        -- handle updating the data

        update dbo.SPONSORSHIPSTATUSCMSSETTINGS set
      CHILDHTMLCONTENT = @CHILDHTMLCONTENT,
      PROJECTHTMLCONTENT = @PROJECTHTMLCONTENT,
      FILTERPROGRAM = @FILTERPROGRAM,
      SELECTEDPROGRAMS = @SELECTEDPROGRAMS,
      NOTESAVAILABLILITYCODE = @NOTESAVAILABLILITYCODE,
      NOTESCODESLIST = @NOTESCODESLIST,
      ATTACHMENTSAVAILABILITYCODE = @ATTACHMENTSAVAILABILITYCODE,
      ATTACHMENTCODESLIST = @ATTACHMENTCODESLIST,
      MEDIALINKSAVAILABILITYCODE = @MEDIALINKSAVAILABILITYCODE,
      MEDIALINKCODESLIST = @MEDIALINKCODESLIST,
      EMAILENABLED = @EMAILENABLED,
      EMAILCATEGORYID = @EMAILCATEGORYID,
      EMAILSUBCATEGORYID = @EMAILSUBCATEGORYID,
      DEFAULTEMAILCATEGORYID = @DEFAULTEMAILCATEGORYID,
      DEFAULTEMAILSUBCATEGORYID = @DEFAULTEMAILSUBCATEGORYID,
      DEFAULTEMAILADDRESS = @DEFAULTEMAILADDRESS,
      EMAILTYPECODE = @EMAILTYPECODE,
      EMAILFIELDLIMIT = @EMAILFIELDLIMIT,
      EMAILTEMPLATESLIST = @EMAILTEMPLATESLIST,
      EMAILPROGRAMLIST = @EMAILPROGRAMLIST,
      OUTPUTFIELDLIST = @OUTPUTFIELDLIST,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate(),
      PAYMENTPARTPAGE = @PAYMENTPARTPAGE,
      SPONSORSHIPLISTFORMATCODE = @SPONSORSHIPLISTFORMATCODE,
            SUPPORTSCHECKOUTONLY=@SUPPORTSCHECKOUTONLY
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;