USP_DATAFORMTEMPLATE_PRELOAD_ADD_RESERVATION

The load procedure used by the edit dataform template "Reservation Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DEPOSITREQUIRED	bit	INOUT	Reservation deposit required
@DEPOSITTIMEVALUE	smallint	INOUT
@DEPOSITTIMECODE	tinyint	INOUT
@DEPOSITTYPECODE	tinyint	INOUT
@DEPOSITAMOUNT	money	INOUT	Reservation deposit amount
@DEPOSITPERCENT	decimal(5, 2)	INOUT	Reservation deposit amount
@FINALTIMEVALUE	smallint	INOUT
@FINALTIMECODE	tinyint	INOUT
@CHECKCAPACITY	bit	INOUT	Check capacity
@CONTRACTREQUIRED	bit	INOUT	Contract required
@CONTRACTTIMEVALUE	smallint	INOUT
@CONTRACTTIMECODE	tinyint	INOUT
@FINALCOUNTREQUIRED	bit	INOUT	Final count required
@FINALCOUNTTIMEVALUE	smallint	INOUT
@FINALCOUNTTIMECODE	tinyint	INOUT
@PRICINGCODE	tinyint	INOUT	Pricing structure
@RATESCALEID	uniqueidentifier	INOUT	Flat rate scale
@RATESCALEPRICES	xml	INOUT
@DAILYADMISSIONDEFAULTARRIVALTIME	UDT_HOURMINUTE	INOUT
@DAILYADMISSIONDEFAULTDEPARTURETIME	UDT_HOURMINUTE	INOUT
@SECURITYDEPOSITREQUIRED	bit	INOUT	Security deposit required
@SECURITYDEPOSITTIMEVALUE	smallint	INOUT
@SECURITYDEPOSITTIMECODE	tinyint	INOUT
@SECURITYDEPOSITTYPECODE	tinyint	INOUT
@SECURITYDEPOSITAMOUNT	money	INOUT	Security deposit amount
@SECURITYDEPOSITPERCENT	decimal(5, 2)	INOUT	Security deposit amount

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_RESERVATION
(
    @DEPOSITREQUIRED bit = null output,
    @DEPOSITTIMEVALUE smallint = null output,
    @DEPOSITTIMECODE tinyint = null output,
    @DEPOSITTYPECODE tinyint = null output,
    @DEPOSITAMOUNT money = null output,
    @DEPOSITPERCENT decimal(5,2) = null output,
    @FINALTIMEVALUE smallint = null output,
    @FINALTIMECODE tinyint = null output,
    @CHECKCAPACITY bit = null output,
    @CONTRACTREQUIRED bit = null output,
    @CONTRACTTIMEVALUE smallint = null output,
    @CONTRACTTIMECODE tinyint = null output,
    @FINALCOUNTREQUIRED bit = null output,
    @FINALCOUNTTIMEVALUE smallint = null output,
    @FINALCOUNTTIMECODE tinyint = null output,
    @PRICINGCODE tinyint = null output,
    @RATESCALEID uniqueidentifier = null output,
    @RATESCALEPRICES xml = null output,
    @DAILYADMISSIONDEFAULTARRIVALTIME dbo.UDT_HOURMINUTE = null output,
    @DAILYADMISSIONDEFAULTDEPARTURETIME dbo.UDT_HOURMINUTE = null output,
    @SECURITYDEPOSITREQUIRED bit = null output,
    @SECURITYDEPOSITTIMEVALUE smallint = null output,
    @SECURITYDEPOSITTIMECODE tinyint = null output,
    @SECURITYDEPOSITTYPECODE tinyint = null output,
    @SECURITYDEPOSITAMOUNT money = null output,
    @SECURITYDEPOSITPERCENT decimal(5,2) = null output
)
as
    set nocount on; 

    select top 1
        @DEPOSITREQUIRED = DEPOSITREQUIRED,
        @DEPOSITTIMEVALUE = DEPOSITTIMEVALUE,
        @DEPOSITTIMECODE = DEPOSITTIMECODE,
        @DEPOSITTYPECODE = DEPOSITTYPECODE,
        @DEPOSITAMOUNT = DEPOSITAMOUNT,
        @DEPOSITPERCENT = DEPOSITPERCENT,
        @FINALTIMEVALUE = FINALTIMEVALUE,
        @FINALTIMECODE = FINALTIMECODE,
        @CONTRACTREQUIRED = CONTRACTREQUIRED,
        @CONTRACTTIMEVALUE = CONTRACTTIMEVALUE,
        @CONTRACTTIMECODE = CONTRACTTIMECODE,
        @FINALCOUNTREQUIRED = FINALCOUNTREQUIRED,
        @FINALCOUNTTIMEVALUE = FINALCOUNTTIMEVALUE,
        @FINALCOUNTTIMECODE = FINALCOUNTTIMECODE,
        @PRICINGCODE = USEFLATRATEPRICING,
        @CHECKCAPACITY = case when (MAXIMUMCAPACITY > 0) then  1 else 0 end,
        @DAILYADMISSIONDEFAULTARRIVALTIME = ITEMARRIVALTIME,
        @DAILYADMISSIONDEFAULTDEPARTURETIME = ITEMDEPARTURETIME,
        @SECURITYDEPOSITREQUIRED = SECURITYDEPOSITREQUIRED,
        @SECURITYDEPOSITTIMEVALUE = SECURITYDEPOSITTIMEVALUE,
        @SECURITYDEPOSITTIMECODE = SECURITYDEPOSITTIMECODE,
        @SECURITYDEPOSITTYPECODE = SECURITYDEPOSITTYPECODE,
        @SECURITYDEPOSITAMOUNT = SECURITYDEPOSITAMOUNT,
        @SECURITYDEPOSITPERCENT = SECURITYDEPOSITPERCENT
    from dbo.GROUPSALESDEFAULT    

    select top 1 @RATESCALEID = ID from dbo.RATESCALE where ISDEFAULT = 1;

    set @RATESCALEPRICES = (
        select
            RATESCALEID,
            AMOUNT,
            GROUPMINIMUM,
            GROUPMAXIMUM,
            USEPERTICKETAFTERMAX
        from
            dbo.RATESCALEPRICE
            inner join dbo.RATESCALE on RATESCALE.ID = RATESCALEPRICE.RATESCALEID
        for xml raw('ITEM'), type, elements, root('RATESCALEPRICES'), binary base64
    );

    return 0;