USP_DATAFORMTEMPLATE_EDIT_REGISTRANTTRAVEL_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ARRIVALTRAVELTYPEID	uniqueidentifier	IN
@ARRIVALTRAVELNAMEID	uniqueidentifier	IN
@ARRIVALNUMBER	nvarchar(25)	IN
@ARRIVALDATE	datetime	IN
@ARRIVALTIME	UDT_HOURMINUTE	IN
@DEPARTURETRAVELTYPEID	uniqueidentifier	IN
@DEPARTURETRAVELNAMEID	uniqueidentifier	IN
@DEPARTURENUMBER	nvarchar(25)	IN
@DEPARTUREDATE	datetime	IN
@DEPARTURETIME	UDT_HOURMINUTE	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTTRAVEL_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @ARRIVALTRAVELTYPEID uniqueidentifier,
    @ARRIVALTRAVELNAMEID uniqueidentifier,
    @ARRIVALNUMBER nvarchar(25),
    @ARRIVALDATE datetime,
    @ARRIVALTIME dbo.UDT_HOURMINUTE,
    @DEPARTURETRAVELTYPEID uniqueidentifier,
    @DEPARTURETRAVELNAMEID uniqueidentifier,
    @DEPARTURENUMBER nvarchar(25),
    @DEPARTUREDATE datetime,
    @DEPARTURETIME dbo.UDT_HOURMINUTE
)
as

set nocount on;

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

declare @CURRENTDATE datetime = getdate();

update 
    dbo.[REGISTRANTTRAVEL]
set 
    [DEPARTURETIME] = @DEPARTURETIME,
    [DEPARTUREDATE] = @DEPARTUREDATE,
    [REGISTRANTDEPARTURETRAVELTYPECODEID] = @DEPARTURETRAVELTYPEID,
    [REGISTRANTDEPARTURETRAVELNAMECODEID] = @DEPARTURETRAVELNAMEID,
    [DEPARTURENUMBER] = @DEPARTURENUMBER,
    [ARRIVALTIME] = @ARRIVALTIME,
    [ARRIVALDATE] = @ARRIVALDATE,
    [REGISTRANTARRIVALTRAVELTYPECODEID] = @ARRIVALTRAVELTYPEID,
    [REGISTRANTARRIVALTRAVELNAMECODEID] = @ARRIVALTRAVELNAMEID,
    [ARRIVALNUMBER] = @ARRIVALNUMBER,
    [CHANGEDBYID] = @CHANGEAGENTID,
    [DATECHANGED] = @CURRENTDATE
where
    REGISTRANTTRAVEL.ID = @ID;

return 0;