USP_REGISTRANTLODGING_ADD

Creates a record for a registrant's lodging information.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN
@REGISTRANTCONSTITUENTID	uniqueidentifier	IN
@MAINEVENTID	uniqueidentifier	IN
@PHONENUMBER	nvarchar(50)	IN
@EVENTLODGINGROOMID	uniqueidentifier	IN
@ROOMNUMBER	nvarchar(10)	IN
@CONFIRMATIONNUMBER	nvarchar(10)	IN
@CHECKINDATE	datetime	IN
@CHECKINTIME	UDT_HOURMINUTE	IN
@CHECKOUTDATE	datetime	IN
@CHECKOUTTIME	UDT_HOURMINUTE	IN
@EVENTLODGINGID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_REGISTRANTLODGING_ADD
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier,
    @CURRENTDATE datetime,
    @REGISTRANTCONSTITUENTID uniqueidentifier,
    @MAINEVENTID uniqueidentifier,
    @PHONENUMBER nvarchar(50),
    @EVENTLODGINGROOMID uniqueidentifier,
    @ROOMNUMBER nvarchar(10),
    @CONFIRMATIONNUMBER nvarchar(10),
    @CHECKINDATE datetime,
    @CHECKINTIME UDT_HOURMINUTE,
    @CHECKOUTDATE datetime,
    @CHECKOUTTIME UDT_HOURMINUTE,
    @EVENTLODGINGID uniqueidentifier
)
as
begin

    begin try
        if @ID is null
            set @ID = newid();

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

        if @CURRENTDATE is null
            set @CURRENTDATE = getdate();

        declare @EVENTLODGINGROOMINSTANCEID uniqueidentifier;

        exec dbo.USP_EVENTLODGINGROOMINSTANCE_ADDORUPDATE @ROOMNUMBER, @EVENTLODGINGID, @EVENTLODGINGROOMID, null, null, @EVENTLODGINGROOMINSTANCEID output, @ID;

        insert into dbo.[REGISTRANTLODGING]
               ([ID],
               [REGISTRANTCONSTITUENTID],
               [EVENTID],
               [PHONENUMBER],
               [CONFIRMATIONNUMBER],
               [CHECKINDATE],
               [CHECKINTIME],
               [CHECKOUTDATE],
               [CHECKOUTTIME],
               [ADDEDBYID],
               [CHANGEDBYID],
               [DATEADDED],
               [DATECHANGED],
               [EVENTLODGINGID],
               [EVENTLODGINGROOMINSTANCEID])
         values
               (@ID,
               @REGISTRANTCONSTITUENTID,
               @MAINEVENTID,
               @PHONENUMBER,
               @CONFIRMATIONNUMBER,
               @CHECKINDATE,
               @CHECKINTIME,
               @CHECKOUTDATE,
               @CHECKOUTTIME,
               @CHANGEAGENTID,
               @CHANGEAGENTID,
               @CURRENTDATE,
               @CURRENTDATE,
               @EVENTLODGINGID,
               @EVENTLODGINGROOMINSTANCEID);

    end try
    begin catch
        exec dbo.USP_RAISE_ERROR;
        return 1;
    end catch

end