USP_DATAFORMTEMPLATE_EDIT_BLOCK_CLASS_MEETING_TEMPLATE

The save procedure used by the edit dataform template "Class Meeting Template Block Edit Data 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.
@PATTERNBLOCKID	uniqueidentifier	IN	Change to

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BLOCK_CLASS_MEETING_TEMPLATE (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @PATTERNBLOCKID uniqueidentifier
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle updating the data

        update dbo.CLASSMEETINGGROUP set
            PATTERNBLOCKID = @PATTERNBLOCKID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where CLASSID = @ID and
            (PATTERNBLOCKID is null or PATTERNBLOCKID != @PATTERNBLOCKID)

        exec dbo.USP_CLASSMEETINGTEMPLATE_CREATEFROMBLOCK @ID, @PATTERNBLOCKID, @CHANGEAGENTID
        exec dbo.USP_CLASSMEETING_CREATEFROMTEMPLATES @ID, @CHANGEAGENTID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;