USP_DATAFORMTEMPLATE_EDITLOAD_EVENTLODGINGLOCATION

The load procedure used by the edit dataform template "Event Lodging Location 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.
@NAME	nvarchar(100)	INOUT	Name
@CONSTITUENTID	uniqueidentifier	INOUT	Contact
@COMMENT	nvarchar(256)	INOUT	Comment
@COUNTRYID	uniqueidentifier	INOUT	Country
@STATEID	uniqueidentifier	INOUT	State
@ADDRESSBLOCK	nvarchar(150)	INOUT	Address
@CITY	nvarchar(50)	INOUT	City
@POSTCODE	nvarchar(12)	INOUT	ZIP
@PHONENUMBER	nvarchar(100)	INOUT	Phone number
@DISCOUNTCODE	nvarchar(20)	INOUT	Discount code
@ROOMTYPES	xml	INOUT	Room types

Definition

Copy


          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EVENTLODGINGLOCATION(
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @TSLONG bigint = 0 output,
            @NAME nvarchar(100) = null output,
            @CONSTITUENTID uniqueidentifier = null output,
            @COMMENT nvarchar(256) = null output,
            @COUNTRYID uniqueidentifier = null output,
            @STATEID uniqueidentifier = null output,
            @ADDRESSBLOCK nvarchar(150) = null output,
            @CITY nvarchar(50) = null output,
            @POSTCODE nvarchar(12) = null output,
            @PHONENUMBER nvarchar(100) = null output,
            @DISCOUNTCODE nvarchar(20) = null output,
            @ROOMTYPES xml = null output
            )
          as
            set nocount on;

            set @DATALOADED = 0
            set @TSLONG = 0

            select
              @DATALOADED = 1,
              @TSLONG = EVENTLODGINGLOCATION.TSLONG,
              @NAME = EVENTLODGINGLOCATION.NAME,
              @CONSTITUENTID = EVENTLODGINGLOCATION.CONSTITUENTID,
              @COMMENT = EVENTLODGINGLOCATION.COMMENT,
              @COUNTRYID = EVENTLODGINGLOCATION.COUNTRYID,
              @STATEID = EVENTLODGINGLOCATION.STATEID,
              @ADDRESSBLOCK = EVENTLODGINGLOCATION.ADDRESSBLOCK,
              @CITY = EVENTLODGINGLOCATION.CITY,
              @POSTCODE = EVENTLODGINGLOCATION.POSTCODE,
              @PHONENUMBER = EVENTLODGINGLOCATION.PHONENUMBER,
              @DISCOUNTCODE = EVENTLODGINGLOCATION.DISCOUNTCODE,
              @ROOMTYPES = dbo.UFN_EVENTLODGINGLOCATION_GETROOMTYPES_TOITEMLISTXML(EVENTLODGINGLOCATION.ID)
            from
              dbo.EVENTLODGINGLOCATION
            where 
              ID = @ID

            return 0;