USP_DATAFORMTEMPLATE_EDIT_GLOBALMARRIAGERULES_2

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GLOBALMARRIAGERULES_2
(
  @CHANGEAGENTID uniqueidentifier = null,
  @SETMARITALSTATUS bit,
  @MARITALSTATUSCODEID uniqueidentifier,
  @COPYPHONENUMBER bit,
  @COPYEMAILADDRESS bit
)
as
  set nocount on;

  declare @CURRENTDATE datetime = getdate();

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

  if @SETMARITALSTATUS = 0
    set @MARITALSTATUSCODEID = null;

  begin try
    update 
      dbo.MARRIAGERULE
    set
      SETMARITALSTATUS = @SETMARITALSTATUS,
      MARITALSTATUSCODEID = @MARITALSTATUSCODEID,
      COPYPHONENUMBER = @COPYPHONENUMBER,
      COPYEMAILADDRESS = @COPYEMAILADDRESS,
      DATECHANGED = @CURRENTDATE,
      CHANGEDBYID = @CHANGEAGENTID

    if @@ROWCOUNT = 0
      insert into dbo.MARRIAGERULE
      (
        ID,
        SETMARITALSTATUS,
        MARITALSTATUSCODEID,
        COPYPHONENUMBER,
        COPYEMAILADDRESS,
        ADDEDBYID,
        CHANGEDBYID,
        DATEADDED,
        DATECHANGED                                
      )
      values
      (
        newid(),
        @SETMARITALSTATUS,
        @MARITALSTATUSCODEID,
        @COPYPHONENUMBER,
        @COPYEMAILADDRESS,
        @CHANGEAGENTID,
        @CHANGEAGENTID,
        @CURRENTDATE,
        @CURRENTDATE    
      )
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

  return 0;