USP_DATAFORMTEMPLATE_EDIT_MARRIAGEOPTIONS_2

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

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@UPDATECONTACTINFO	bit	IN	Update contact information
@UPDATENAMEFORMATS	bit	IN	Update name formats
@UPDATEHOUSEHOLDRECOGNITION	bit	IN	Update household recognition
@UPDATEINDIVIDUALRELATIONSHIPS	bit	IN	Update individual relationships

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MARRIAGEOPTIONS_2
(
  @CHANGEAGENTID uniqueidentifier = null,
  @UPDATECONTACTINFO bit,
  @UPDATENAMEFORMATS bit,
  @UPDATEHOUSEHOLDRECOGNITION bit,
  @UPDATEINDIVIDUALRELATIONSHIPS bit  
)
as
  set nocount on;

  declare @CURRENTDATE datetime = getdate();

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

  begin try
    update 
      dbo.MARRIAGEOPTION
    set
      UPDATECONTACTINFO = @UPDATECONTACTINFO,
      UPDATENAMEFORMATS = @UPDATENAMEFORMATS,
      UPDATEHOUSEHOLDRECOGNITION = @UPDATEHOUSEHOLDRECOGNITION,
      UPDATEINDIVIDUALRELATIONSHIPS = @UPDATEINDIVIDUALRELATIONSHIPS,
      DATECHANGED = @CURRENTDATE,
      CHANGEDBYID = @CHANGEAGENTID

    if @@ROWCOUNT = 0
      insert into dbo.MARRIAGEOPTION
      (
        ID,
        UPDATECONTACTINFO,
        UPDATENAMEFORMATS,
        UPDATEHOUSEHOLDRECOGNITION,
        UPDATEINDIVIDUALRELATIONSHIPS,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED                                
      )
      values
      (
        newid(),
        @UPDATECONTACTINFO,
        @UPDATENAMEFORMATS,
        @UPDATEHOUSEHOLDRECOGNITION,
        @UPDATEINDIVIDUALRELATIONSHIPS,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE    
      )

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

  return 0;