USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPPACKAGEPROCESS_2

The save procedure used by the edit dataform template "Stewardship Package Edit Form".

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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@WORDTEMPLATEFILENAME	nvarchar(255)	IN	Word template
@WORDFILE	varbinary	IN	File
@BUSINESSPROCESSVIEWID	uniqueidentifier	IN	Output format
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@FILECHANGED	bit	IN	File changed?
@EXCLUSIONDATETYPECODE	tinyint	IN	Consider exclusions as of
@EXCLUSIONASOFDATE	datetime	IN	Consider exclusions as of
@EXCLUDEDECEASED	bit	IN	Exclude deceased constituents
@EXCLUDEINACTIVE	bit	IN	Exclude inactive constituents
@EXCLUSIONS	xml	IN	Exclusions
@CUSTOMPARAMETERDATAFORMITEM	xml	IN
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DISPLAYEDFILENAME	nvarchar(255)	IN	Word template

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPPACKAGEPROCESS_2
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255),
  @WORDTEMPLATEFILENAME nvarchar(255),
  @WORDFILE varbinary(max),
  @BUSINESSPROCESSVIEWID uniqueidentifier,
  @CREATEOUTPUTIDSET bit,
  @OUTPUTIDSETNAME nvarchar(100),                        
  @OVERWRITEOUTPUTIDSET bit,
  @FILECHANGED bit,
  @EXCLUSIONDATETYPECODE tinyint,
  @EXCLUSIONASOFDATE datetime,
  @EXCLUDEDECEASED bit,
  @EXCLUDEINACTIVE bit,
  @EXCLUSIONS xml,
  @CUSTOMPARAMETERDATAFORMITEM xml,
  --@OVERRIDEREQUIREDEXCLUSIONS bit,

  --@REQUIREDEXCLUSIONS xml,

  @CURRENTAPPUSERID uniqueidentifier = null,
  @DISPLAYEDFILENAME nvarchar(255)
)
as                
  set nocount on;

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

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

                  if @FILECHANGED = 1
        update
          dbo.STEWARDSHIPPACKAGEPROCESS
        set
          NAME = @NAME,
          DESCRIPTION = @DESCRIPTION,
          WORDTEMPLATEFILENAME = @DISPLAYEDFILENAME,
          WORDFILE = @WORDFILE,
          BUSINESSPROCESSVIEWID = @BUSINESSPROCESSVIEWID,
          CREATEOUTPUTIDSET = @CREATEOUTPUTIDSET,
          OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
          OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
          CUSTOMPARAMETERDATAFORMITEM = @CUSTOMPARAMETERDATAFORMITEM,
          CHANGEDBYID = @CHANGEAGENTID,
          DATECHANGED = @CURRENTDATE
        where
          ID = @ID;
    else
        update
          dbo.STEWARDSHIPPACKAGEPROCESS
        set
          NAME = @NAME,
          DESCRIPTION = @DESCRIPTION,
          BUSINESSPROCESSVIEWID = @BUSINESSPROCESSVIEWID,
          CREATEOUTPUTIDSET = @CREATEOUTPUTIDSET,
          OUTPUTIDSETNAME = @OUTPUTIDSETNAME,
          OVERWRITEOUTPUTIDSET = @OVERWRITEOUTPUTIDSET,
          CUSTOMPARAMETERDATAFORMITEM = @CUSTOMPARAMETERDATAFORMITEM,
          CHANGEDBYID = @CHANGEAGENTID,
          DATECHANGED = @CURRENTDATE
        where
          ID = @ID;


      exec dbo.USP_BUSINESSPROCESSCOMMPREF_UPDATE 
        @CHANGEAGENTID = @CHANGEAGENTID,
        @BUSINESSPROCESSCATALOGID = 'B4184ABE-C618-466F-90A2-B96B88644A17',
        @BUSINESSPROCESSPARAMETERSETID = @ID,
        @EXCLUSIONDATETYPECODE = @EXCLUSIONDATETYPECODE,
        @EXCLUSIONASOFDATE = @EXCLUSIONASOFDATE,
        @EXCLUDEDECEASED = @EXCLUDEDECEASED,
        @EXCLUDEINACTIVE = @EXCLUDEINACTIVE,
        @EXCLUSIONS = @EXCLUSIONS,
        --@OVERRIDEREQUIREDEXCLUSIONS = @OVERRIDEREQUIREDEXCLUSIONS,

        --@REQUIREDEXCLUSIONS = @REQUIREDEXCLUSIONS,

        @CURRENTAPPUSERID = @CURRENTAPPUSERID;                                   
  end try

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

  return 0;