USP_RESERVATIONSTATUSHISTORY_ADD

Adds status history for a reservation.
Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@STATUSCODE	tinyint	IN
@COMMENTS	nvarchar(500)	IN
Definition

Copy


            CREATE procedure dbo.USP_RESERVATIONSTATUSHISTORY_ADD
            (
                @ID uniqueidentifier = null, --Reservation ID

                @CHANGEAGENTID uniqueidentifier = null,
                @STATUSCODE tinyint = null,
                @COMMENTS nvarchar(500) = ''
            )
            as
            begin
                declare @CURRENTDATE datetime = getdate()

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

                declare @CLIENTDATETIMEWITHOFFSET datetimeoffset = dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEWITHTIMEOFFSET(sysutcdatetime(), 1)

                insert into dbo.[RESERVATIONSTATUSHISTORY]
                (
                    [ID],
                    [RESERVATIONID],
                    [STATUSCODE],
                    [COMMENTS],
                    [STATUSDATE],
                    [STATUSDATEWITHOFFSET],
                    [ADDEDBYID],
                    [CHANGEDBYID],
                    [DATEADDED],
                    [DATECHANGED]
                )
                values
                (
                    newid(),
                    @ID,
                    @STATUSCODE,
                    @COMMENTS,
                    cast(@CLIENTDATETIMEWITHOFFSET as datetime),
                    @CLIENTDATETIMEWITHOFFSET,
                    @CHANGEAGENTID,
                    @CHANGEAGENTID,
                    @CURRENTDATE,
                    @CURRENTDATE
                )
            end