USP_DATAFORMTEMPLATE_ADD_EVENTLODGINGLOCATION

The save procedure used by the add dataform template "Event Lodging Option Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@EVENTLODGINGLOCATIONID	uniqueidentifier	IN	Lodging location
@ROOMINFORMATION	xml	IN	Room types
@EVENTLODGINGID	uniqueidentifier	IN	Event lodging ID
@SELECTEDEVENTID	uniqueidentifier	IN	Event

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_EVENTLODGINGLOCATION
            (
              @ID uniqueidentifier = null output,
              @CHANGEAGENTID uniqueidentifier = null,    
              @EVENTID uniqueidentifier,
              @EVENTLODGINGLOCATIONID uniqueidentifier,
              @ROOMINFORMATION xml = null,
              @EVENTLODGINGID uniqueidentifier = null,
              @SELECTEDEVENTID uniqueidentifier = null
            )

            as

            set nocount on;

            if @ID is null
              set @ID = newid()

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

            if (@SELECTEDEVENTID is not null) and (@SELECTEDEVENTID <> '00000000-0000-0000-0000-000000000000')
                set @EVENTID = @SELECTEDEVENTID

            declare @CURRENTDATE datetime
            set @CURRENTDATE = getdate()

            set @EVENTLODGINGID = @ID
            begin try
              exec dbo.USP_EVENTLODGINGROOM_VALIDATEROOMINFO @ROOMINFORMATION

              insert into dbo.EVENTLODGING
                (ID, EVENTID, EVENTLODGINGLOCATIONID, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
              values
                (@ID, @EVENTID, @EVENTLODGINGLOCATIONID, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)

              exec dbo.USP_EVENTLODGINGROOM_GETEVENTLODGINGROOMINFORMATION_ADDFROMXML @ID, @ROOMINFORMATION, @CHANGEAGENTID

            end try

            begin catch
              exec dbo.USP_RAISE_ERROR
              return 1
            end catch

            return 0