USP_DATAFORMTEMPLATE_ADD_RESERVATIONCONTRACT_PRELOAD

The load procedure used by the edit dataform template "Group Sales Contract Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@RESERVATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@NAME	nvarchar(50)	INOUT	Name
@LETTERTEMPLATEID	uniqueidentifier	INOUT	Contract template
@RESERVATIONATTACHMENTTYPECODEID	uniqueidentifier	INOUT	Attachment type
@DEPOSITREQUIRED	bit	INOUT
@DEPOSITAMOUNT	money	INOUT	Amount due
@HASCONTRACT	bit	INOUT
@DEPOSITDUEDATE	date	INOUT	Deposit due date
@DEFAULTDEPOSITTYPECODE	tinyint	INOUT
@DEFAULTDEPOSITAMOUNT	money	INOUT
@DEFAULTDEPOSITPERCENT	decimal(5, 2)	INOUT
@ORDERTOTAL	money	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RESERVATIONCONTRACT_PRELOAD
                    (
                        @RESERVATIONID uniqueidentifier,
                        @NAME nvarchar(50) = null output,
                        @LETTERTEMPLATEID uniqueidentifier = null output,
                        @RESERVATIONATTACHMENTTYPECODEID uniqueidentifier = null output,
                        @DEPOSITREQUIRED bit = null output,
                        @DEPOSITAMOUNT money = null output,
                        @HASCONTRACT bit = null output,
                        @DEPOSITDUEDATE date = null output,
                        @DEFAULTDEPOSITTYPECODE tinyint = null output,
                        @DEFAULTDEPOSITAMOUNT money = null output,
                        @DEFAULTDEPOSITPERCENT decimal(5,2) = null output,
                        @ORDERTOTAL money = null output
                    )
                    as
                        set nocount on;

                        select top 1
                            @LETTERTEMPLATEID = CONTRACTLETTERTEMPLATEID,
                            @RESERVATIONATTACHMENTTYPECODEID = CONTRACTRESERVATIONATTACHMENTTYPECODEID
                        from
                            dbo.GROUPSALESDEFAULT
                        where
                            CONTRACTREQUIRED = 1;

                        select
                            @NAME = NAMEFORMAT.NAME,
                            @DEPOSITREQUIRED = RESERVATION.DEPOSITREQUIRED,
                            @DEPOSITAMOUNT = RESERVATION.DEPOSITAMOUNT,
                            @DEPOSITDUEDATE = RESERVATION.DEPOSITDUEDATE,
                            @ORDERTOTAL = dbo.UFN_SALESORDER_TOTAL(SALESORDER.ID)
                        from
                            dbo.RESERVATION
                        inner join
                            dbo.SALESORDER on RESERVATION.ID = SALESORDER.ID
                        outer apply
                            dbo.UFN_CONSTITUENT_DISPLAYNAME(SALESORDER.CONSTITUENTID) as NAMEFORMAT
                        where RESERVATION.ID = @RESERVATIONID;

                        if dbo.UFN_RESERVATIONATTACHMENT_CONTRACTCOUNT(@RESERVATIONID) = 0
                            set @HASCONTRACT = 0;
                        else
                            set @HASCONTRACT = 1;

                        select top 1
                            @DEFAULTDEPOSITTYPECODE = DEPOSITTYPECODE,
                            @DEFAULTDEPOSITAMOUNT = DEPOSITAMOUNT,
                            @DEFAULTDEPOSITPERCENT = DEPOSITPERCENT
                        from
                            dbo.GROUPSALESDEFAULT
                        where
                            DEPOSITREQUIRED = 1;

                        return 0;