USP_DATAFORMTEMPLATE_EDIT_GLOBALDECEASINGOPTIONS

The save procedure used by the edit dataform template "Deceasing Options Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@UPDATECONSTITUENCIES	bit	IN	Update constituencies
@UPDATERELATIONSHIPS	bit	IN	Update relationships
@ADDDOCUMENTATION	bit	IN	Update documentation
@UPDATECONSTITUENTINTERACTIONS	bit	IN	Update pending interactions
@UPDATECONSTITUENTNAMEFORMATS	bit	IN	Update name formats
@ADDTRIBUTE	bit	IN	Update tributes
@UPDATEHOUSEHOLDMEMBERS	bit	IN	Update members
@UPDATEHOUSEHOLDINTERACTIONS	bit	IN	Update pending interactions
@UPDATEHOUSEHOLDNAMEFORMATS	bit	IN	Update name formats
@SHOWGROUPS	bit	IN	Show groups

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GLOBALDECEASINGOPTIONS
(
  @CHANGEAGENTID uniqueidentifier = null,
  @UPDATECONSTITUENCIES bit,
  @UPDATERELATIONSHIPS bit,
  @ADDDOCUMENTATION bit,
  @UPDATECONSTITUENTINTERACTIONS bit,
  @UPDATECONSTITUENTNAMEFORMATS bit,
  @ADDTRIBUTE bit,
  @UPDATEHOUSEHOLDMEMBERS bit,
  @UPDATEHOUSEHOLDINTERACTIONS bit,
  @UPDATEHOUSEHOLDNAMEFORMATS bit,
  @SHOWGROUPS bit
)
as
  set nocount on;

  declare @CURRENTDATE datetime = getdate();

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

  begin try
    update
      dbo.DECEASINGOPTION
    set
      UPDATECONSTITUENCIES = @UPDATECONSTITUENCIES,
      UPDATERELATIONSHIPS = @UPDATERELATIONSHIPS,
      ADDDOCUMENTATION = @ADDDOCUMENTATION,
      UPDATECONSTITUENTINTERACTIONS = @UPDATECONSTITUENTINTERACTIONS,
      UPDATECONSTITUENTNAMEFORMATS = @UPDATECONSTITUENTNAMEFORMATS,
      ADDTRIBUTE = @ADDTRIBUTE,
      UPDATEHOUSEHOLDMEMBERS = @UPDATEHOUSEHOLDMEMBERS,
      UPDATEHOUSEHOLDINTERACTIONS = @UPDATEHOUSEHOLDINTERACTIONS,
      UPDATEHOUSEHOLDNAMEFORMATS = @UPDATEHOUSEHOLDNAMEFORMATS,
      SHOWGROUPS = @SHOWGROUPS,
      DATECHANGED = @CURRENTDATE,
      CHANGEDBYID = @CHANGEAGENTID;

    -- If this is the first time this form is saved, the row needs to be created

    if @@ROWCOUNT = 0
    begin
      declare @ID uniqueidentifier = newid();
      declare @NAMEFORMATFUNCTIONID uniqueidentifier;

      select
        @NAMEFORMATFUNCTIONID = ID 
      from 
        dbo.NAMEFORMATFUNCTION 
      where 
        FORMATSQLFUNCTION = 'UFN_NAMEFORMAT_32';

      insert into dbo.DECEASINGOPTION
      (
        ID,
        UPDATECONSTITUENCIES,
        UPDATERELATIONSHIPS,
        ADDDOCUMENTATION,
        UPDATECONSTITUENTINTERACTIONS,
        UPDATECONSTITUENTNAMEFORMATS,
        ADDTRIBUTE,
        UPDATEHOUSEHOLDMEMBERS,
        UPDATEHOUSEHOLDINTERACTIONS,
        UPDATEHOUSEHOLDNAMEFORMATS,
        SHOWGROUPS,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED                                
      )
      values
      (
        @ID,
        @UPDATECONSTITUENCIES,
        @UPDATERELATIONSHIPS,
        @ADDDOCUMENTATION,
        @UPDATECONSTITUENTINTERACTIONS,
        @UPDATECONSTITUENTNAMEFORMATS,
        @ADDTRIBUTE,
        @UPDATEHOUSEHOLDMEMBERS,
        @UPDATEHOUSEHOLDINTERACTIONS,
        @UPDATEHOUSEHOLDNAMEFORMATS,
        @SHOWGROUPS,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE    
      );
    end

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

  return 0;