USP_REGISTRANT_CHECKINMARKASATTENDED

Executes the "Registrant Check In: Mark 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_REGISTRANT_CHECKINMARKASATTENDED
                        (
                            @ID uniqueidentifier,
                            @CHANGEAGENTID uniqueidentifier = null
                        )
                        as
                            set nocount on;

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

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

                            if (select ISCANCELLED from dbo.REGISTRANT where ID = @ID) = 1
                            begin
                                --Mark guests as not canceled

                                update
                                    dbo.REGISTRANT
                                set
                                    ISCANCELLED = 0,
                                    USERMARKEDATTENDANCE = 0, --if un-canceling, get rid of flag so not no-show

                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
                                where
                                    REGISTRANT.GUESTOFREGISTRANTID = @ID;
                            end


                            update dbo.REGISTRANT
                            set ATTENDED = 1,
                                USERMARKEDATTENDANCE = 1,
                                ISCANCELLED = 0,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE
                            where REGISTRANT.ID = @ID;

                            return 0;