USP_DATAFORMTEMPLATE_VIEW_EVENTLODGINGLOCATIONS

The load procedure used by the view dataform template "Event Lodging Locations View 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.
@EVENTLODGINGLOCATIONID	uniqueidentifier	INOUT	Name
@COUNTRYID	uniqueidentifier	INOUT	COUNTRYID
@NAME	nvarchar(100)	INOUT	Name
@DISCOUNTCODE	nvarchar(max)	INOUT	Discount code
@COMMENT	nvarchar(256)	INOUT	Comment
@ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@CITY	nvarchar(50)	INOUT	City
@STATE	nvarchar(100)	INOUT	State
@POSTCODE	nvarchar(12)	INOUT	ZIP
@CONTACTNAME	nvarchar(300)	INOUT	Contact
@PHONENUMBER	nvarchar(100)	INOUT	Phone number

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EVENTLODGINGLOCATIONS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @EVENTLODGINGLOCATIONID uniqueidentifier = null output,
                    @COUNTRYID uniqueidentifier = null output,
                    @NAME nvarchar(100) = null output,
                    @DISCOUNTCODE nvarchar(max) = null output,
                    @COMMENT nvarchar(256) = null output,
                    @ADDRESSBLOCK nvarchar(150) = null output,
                    @CITY nvarchar(50) = null output,
                    @STATE nvarchar(100) = null output,
                    @POSTCODE nvarchar(12) = null output,
                    @CONTACTNAME nvarchar(300) = null output,
                    @PHONENUMBER nvarchar(100) = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select
                        @DATALOADED = 1,
                        @EVENTLODGINGLOCATIONID = EVENTLODGINGLOCATION.ID,
                        @COUNTRYID = EVENTLODGINGLOCATION.COUNTRYID,
                        @NAME = EVENTLODGINGLOCATION.NAME,
                        @PHONENUMBER = EVENTLODGINGLOCATION.PHONENUMBER,
                        @CONTACTNAME = NF.NAME,
                        @DISCOUNTCODE = EVENTLODGINGLOCATION.DISCOUNTCODE,
                        @COMMENT = EVENTLODGINGLOCATION.COMMENT,
                        @ADDRESSBLOCK = EVENTLODGINGLOCATION.ADDRESSBLOCK,
                        @CITY = EVENTLODGINGLOCATION.CITY,
                        @STATE = STATE.DESCRIPTION,
                        @POSTCODE = EVENTLODGINGLOCATION.POSTCODE
                    from
                        dbo.EVENTLODGING
                    inner join
                        dbo.EVENTLODGINGLOCATION on EVENTLODGINGLOCATION.ID = EVENTLODGING.EVENTLODGINGLOCATIONID
                    left join
                        dbo.STATE on STATE.ID = EVENTLODGINGLOCATION.STATEID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(EVENTLODGINGLOCATION.CONSTITUENTID) NF
                    where 
                        EVENTLODGING.ID = @ID