USP_DATAFORMTEMPLATE_EDIT_PLANITEMTASKALERTAPPUSERSETTINGS

The save procedure used by the edit dataform template "Plan Item Task Alert Application User Settings Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@ALERTWHENASSIGNEDTASK	bit	IN	Send me an alert when a plan item task has been assigned to me
@EMAILADDRESS	UDT_EMAILADDRESS	IN	Send email alerts to
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PLANITEMTASKALERTAPPUSERSETTINGS
(
  @ID uniqueidentifier,
  @ALERTWHENASSIGNEDTASK bit,
  @EMAILADDRESS dbo.UDT_EMAILADDRESS,
  @CHANGEAGENTID uniqueidentifier = null
) as
begin
  set nocount on;

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

  declare @CURRENTDATE datetime;
  set @CURRENTDATE = getdate();

  exec dbo.USP_APPUSERALERTTYPESETTING_CREATEORUPDATE @ID, 'C3C45931-0140-427B-948C-15AF7B39D20E', @ALERTWHENASSIGNEDTASK, @CHANGEAGENTID;

  if exists(select top(1) ID from dbo.APPUSERALERTSETTING where ID = @ID)
    update
      dbo.APPUSERALERTSETTING
    set
      EMAILADDRESS = @EMAILADDRESS,
      CHANGEDBYID = @CHANGEAGENTID,
      DATECHANGED = @CURRENTDATE
    where
      ID = @ID
  else
    insert into dbo.APPUSERALERTSETTING (
      ID,
      EMAILADDRESS,
      ADDEDBYID,
      CHANGEDBYID,
      DATECHANGED,
      DATEADDED
    ) values (
      @ID,
      @EMAILADDRESS,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    )

  return 0;
end