USP_DATAFORMTEMPLATE_EDITLOAD_STEP_4

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@PROSPECTPLANID	uniqueidentifier	INOUT	Prospect plan ID
@EXPECTEDDATE	datetime	INOUT	Expected date
@ACTUALDATE	datetime	INOUT	Actual date
@OWNERID	uniqueidentifier	INOUT	Owner
@INTERACTIONTYPECODEID	uniqueidentifier	INOUT	Contact Method
@OBJECTIVE	nvarchar(100)	INOUT	Objective
@STATUSCODE	tinyint	INOUT	Status
@COMMENT	nvarchar(max)	INOUT	Comment
@PROSPECTPLANSTATUSCODEID	uniqueidentifier	INOUT	Stage
@PROSPECTNAME	nvarchar(700)	INOUT	Prospect name
@ADDITIONALFUNDRAISERS	xml	INOUT	Additional fundraisers
@PARTICIPANTS	xml	INOUT	Participants
@INTERACTIONCATEGORYID	uniqueidentifier	INOUT	Category
@INTERACTIONSUBCATEGORYID	uniqueidentifier	INOUT	Subcategory
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	INOUT	Expected start time
@EXPECTEDENDTIME	UDT_HOURMINUTE	INOUT	Expected end time
@TIMEZONEENTRYID	uniqueidentifier	INOUT	Time zone
@ISALLDAYEVENT	bit	INOUT
@ACTUALSTARTTIME	UDT_HOURMINUTE	INOUT	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	INOUT	Actual end time
@PLANISACTIVE	bit	INOUT
@PROSPECTID	uniqueidentifier	INOUT
@LOCATION	nvarchar(300)	INOUT
@LOCATIONID	uniqueidentifier	INOUT
@OTHERLOCATION	nvarchar(300)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_STEP_4
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @PROSPECTPLANID uniqueidentifier = null output,
  @EXPECTEDDATE datetime = null output,
  @ACTUALDATE datetime = null output,
  @OWNERID uniqueidentifier = null output,
  @INTERACTIONTYPECODEID uniqueidentifier = null output,
  @OBJECTIVE nvarchar(100) = null output,
  @STATUSCODE tinyint = null output,
  @COMMENT nvarchar(max) = null output,
  @PROSPECTPLANSTATUSCODEID uniqueidentifier = null output,
  @PROSPECTNAME nvarchar(700) = null output,
  @ADDITIONALFUNDRAISERS xml = null output,
  @PARTICIPANTS xml = null output,
  @INTERACTIONCATEGORYID uniqueidentifier = null output,
  @INTERACTIONSUBCATEGORYID uniqueidentifier = null output,
  @EXPECTEDSTARTTIME dbo.UDT_HOURMINUTE = null output,
  @EXPECTEDENDTIME dbo.UDT_HOURMINUTE = null output,
  @TIMEZONEENTRYID uniqueidentifier = null output,
  @ISALLDAYEVENT bit = null output,
  @ACTUALSTARTTIME dbo.UDT_HOURMINUTE = null output,
  @ACTUALENDTIME dbo.UDT_HOURMINUTE = null output,
  @PLANISACTIVE bit = null output,
  @PROSPECTID uniqueidentifier = null output,
  @LOCATION nvarchar(300) = null output,
  @LOCATIONID uniqueidentifier = null output,
  @OTHERLOCATION nvarchar(300) = null output
) as begin
  set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;

  select
    @DATALOADED = 1,
    @TSLONG = I.TSLONG,
    @PROSPECTPLANID = I.PROSPECTPLANID,
    @EXPECTEDDATE = I.EXPECTEDDATE,
    @ACTUALDATE = I.ACTUALDATE,
    @OWNERID = I.FUNDRAISERID,
    @INTERACTIONTYPECODEID = I.INTERACTIONTYPECODEID,
    @OBJECTIVE = I.OBJECTIVE,
    @STATUSCODE = I.STATUSCODE,
    @COMMENT = I.COMMENT,
    @PROSPECTPLANSTATUSCODEID = I.PROSPECTPLANSTATUSCODEID,
    @PROSPECTNAME = NF.NAME,
    @ADDITIONALFUNDRAISERS = dbo.UFN_INTERACTION_ADDITIONALFUNDRAISERS_TOITEMLISTXML(I.ID),
    @PARTICIPANTS = dbo.UFN_INTERACTION_PARTICIPANTS_TOITEMLISTXML(I.ID),
    @INTERACTIONCATEGORYID = INTERACTIONSUBCATEGORY.INTERACTIONCATEGORYID,
    @INTERACTIONSUBCATEGORYID = INTERACTIONSUBCATEGORY.ID,
    @EXPECTEDSTARTTIME = I.EXPECTEDSTARTTIME,
    @EXPECTEDENDTIME = I.EXPECTEDENDTIME,
    @ISALLDAYEVENT = I.ISALLDAYEVENT, 
    @TIMEZONEENTRYID = I.TIMEZONEENTRYID,
    @ACTUALSTARTTIME = I.ACTUALSTARTTIME,
    @ACTUALENDTIME = I.ACTUALENDTIME,
    @PLANISACTIVE = PP.ISACTIVE,
    @PROSPECTID = PP.PROSPECTID,
    @LOCATION = I.LOCATION
  from dbo.INTERACTION I
    inner join dbo.PROSPECTPLAN PP on I.PROSPECTPLANID = PP.ID
    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PP.PROSPECTID) NF
    left outer join dbo.INTERACTIONSUBCATEGORY on I.INTERACTIONSUBCATEGORYID = INTERACTIONSUBCATEGORY.ID
  where I.ID = @ID;

  return 0;
end