USP_DATAFORMTEMPLATE_EDIT_EVENTLODGINGLOCATION

The save 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 indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@CONSTITUENTID	uniqueidentifier	IN	Contact
@COMMENT	nvarchar(256)	IN	Comment
@COUNTRYID	uniqueidentifier	IN	Country
@STATEID	uniqueidentifier	IN	State
@ADDRESSBLOCK	nvarchar(150)	IN	Address
@CITY	nvarchar(50)	IN	City
@POSTCODE	nvarchar(12)	IN	ZIP
@PHONENUMBER	nvarchar(100)	IN	Phone number
@DISCOUNTCODE	nvarchar(20)	IN	Discount code
@ROOMTYPES	xml	IN	Room types

Definition

Copy


          CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTLODGINGLOCATION (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @NAME nvarchar(100),
            @CONSTITUENTID uniqueidentifier,
            @COMMENT nvarchar(256),
            @COUNTRYID uniqueidentifier,
            @STATEID uniqueidentifier,
            @ADDRESSBLOCK nvarchar(150),
            @CITY nvarchar(50),
            @POSTCODE nvarchar(12),
            @PHONENUMBER nvarchar(100),
            @DISCOUNTCODE nvarchar(20),
            @ROOMTYPES xml
            )

          as

            set nocount on;

            if @CHANGEAGENTID is null
              exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

            declare @CURRENTDATE datetime
            set @CURRENTDATE = getdate()

            begin try
              update 
                dbo.EVENTLODGINGLOCATION 
              set
                NAME = @NAME,
                CONSTITUENTID = @CONSTITUENTID,
                COMMENT = @COMMENT,
                COUNTRYID = @COUNTRYID,
                STATEID = @STATEID,
                ADDRESSBLOCK = @ADDRESSBLOCK,
                CITY = @CITY,
                POSTCODE = @POSTCODE,
                PHONENUMBER = @PHONENUMBER,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE,
                DISCOUNTCODE = @DISCOUNTCODE
              where
                ID = @ID

              exec dbo.USP_EVENTLODGINGLOCATION_GETROOMTYPES_UPDATEFROMXML @ID, @ROOMTYPES, @CHANGEAGENTID, @CURRENTDATE;
            end try

            begin catch
              exec dbo.USP_RAISE_ERROR
              return 1
            end catch

            return 0;