USP_DATAFORMTEMPLATE_VIEW_LODGINGLOCATION

The load procedure used by the view dataform template "Lodging Location View 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.
@DISCOUNTCODE	nvarchar(20)	INOUT	Discount code
@ROOMINFORMATION	nvarchar(max)	INOUT	Room types
@COMMENT	nvarchar(max)	INOUT	Comment

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_LODGINGLOCATION
          (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @DISCOUNTCODE nvarchar(20) = null output,
            @ROOMINFORMATION nvarchar(max) = null output,
            @COMMENT nvarchar(max) = null output
          )

          as

          set nocount on;

          -- be sure to set this, in case the select returns no rows

          set @DATALOADED = 0;

            select
              @DATALOADED = 1,
              @DISCOUNTCODE = EVENTLODGINGLOCATION.DISCOUNTCODE,
              @COMMENT = EVENTLODGINGLOCATION.COMMENT
            from
              dbo.EVENTLODGINGLOCATION
            where 
              EVENTLODGINGLOCATION.ID = @ID

            set @ROOMINFORMATION = ''
            select
                @ROOMINFORMATION = @ROOMINFORMATION + (dbo.UFN_EVENTLODGINGROOMTYPECODE_GETDESCRIPTION(EVENTLODGINGLOCATIONROOMTYPE.EVENTLODGINGROOMTYPECODEID)) + ', '
            from
                dbo.EVENTLODGINGLOCATIONROOMTYPE
            where
                EVENTLODGINGLOCATIONROOMTYPE.EVENTLODGINGLOCATIONID = @ID
            order by 
                (select DESCRIPTION from dbo.EVENTLODGINGROOMTYPECODE where EVENTLODGINGROOMTYPECODE.ID = EVENTLODGINGLOCATIONROOMTYPE.EVENTLODGINGROOMTYPECODEID);

            -- trim the trailing comma

            if len(@ROOMINFORMATION) > 0
                set @ROOMINFORMATION = substring(@ROOMINFORMATION, 1, (len(@ROOMINFORMATION) - 1));

            return 0;