USP_STEP_ADD

Create a new prospect plan step.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@PROSPECTPLANID	uniqueidentifier	IN
@EXPECTEDDATE	datetime	IN
@ACTUALDATE	datetime	IN
@STATUSCODE	tinyint	IN
@OWNERID	uniqueidentifier	IN
@INTERACTIONTYPECODEID	uniqueidentifier	IN
@OBJECTIVE	nvarchar(100)	IN
@PROSPECTPLANSTATUSCODEID	uniqueidentifier	IN
@COMMENT	nvarchar(max)	IN
@ADDITIONALFUNDRAISERS	xml	IN
@PARTICIPANTS	xml	IN
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	IN
@EXPECTEDENDTIME	UDT_HOURMINUTE	IN
@TIMEZONEENTRYID	uniqueidentifier	IN
@ISALLDAYEVENT	bit	IN
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN
@ACTUALENDTIME	UDT_HOURMINUTE	IN
@LOCATION	nvarchar(300)	IN

Definition

Copy



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

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

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

  declare @CONSTITUENTID uniqueidentifier;
  select @CONSTITUENTID = PROSPECTID from dbo.PROSPECTPLAN where ID = @PROSPECTPLANID;

  begin try
    insert into dbo.INTERACTION (
      ID,
      ADDEDBYID,
      CHANGEDBYID,
      CONSTITUENTID,
      PROSPECTPLANID,
      ACTUALDATE,
      EXPECTEDDATE,
      STATUSCODE,
      FUNDRAISERID,
      INTERACTIONTYPECODEID,
      OBJECTIVE,
      PROSPECTPLANSTATUSCODEID,
      INTERACTIONSUBCATEGORYID,
      COMMENT,
      EXPECTEDSTARTTIME,
      EXPECTEDENDTIME,
      TIMEZONEENTRYID,
      ISALLDAYEVENT,
      ACTUALSTARTTIME,
      ACTUALENDTIME,
      LOCATION
    ) values (
      @ID,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CONSTITUENTID,
      @PROSPECTPLANID,
      @ACTUALDATE,
      @EXPECTEDDATE,
      @STATUSCODE,
      @OWNERID,
      @INTERACTIONTYPECODEID,
      @OBJECTIVE,
      @PROSPECTPLANSTATUSCODEID,
      @INTERACTIONSUBCATEGORYID,
      @COMMENT,
      @EXPECTEDSTARTTIME,
      @EXPECTEDENDTIME,
      @TIMEZONEENTRYID,
      @ISALLDAYEVENT,
      @ACTUALSTARTTIME,
      @ACTUALENDTIME,
      @LOCATION
    );

    exec dbo.USP_INTERACTION_ADDITIONALFUNDRAISERS_ADDFROMXML @ID, @ADDITIONALFUNDRAISERS, @CHANGEAGENTID;
    exec dbo.USP_INTERACTION_PARTICIPANTS_ADDFROMXML @ID, @PARTICIPANTS, @CHANGEAGENTID;
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch;
end