USP_DATAFORMTEMPLATE_ADD_LETTERTEMPLATE

The save procedure used by the add dataform template "Letter Template 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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@LETTERFILE	varbinary	IN	Letter
@LETTERFILENAME	nvarchar(255)	IN
@DISPLAYEDLETTERFILENAME	nvarchar(255)	IN	File
@LETTERTEMPLATETYPECODE	tinyint	IN	Letter type
@QUERYVIEWID	uniqueidentifier	IN	Output format
@CUSTOMPARAMETERDATAFORMITEM	xml	IN
@SITEID	uniqueidentifier	IN	Site
@EXPORTDEFINITIONID	uniqueidentifier	IN	Export definition

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_LETTERTEMPLATE
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier,
    @NAME nvarchar(100) = null,
    @DESCRIPTION nvarchar(255) = null,
    @LETTERFILE varbinary(max) = null,
    @LETTERFILENAME nvarchar(255) = null,
    @DISPLAYEDLETTERFILENAME nvarchar(255) = null,
    @LETTERTEMPLATETYPECODE tinyint = 0,
    @QUERYVIEWID uniqueidentifier = null,
    @CUSTOMPARAMETERDATAFORMITEM xml = null,
    @SITEID uniqueidentifier = null,
    @EXPORTDEFINITIONID uniqueidentifier = null
)
as
    set nocount on;

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getDate();

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

    if @ID is null
        set @ID = newID();

    begin try
        insert into dbo.LETTERTEMPLATE
        (
            ID,
            NAME,
            DESCRIPTION,
            LETTERFILE,
            LETTERFILENAME,
            LETTERTEMPLATETYPECODE,
            QUERYVIEWID,
            CUSTOMPARAMETERDATAFORMITEM,
            SITEID,
            ADDEDBYID,
            CHANGEDBYID,
            DATEADDED,
            DATECHANGED,
            EXPORTDEFINITIONID
        )
        values
        (
            @ID,
            @NAME,
            @DESCRIPTION,
            @LETTERFILE,
            @DISPLAYEDLETTERFILENAME,
            @LETTERTEMPLATETYPECODE,
            @QUERYVIEWID,
            @CUSTOMPARAMETERDATAFORMITEM,
            @SITEID,
            @CHANGEAGENTID,
            @CHANGEAGENTID,
            @CURRENTDATE,
            @CURRENTDATE,
            @EXPORTDEFINITIONID
        );

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch;

    return 0;