USP_DATAFORMTEMPLATE_EDIT_STEP_5

The save procedure used by the edit dataform template "Step Edit Form 4".

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.
@EXPECTEDDATE	datetime	IN	Expected date
@ACTUALDATE	datetime	IN	Actual date
@STATUSCODE	tinyint	IN	Status
@OWNERID	uniqueidentifier	IN	Owner
@INTERACTIONTYPECODEID	uniqueidentifier	IN	Contact Method
@OBJECTIVE	nvarchar(100)	IN	Objective
@PROSPECTPLANSTATUSCODEID	uniqueidentifier	IN	Stage
@COMMENT	nvarchar(max)	IN	Comment
@ADDITIONALFUNDRAISERS	xml	IN	Additional fundraisers
@PARTICIPANTS	xml	IN	Participants
@INTERACTIONCATEGORYID	uniqueidentifier	IN	Category
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN	Subcategory
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	IN	Expected start time
@EXPECTEDENDTIME	UDT_HOURMINUTE	IN	Expected end time
@ISALLDAYEVENT	bit	IN
@TIMEZONEENTRYID	uniqueidentifier	IN	Time zone
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	IN	Actual end time

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_STEP_5
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @EXPECTEDDATE datetime,
  @ACTUALDATE datetime,
  @STATUSCODE tinyint,
  @OWNERID uniqueidentifier,
  @INTERACTIONTYPECODEID uniqueidentifier,
  @OBJECTIVE nvarchar(100),
  @PROSPECTPLANSTATUSCODEID uniqueidentifier,
  @COMMENT nvarchar(max),
  @ADDITIONALFUNDRAISERS xml,
  @PARTICIPANTS xml,
  @INTERACTIONCATEGORYID uniqueidentifier,
  @INTERACTIONSUBCATEGORYID uniqueidentifier,
  @EXPECTEDSTARTTIME dbo.UDT_HOURMINUTE,
  @EXPECTEDENDTIME dbo.UDT_HOURMINUTE,
  @ISALLDAYEVENT bit, 
  @TIMEZONEENTRYID uniqueidentifier,
  @ACTUALSTARTTIME dbo.UDT_HOURMINUTE,
  @ACTUALENDTIME dbo.UDT_HOURMINUTE
) as begin
  set nocount on;

  declare @LOCATIONID uniqueidentifier;
  declare @OTHERLOCATION nvarchar(300);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_STEP_4
    @ID = @ID,
    @LOCATIONID = @LOCATIONID output,
    @OTHERLOCATION = @OTHERLOCATION output;

  exec USP_DATAFORMTEMPLATE_EDIT_STEP_7
    @ID,
    @CHANGEAGENTID,
    @EXPECTEDDATE,
    @ACTUALDATE,
    @STATUSCODE,
    @OWNERID,
    @INTERACTIONTYPECODEID,
    @OBJECTIVE,
    @PROSPECTPLANSTATUSCODEID,
    @COMMENT,
    @ADDITIONALFUNDRAISERS,
    @PARTICIPANTS,
    @INTERACTIONCATEGORYID,
    @INTERACTIONSUBCATEGORYID,
    @EXPECTEDSTARTTIME,
    @EXPECTEDENDTIME,
    @ISALLDAYEVENT, 
    @TIMEZONEENTRYID,
    @ACTUALSTARTTIME,
    @ACTUALENDTIME,
    @LOCATIONID,
    @OTHERLOCATION;
end