USP_DATAFORMTEMPLATE_EDIT_BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHROW

The save procedure used by the edit dataform template "Stewardship Plan Step Update Batch Row Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@PRIMARYRECORDID	uniqueidentifier	IN	Stewardship plan step
@STEPOWNERID	uniqueidentifier	IN
@STEWARDSHIPPLANID	uniqueidentifier	IN	Plan ID
@CATEGORYCODEID	uniqueidentifier	IN	Category
@OBJECTIVE	nvarchar(100)	IN	Objective
@TARGETDATE	date	IN	Target date
@DATELOCKED	bit	IN	Locked
@ACTUALDATE	date	IN	Actual date
@STARTDATE	date	IN	Frequency start date
@ENDDATE	date	IN	Frequency end date
@CONTACTMETHODCODEID	uniqueidentifier	IN	Contact method
@CONTACTPERSONID	uniqueidentifier	IN	Contact person
@CONSTITUENTID	uniqueidentifier	IN	Assigned to
@ASSOCIATEDPLANS	xml	IN	Associated plans
@RECURSCODE	smallint	IN	Frequency
@STATUSCODE	smallint	IN	Status
@NEXTTARGETDATE	date	IN	Next target date
@LINKTYPECODE	tinyint	IN	Connect to
@EVENTID	uniqueidentifier	IN	Event
@MAILINGID	uniqueidentifier	IN	Mailing
@BENEFITID	uniqueidentifier	IN	Benefit
@TARGETSTARTTIME	UDT_HOURMINUTE	IN	Target start time
@TARGETENDTIME	UDT_HOURMINUTE	IN	Target end time
@TIMEZONEENTRYID	uniqueidentifier	IN	Time zone
@ISALLDAYEVENT	bit	IN	Is all day event
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	IN	Actual end time
@STEPPARTICIPANTS	xml	IN	Plan participants

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHROW
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @SEQUENCE int,
  @PRIMARYRECORDID uniqueidentifier,
  @STEPOWNERID uniqueidentifier,
  @STEWARDSHIPPLANID uniqueidentifier,
  @CATEGORYCODEID uniqueidentifier,
  @OBJECTIVE nvarchar(100),
  @TARGETDATE date,
  @DATELOCKED bit,
  @ACTUALDATE date,
  @STARTDATE date,
  @ENDDATE date,
  @CONTACTMETHODCODEID uniqueidentifier,
  @CONTACTPERSONID uniqueidentifier,
  @CONSTITUENTID uniqueidentifier,
  @ASSOCIATEDPLANS xml,
  @RECURSCODE smallint,
  @STATUSCODE smallint,
  @NEXTTARGETDATE date,
  @LINKTYPECODE tinyint,
  @EVENTID uniqueidentifier,
  @MAILINGID uniqueidentifier,
  @BENEFITID uniqueidentifier,
  @TARGETSTARTTIME dbo.UDT_HOURMINUTE,
  @TARGETENDTIME dbo.UDT_HOURMINUTE,
  @TIMEZONEENTRYID uniqueidentifier,
  @ISALLDAYEVENT bit,
  @ACTUALSTARTTIME dbo.UDT_HOURMINUTE,
  @ACTUALENDTIME dbo.UDT_HOURMINUTE,
  @STEPPARTICIPANTS xml
)
as
set nocount on;

declare @CURRENTDATE datetime;

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

set @CURRENTDATE = getdate();

begin try
update dbo.BATCHSTEWARDSHIPPLANSTEPUPDATE
  set
    [SEQUENCE] = @SEQUENCE,
    [CHANGEDBYID] = @CHANGEAGENTID,
    [DATECHANGED] = @CURRENTDATE,
    [PRIMARYRECORDID] = @PRIMARYRECORDID,
    [STEWARDSHIPPLANID] = @STEWARDSHIPPLANID,
    [CATEGORYCODEID] = @CATEGORYCODEID,
    [OBJECTIVE] = coalesce(@OBJECTIVE, ''),
    [TARGETDATE] = @TARGETDATE,
    [DATELOCKED] = coalesce(@DATELOCKED, 0),
    [ACTUALDATE] = @ACTUALDATE,
    [STARTDATE] = @STARTDATE,
    [ENDDATE] = @ENDDATE,
    [CONTACTMETHODCODEID] = @CONTACTMETHODCODEID,
    [CONTACTPERSONID] = @CONTACTPERSONID,
    [CONSTITUENTID] = @CONSTITUENTID,
    [RECURSCODE] = coalesce(@RECURSCODE, 0),
    [STATUSCODE] = coalesce(@STATUSCODE, 0),
    [NEXTTARGETDATE] = @NEXTTARGETDATE,
    [EVENTID] = case
      when @LINKTYPECODE = 1 then @EVENTID
      else null
    end,
    [MAILINGID] = case
      when @LINKTYPECODE = 2 then @MAILINGID
      else null
    end,
    [BENEFITID] =case
      when @LINKTYPECODE = 0 then @BENEFITID
      else null
    end,
    [TARGETSTARTTIME] = coalesce(@TARGETSTARTTIME, ''),
    [TARGETENDTIME] = coalesce(@TARGETENDTIME, ''),
    [TIMEZONEENTRYID] = @TIMEZONEENTRYID,
    [ISALLDAYEVENT] = coalesce(@ISALLDAYEVENT, 0),
    [ACTUALSTARTTIME] = coalesce(@ACTUALSTARTTIME, ''),
    [ACTUALENDTIME] = coalesce(@ACTUALENDTIME, '')
  where
    ID = @ID;

exec dbo.USP_BATCHSTEWARDSHIPPLANSTEPUPDATE_GETASSOCIATEDPLANS_UPDATEFROMXML @ID, @CURRENTAPPUSERID, @ASSOCIATEDPLANS, @CHANGEAGENTID;

exec dbo.USP_BATCHSTEWARDSHIPPLANSTEPUPDATE_GETSTEPPARTICIPANTS_UPDATEFROMXML @ID, @STEPPARTICIPANTS, @CHANGEAGENTID;

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

return 0;