USP_HTMLTEMPLATETODOCXMERGEPROCESSOUTPUT_SAVE

Saves the output of the Html Template Merge to Docx process to the database.

Parameters

Parameter	Parameter Type	Mode
@HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID	uniqueidentifier	IN
@FILE	varbinary	IN
@ISARCHIVE	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
@FILENAME	nvarchar(105)	IN

Definition

Copy



CREATE procedure dbo.USP_HTMLTEMPLATETODOCXMERGEPROCESSOUTPUT_SAVE
(
    @HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID uniqueidentifier,
    @FILE varbinary(max),
    @ISARCHIVE bit,
    @CHANGEAGENTID uniqueidentifier = null,
    @FILENAME nvarchar(105) = ''
)
as
begin

    set nocount on;

    declare @CURRENTDATE datetime;

    begin try
    if @CHANGEAGENTID is null  
      exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

    set @CURRENTDATE = getdate();

    insert into dbo.[HTMLTEMPLATEMERGETODOCXOUTPUT] (
      [ID],
      [HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID],
      [FILE],
      [ISARCHIVE],
      [FILENAME],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    ) values (
      newid(),
      @HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID,
      @FILE,
      @ISARCHIVE,
      @FILENAME,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    );
    end try

    begin catch
        exec dbo.[USP_RAISE_ERROR];
        return 1;
    end catch

    return 0;


end