USP_RESERVATIONRATESCALE_UPDATE

Executes the "Reservation Rate Scale Update" 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_RESERVATIONRATESCALE_UPDATE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as 
                begin

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

                    declare @CURRENTDATE datetime
                    set @CURRENTDATE = getdate()

                    declare @RATESCALEID uniqueidentifier = null
                    select
                        @RATESCALEID = RATESCALEID
                    from dbo.RESERVATIONRATESCALE
                    where ID = @ID                    

                    if @RATESCALEID is not null
                    begin                        
                        exec USP_RESERVATIONRATESCALE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;                    
                        exec dbo.USP_RESERVATION_UPDATERATESCALE @ID, @RATESCALEID, @CHANGEAGENTID, @CURRENTDATE;
                        exec dbo.USP_RESERVATION_UPDATEFLATRATE @ID, @CHANGEAGENTID, @CURRENTDATE;
                    end

                    return 0;

                end