USP_DATAFORMTEMPLATE_EDIT_WORKFLOW_TASK

The save procedure used by the edit dataform template "Workflow Task 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.
@BBWORKFLOWINSTANCEINFOID	uniqueidentifier	IN	Bbworkflowinstanceinfo
@WORKFLOWINBOXID	uniqueidentifier	IN	Workflowinbox
@TASKSUBJECT	nvarchar(255)	IN	Tasksubject
@TASKDESCRIPTION	nvarchar(max)	IN	Taskdescription
@COMPLETED	bit	IN	Completed
@DATEASSIGNED	datetime	IN	Dateassigned
@DATEDUE	datetime	IN	Datedue
@DATECOMPLETED	datetime	IN	Datecompleted
@CATEGORY	nvarchar(50)	IN	Category

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_WORKFLOW_TASK
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @BBWORKFLOWINSTANCEINFOID uniqueidentifier,
    @WORKFLOWINBOXID uniqueidentifier,
    @TASKSUBJECT nvarchar(255),
    @TASKDESCRIPTION nvarchar(max),
    @COMPLETED bit,
    @DATEASSIGNED datetime,
    @DATEDUE datetime,
    @DATECOMPLETED datetime,
    @CATEGORY nvarchar(50)
)
as

    set nocount on;

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

    begin try
        -- handle updating the data

        update dbo.BBWORKFLOWTASK set
            BBWORKFLOWINSTANCEINFOID = @BBWORKFLOWINSTANCEINFOID,
            BBWORKFLOWINBOXID = @WORKFLOWINBOXID,
            TASKSUBJECT = @TASKSUBJECT,
            TASKDESCRIPTION = @TASKDESCRIPTION,
            COMPLETED = @COMPLETED,
            DATEASSIGNED = @DATEASSIGNED,
            DATEDUE = @DATEDUE,
            DATECOMPLETED = @DATECOMPLETED,
            CATEGORY = @CATEGORY,

            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;