USP_DATAFORMTEMPLATE_EDIT_MARKALLASATTENDED

The save procedure used by the edit dataform template "Registrant Mark All As Attended 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.
@INCLUDESUBEVENTS	int	IN	Include sub-events

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MARKALLASATTENDED (
              @ID uniqueidentifier,
              @CHANGEAGENTID uniqueidentifier = null,
              @INCLUDESUBEVENTS integer
          )
          as

              set nocount on;

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

              declare @CURRENTDATE datetime
              set @CURRENTDATE = getdate()

              begin try
                update
                  dbo.REGISTRANT
              set
                  ATTENDED = 1
                  ,CHANGEDBYID = @CHANGEAGENTID
                  ,DATECHANGED = getdate()
              where
                  ((EVENTID = @ID and @INCLUDESUBEVENTS = 0)
                  or (EVENTID in (select ID from dbo.UFN_EVENT_GETALLEVENTSINHIERARCHY(@ID)) and @INCLUDESUBEVENTS = 1))
                  and (ATTENDED = 0)
                  and (WILLNOTATTEND = 0)
                  and (dbo.UFN_REGISTRANT_ISCANCELLED(REGISTRANT.ID) = 0)
            end try
              begin catch
                  exec dbo.USP_RAISE_ERROR
                  return 1
              end catch

          return 0;