USP_DATAFORMTEMPLATE_EDIT_COMMITMULTIPLEBATCHESPROCESS

The save procedure used by the edit dataform template "Commit Multiple Batches Edit Form".

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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(1000)	IN	Description
@SELECTIONID	uniqueidentifier	IN	Selection
@CREATEOUTPUTSELECTION	bit	IN	Create output selections
@CREATEEXCEPTIONBATCHES	bit	IN	Create exception batches
@PURGEBATCHES	bit	IN	Delete batches after commit
@CREATEBATCHCONTROLREPORTS	bit	IN	Create control reports

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_COMMITMULTIPLEBATCHESPROCESS
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@NAME nvarchar(100),
@DESCRIPTION nvarchar(1000),
@SELECTIONID uniqueidentifier,
@CREATEOUTPUTSELECTION bit,
@CREATEEXCEPTIONBATCHES bit,
@PURGEBATCHES bit,
@CREATEBATCHCONTROLREPORTS bit
)
as
begin
    set nocount on;

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

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

        update dbo.BATCHESCOMMITPROCESS set
            BATCHESCOMMITPROCESS.NAME = @NAME,
            BATCHESCOMMITPROCESS.DESCRIPTION = @DESCRIPTION,
            BATCHESCOMMITPROCESS.SELECTIONID = @SELECTIONID,
            BATCHESCOMMITPROCESS.CREATEOUTPUTSELECTION = @CREATEOUTPUTSELECTION,
            BATCHESCOMMITPROCESS.CREATEEXCEPTIONBATCHES = @CREATEEXCEPTIONBATCHES,
            BATCHESCOMMITPROCESS.PURGEBATCHES = @PURGEBATCHES,
            BATCHESCOMMITPROCESS.CREATEBATCHCONTROLREPORTS = @CREATEBATCHCONTROLREPORTS,
      BATCHESCOMMITPROCESS.DATECHANGED = @CURRENTDATE,   
      BATCHESCOMMITPROCESS.CHANGEDBYID = @CHANGEAGENTID
        where BATCHESCOMMITPROCESS.ID = @ID;
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

    return 0;

end