USP_REGISTRANTTRAVEL_ADD

Creates a record for a registrant's travel information

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN
@REGISTRANTCONSTITUENTID	uniqueidentifier	IN
@MAINEVENTID	uniqueidentifier	IN
@DEPARTURETIME	UDT_HOURMINUTE	IN
@DEPARTUREDATE	datetime	IN
@REGISTRANTDEPARTURETRAVELTYPECODEID	uniqueidentifier	IN
@REGISTRANTDEPARTURETRAVELNAMECODEID	uniqueidentifier	IN
@DEPARTURENUMBER	nvarchar(25)	IN
@ARRIVALTIME	UDT_HOURMINUTE	IN
@ARRIVALDATE	datetime	IN
@REGISTRANTARRIVALTRAVELTYPECODEID	uniqueidentifier	IN
@REGISTRANTARRIVALTRAVELNAMECODEID	uniqueidentifier	IN
@ARRIVALNUMBER	nvarchar(25)	IN

Definition

Copy



create procedure dbo.USP_REGISTRANTTRAVEL_ADD
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier,
    @CURRENTDATE datetime
    ,@REGISTRANTCONSTITUENTID uniqueidentifier
    ,@MAINEVENTID uniqueidentifier
    ,@DEPARTURETIME UDT_HOURMINUTE
    ,@DEPARTUREDATE datetime
    ,@REGISTRANTDEPARTURETRAVELTYPECODEID uniqueidentifier
    ,@REGISTRANTDEPARTURETRAVELNAMECODEID uniqueidentifier
    ,@DEPARTURENUMBER nvarchar(25)
    ,@ARRIVALTIME UDT_HOURMINUTE
    ,@ARRIVALDATE datetime
    ,@REGISTRANTARRIVALTRAVELTYPECODEID uniqueidentifier
    ,@REGISTRANTARRIVALTRAVELNAMECODEID uniqueidentifier
    ,@ARRIVALNUMBER nvarchar(25)
)
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();

        INSERT INTO dbo.[REGISTRANTTRAVEL]
            ([ID]
            ,[REGISTRANTCONSTITUENTID]
            ,[MAINEVENTID]
            ,[DEPARTURETIME]
            ,[DEPARTUREDATE]
            ,[REGISTRANTDEPARTURETRAVELTYPECODEID]
            ,[REGISTRANTDEPARTURETRAVELNAMECODEID]
            ,[DEPARTURENUMBER]
            ,[ARRIVALTIME]
            ,[ARRIVALDATE]
            ,[REGISTRANTARRIVALTRAVELTYPECODEID]
            ,[REGISTRANTARRIVALTRAVELNAMECODEID]
            ,[ARRIVALNUMBER]
            ,[ADDEDBYID]
            ,[CHANGEDBYID]
            ,[DATEADDED]
            ,[DATECHANGED])
        VALUES
            (@ID
            ,@REGISTRANTCONSTITUENTID
            ,@MAINEVENTID
            ,@DEPARTURETIME
            ,@DEPARTUREDATE
            ,@REGISTRANTDEPARTURETRAVELTYPECODEID
            ,@REGISTRANTDEPARTURETRAVELNAMECODEID
            ,@DEPARTURENUMBER
            ,@ARRIVALTIME
            ,@ARRIVALDATE
            ,@REGISTRANTARRIVALTRAVELTYPECODEID
            ,@REGISTRANTARRIVALTRAVELNAMECODEID
            ,@ARRIVALNUMBER
            ,@CHANGEAGENTID
            ,@CHANGEAGENTID
            ,@CURRENTDATE
            ,@CURRENTDATE);

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

end