USP_EVENTREGISTRANTMARKALLASATTENDED_UPDATE

Executes the "Event: Mark Registrants As Attended" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



create procedure dbo.USP_EVENTREGISTRANTMARKALLASATTENDED_UPDATE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null
)
as
    set nocount on;

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

    update
        dbo.REGISTRANT
    set
        ATTENDED = 1
        ,CHANGEDBYID = @CHANGEAGENTID
        ,DATECHANGED = getdate()
    where
        (EVENTID = @ID)
        and (ATTENDED = 0)
        and (WILLNOTATTEND = 0)
        and (dbo.UFN_REGISTRANT_ISCANCELLED(REGISTRANT.ID) = 0)

    return 0;