USP_DATAFORMTEMPLATE_EDIT_RESERVATION

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.
@NAME	nvarchar(100)	IN	Reservation name
@COMMENTS	nvarchar(1000)	IN	Comments
@FINALCOUNTDUEDATE	date	IN	Final count date
@FINALCOUNTREQUIRED	bit	IN	Final count required
@DEPOSITREQUIRED	bit	IN	Deposit required
@DEPOSITAMOUNT	money	IN	Amount due
@DEPOSITDUEDATE	date	IN	Deposit due date
@DEPOSITTYPECODE	tinyint	IN
@FINALDUEDATE	date	IN	Order balance due
@CONTRACTREQUIRED	bit	IN	Contract required
@CONTRACTDUEDATE	date	IN	Contract due date
@PRICINGCODE	tinyint	IN	Pricing structure
@RATESCALEID	uniqueidentifier	IN	Flat rate scale

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_RESERVATION
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @COMMENTS nvarchar(1000),
    @FINALCOUNTDUEDATE date,
    @FINALCOUNTREQUIRED bit,
    @DEPOSITREQUIRED bit,
    @DEPOSITAMOUNT money,
    @DEPOSITDUEDATE date,
    @DEPOSITTYPECODE tinyint,
    @FINALDUEDATE date,
    @CONTRACTREQUIRED bit,
    @CONTRACTDUEDATE date,
    @PRICINGCODE tinyint,
    @RATESCALEID uniqueidentifier
)

as
    set nocount on;

    declare @SECURITYDEPOSITREQUIRED bit;
    declare @SECURITYDEPOSITAMOUNT money;
    declare @SECURITYDEPOSITDUEDATE date;
    declare @SECURITYDEPOSITTYPECODE tinyint;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RESERVATION
        @ID = @ID,
        @SECURITYDEPOSITREQUIRED = @SECURITYDEPOSITREQUIRED output,
        @SECURITYDEPOSITAMOUNT = @SECURITYDEPOSITAMOUNT output,
        @SECURITYDEPOSITDUEDATE = @SECURITYDEPOSITDUEDATE output,
        @SECURITYDEPOSITTYPECODE = @SECURITYDEPOSITTYPECODE output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RESERVATION_1
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @COMMENTS,
        @FINALCOUNTDUEDATE,
        @FINALCOUNTREQUIRED,
        @DEPOSITREQUIRED,
        @DEPOSITAMOUNT,
        @DEPOSITDUEDATE,
        @DEPOSITTYPECODE,
        @FINALDUEDATE,
        @CONTRACTREQUIRED,
        @CONTRACTDUEDATE,
        @PRICINGCODE,
        @RATESCALEID,
        @SECURITYDEPOSITREQUIRED,
        @SECURITYDEPOSITAMOUNT,
        @SECURITYDEPOSITDUEDATE,
        @SECURITYDEPOSITTYPECODE

    return 0;