USP_DATAFORMTEMPLATE_EDIT_MARKSTEWARDSHIPPLANSTEPCOMPLETE_2

The save procedure used by the edit dataform template "Mark Stewardship Plan Step Complete 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.
@ACTUALDATE	datetime	IN	Actual date
@NEXTDATE	datetime	IN	Next date
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN	Start time
@ACTUALENDTIME	UDT_HOURMINUTE	IN	End time

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MARKSTEWARDSHIPPLANSTEPCOMPLETE_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @ACTUALDATE datetime,
    @NEXTDATE datetime,
    @ACTUALSTARTTIME dbo.UDT_HOURMINUTE,
    @ACTUALENDTIME dbo.UDT_HOURMINUTE
) as begin
    set nocount on;

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

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

    -- Update step and child step if one exists

    update dbo.STEWARDSHIPPLANSTEP set
        STATUSCODE = 1,
        ACTUALDATE = @ACTUALDATE,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = @CHANGEDATE,
        ACTUALSTARTTIME = @ACTUALSTARTTIME,
        ACTUALENDTIME = @ACTUALENDTIME
    where
        ID = @ID;

    -- Handle recursion            

    if not @NEXTDATE is null 
        exec dbo.USP_STEWARDSHIPPLAN_CLONERECURRINGCOMPLETEDSTEP @ID, @NEXTDATE, @CHANGEAGENTID, @CHANGEDATE;

    return 0;

end