USP_DATAFORMTEMPLATE_EDITSAVE_EXCHANGECALENDARITEMBATCHROW_4

The save procedure used by the edit dataform template "Exchange Email Calendar Item Row Edit Form 2".

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.
@PROCESS	bit	IN	Process
@SEQUENCE	int	IN	Sequence
@RECORDTYPECODE	int	IN	Record type
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@OWNERID	uniqueidentifier	IN	User
@EXPECTEDDATE	datetime	IN	Date
@OBJECTIVE	nvarchar(256)	IN	Objective
@INTERACTIONID	uniqueidentifier	IN	Interaction
@STEWARDSHIPSTEPID	uniqueidentifier	IN	Stewardship step
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	IN	Expected start time
@EXPECTEDENDTIME	UDT_HOURMINUTE	IN	Expected end time
@TIMEZONEENTRYID	uniqueidentifier	IN	Time zone

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_EXCHANGECALENDARITEMBATCHROW_4
(
  @ID uniqueidentifier, 
  @CHANGEAGENTID uniqueidentifier,
  @PROCESS bit,
  @SEQUENCE int,
  @RECORDTYPECODE int,
  @CONSTITUENTID uniqueidentifier,
  @OWNERID uniqueidentifier,
  @EXPECTEDDATE datetime,
  @OBJECTIVE nvarchar(256),
  @INTERACTIONID uniqueidentifier,
  @STEWARDSHIPSTEPID uniqueidentifier,
  @EXPECTEDSTARTTIME dbo.UDT_HOURMINUTE,
  @EXPECTEDENDTIME dbo.UDT_HOURMINUTE,
  @TIMEZONEENTRYID uniqueidentifier
)
as 
  set nocount on;

  declare @CHANGEDATE datetime

  if @ID is null
    set @ID = NewID();

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

  set @CHANGEDATE = getdate();

  begin try
    update dbo.EXCHANGECALENDARITEMBATCH
    set 
      PROCESS = @PROCESS,
      SEQUENCE = @SEQUENCE,
      CHANGEDBYID = @CHANGEAGENTID,
      DATECHANGED = @CHANGEDATE,
      EXPECTEDSTARTTIME = @EXPECTEDSTARTTIME,
      EXPECTEDENDTIME = @EXPECTEDENDTIME,
      TIMEZONEENTRYID = @TIMEZONEENTRYID
    where ID = @ID;

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

  return 0;