USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPSTATUSCMSSETTINGS

The save procedure used by the add dataform template "SponsorshipStatusCMSSettings 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.
@CHILDHTMLCONTENT	nvarchar(max)	IN	ChildHtmlcontent
@PROJECTHTMLCONTENT	nvarchar(max)	IN	ProjectHtmlContent
@FILTERPROGRAM	bit	IN	Filterprogram
@SELECTEDPROGRAMS	xml	IN	Selectedprograms
@NOTESAVAILABLILITYCODE	tinyint	IN	Notesavailablility
@NOTESCODESLIST	xml	IN	Notescodeslist
@ATTACHMENTSAVAILABILITYCODE	tinyint	IN	Attachmentsavailability
@ATTACHMENTCODESLIST	xml	IN	Attachmentcodeslist
@MEDIALINKSAVAILABILITYCODE	tinyint	IN	Medialinksavailability
@MEDIALINKCODESLIST	xml	IN	Medialinkcodeslist
@EMAILENABLED	bit	IN	Emailenabled
@EMAILCATEGORYID	uniqueidentifier	IN	Emailcategoryid
@EMAILSUBCATEGORYID	uniqueidentifier	IN	Emailsubcategoryid
@DEFAULTEMAILCATEGORYID	uniqueidentifier	IN	Defaultemailcategoryid
@DEFAULTEMAILSUBCATEGORYID	uniqueidentifier	IN	Defaultemailsubcategoryid
@DEFAULTEMAILADDRESS	UDT_EMAILADDRESS	IN	Defaultemailaddress
@EMAILTYPECODE	uniqueidentifier	IN	Emailtypecode
@EMAILFIELDLIMIT	int	IN	Emailfieldlimit
@EMAILTEMPLATESLIST	xml	IN	EmailTEMPLATeslist
@EMAILPROGRAMLIST	xml	IN	Emailprogramlist
@OUTPUTFIELDLIST	xml	IN	Outputfieldlist
@PAYMENTPARTPAGE	int	IN
@SPONSORSHIPLISTFORMATCODE	tinyint	IN
@SUPPORTSCHECKOUTONLY	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPSTATUSCMSSETTINGS
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @CHILDHTMLCONTENT nvarchar(max) = '',
    @PROJECTHTMLCONTENT nvarchar(max) = '',
    @FILTERPROGRAM bit = 0,
    @SELECTEDPROGRAMS xml = null,
    @NOTESAVAILABLILITYCODE tinyint = 0,
    @NOTESCODESLIST xml = null,
    @ATTACHMENTSAVAILABILITYCODE tinyint = 0,
    @ATTACHMENTCODESLIST xml = null,
    @MEDIALINKSAVAILABILITYCODE tinyint = 0,
    @MEDIALINKCODESLIST xml = null,
    @EMAILENABLED bit = 0,
    @EMAILCATEGORYID uniqueidentifier = null,
    @EMAILSUBCATEGORYID uniqueidentifier =null,
    @DEFAULTEMAILCATEGORYID uniqueidentifier = null,
    @DEFAULTEMAILSUBCATEGORYID uniqueidentifier =null,
    @DEFAULTEMAILADDRESS dbo.UDT_EMAILADDRESS = null,
    @EMAILTYPECODE uniqueidentifier = null,
    @EMAILFIELDLIMIT int = 0,
    @EMAILTEMPLATESLIST xml = null,
    @EMAILPROGRAMLIST xml =null,
    @OUTPUTFIELDLIST xml = null,
    @PAYMENTPARTPAGE int = null,
    @SPONSORSHIPLISTFORMATCODE tinyint = 0,
        @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.SPONSORSHIPSTATUSCMSSETTINGS
        (ID, CHILDHTMLCONTENT, PROJECTHTMLCONTENT, FILTERPROGRAM, SELECTEDPROGRAMS, NOTESAVAILABLILITYCODE, NOTESCODESLIST, ATTACHMENTSAVAILABILITYCODE, ATTACHMENTCODESLIST, MEDIALINKSAVAILABILITYCODE, MEDIALINKCODESLIST, EMAILENABLED, EMAILCATEGORYID, EMAILSUBCATEGORYID, DEFAULTEMAILCATEGORYID, DEFAULTEMAILSUBCATEGORYID, DEFAULTEMAILADDRESS, EMAILTYPECODE, EMAILFIELDLIMIT, EMAILTEMPLATESLIST, EMAILPROGRAMLIST, OUTPUTFIELDLIST, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, PAYMENTPARTPAGE, SPONSORSHIPLISTFORMATCODE,SUPPORTSCHECKOUTONLY)
    values
        (@ID, @CHILDHTMLCONTENT,@PROJECTHTMLCONTENT, @FILTERPROGRAM, @SELECTEDPROGRAMS, @NOTESAVAILABLILITYCODE, @NOTESCODESLIST, @ATTACHMENTSAVAILABILITYCODE, @ATTACHMENTCODESLIST, @MEDIALINKSAVAILABILITYCODE, @MEDIALINKCODESLIST, @EMAILENABLED, @EMAILCATEGORYID, @EMAILSUBCATEGORYID, @DEFAULTEMAILCATEGORYID, @DEFAULTEMAILSUBCATEGORYID, @DEFAULTEMAILADDRESS, @EMAILTYPECODE, @EMAILFIELDLIMIT, @EMAILTEMPLATESLIST, @EMAILPROGRAMLIST, @OUTPUTFIELDLIST, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE, @PAYMENTPARTPAGE, @SPONSORSHIPLISTFORMATCODE,@SUPPORTSCHECKOUTONLY)
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0