USP_DATAFORMTEMPLATE_EDITLOAD_GROUPSALESDEFAULT

The load procedure used by the edit dataform template "Group Sales Default Edit Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@DEPOSITREQUIRED	bit	INOUT	Reservation deposit required
@DEPOSITTIMEVALUE	smallint	INOUT	Due date
@DEPOSITTIMECODE	tinyint	INOUT
@DEPOSITTYPECODE	tinyint	INOUT	Type
@DEPOSITAMOUNT	money	INOUT	Value
@DEPOSITPERCENT	decimal(5, 2)	INOUT	Value
@CONTRACTREQUIRED	bit	INOUT	Contract required
@CONTRACTTIMEVALUE	smallint	INOUT	Due date
@CONTRACTTIMECODE	tinyint	INOUT
@CONTRACTLETTERTEMPLATEID	uniqueidentifier	INOUT	Default template
@CONTRACTRESERVATIONATTACHMENTTYPECODEID	uniqueidentifier	INOUT	Attachment type
@FINALCOUNTREQUIRED	bit	INOUT	Final count required
@FINALCOUNTTIMEVALUE	smallint	INOUT	Due date
@FINALCOUNTTIMECODE	tinyint	INOUT
@FINALTIMEVALUE	smallint	INOUT	Balance due
@FINALTIMECODE	tinyint	INOUT
@FINALTIMEWITHDEPOSITCODE	tinyint	INOUT
@FINALTIMEWITHOUTDEPOSITCODE	tinyint	INOUT
@SECURITYDEPOSITREQUIRED	bit	INOUT	Security deposit required
@SECURITYDEPOSITTIMEVALUE	smallint	INOUT	Due date
@SECURITYDEPOSITTIMECODE	tinyint	INOUT
@SECURITYDEPOSITTYPECODE	tinyint	INOUT	Type
@SECURITYDEPOSITAMOUNT	money	INOUT	Value
@SECURITYDEPOSITPERCENT	decimal(5, 2)	INOUT	Value

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GROUPSALESDEFAULT
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @TSLONG bigint = 0 output,
                    @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,
                    @CONTRACTREQUIRED bit = null output,
                    @CONTRACTTIMEVALUE smallint = null output,
                    @CONTRACTTIMECODE tinyint = null output,
                    @CONTRACTLETTERTEMPLATEID uniqueidentifier = null output,
                    @CONTRACTRESERVATIONATTACHMENTTYPECODEID uniqueidentifier = null output,
                    @FINALCOUNTREQUIRED bit = null output,
                    @FINALCOUNTTIMEVALUE smallint = null output,
                    @FINALCOUNTTIMECODE tinyint = null output,
                    @FINALTIMEVALUE smallint = null output,
                    @FINALTIMECODE tinyint = null output,
                    @FINALTIMEWITHDEPOSITCODE tinyint = null output,
                    @FINALTIMEWITHOUTDEPOSITCODE tinyint = 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;

                    set @DATALOADED = 0
                    set @TSLONG = 0

                    select
                        @DATALOADED = 1,
                        @TSLONG = TSLONG,
                        @DEPOSITREQUIRED = DEPOSITREQUIRED,
                        @DEPOSITTIMEVALUE = DEPOSITTIMEVALUE,
                        @DEPOSITTIMECODE = DEPOSITTIMECODE,
                        @DEPOSITTYPECODE = DEPOSITTYPECODE,
                        @DEPOSITAMOUNT = DEPOSITAMOUNT,
                        @DEPOSITPERCENT = DEPOSITPERCENT,
                        @CONTRACTREQUIRED = CONTRACTREQUIRED,
                        @CONTRACTTIMEVALUE = CONTRACTTIMEVALUE,
                        @CONTRACTTIMECODE = CONTRACTTIMECODE,
                        @CONTRACTLETTERTEMPLATEID = CONTRACTLETTERTEMPLATEID,
                        @CONTRACTRESERVATIONATTACHMENTTYPECODEID = CONTRACTRESERVATIONATTACHMENTTYPECODEID,
                        @FINALCOUNTREQUIRED = FINALCOUNTREQUIRED,
                        @FINALCOUNTTIMEVALUE = FINALCOUNTTIMEVALUE,
                        @FINALCOUNTTIMECODE = FINALCOUNTTIMECODE,
                        @FINALTIMEVALUE = FINALTIMEVALUE,
                        @FINALTIMECODE = FINALTIMECODE,
                        @SECURITYDEPOSITREQUIRED = SECURITYDEPOSITREQUIRED,
                        @SECURITYDEPOSITTIMEVALUE = SECURITYDEPOSITTIMEVALUE,
                        @SECURITYDEPOSITTIMECODE = SECURITYDEPOSITTIMECODE,
                        @SECURITYDEPOSITTYPECODE = SECURITYDEPOSITTYPECODE,
                        @SECURITYDEPOSITAMOUNT = SECURITYDEPOSITAMOUNT,
                        @SECURITYDEPOSITPERCENT = SECURITYDEPOSITPERCENT
                    from dbo.GROUPSALESDEFAULT
                    where ID = @ID

                    if @DATALOADED = 1
                    begin
                        set @FINALTIMEWITHDEPOSITCODE = 0
                        set @FINALTIMEWITHOUTDEPOSITCODE = 0

                        -- Set both for the case of toggling Deposit required checkbox

                        -- Try to keep Final time codes consisted with deposit required checkbox

                        set @FINALTIMEWITHDEPOSITCODE = @FINALTIMECODE
                        if @FINALTIMECODE <> 2 or @DEPOSITREQUIRED = 0
                            set @FINALTIMEWITHOUTDEPOSITCODE = @FINALTIMECODE
                    end

                return 0;