USP_DATAFORMTEMPLATE_EDIT_DATATUNEUP_4

CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DATATUNEUP_4
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @ADDRESSFORMATTINGCODE tinyint,
  @DONOTABBREVIATE bit,
  @CAPITALIZE bit,
  @FTPCONNECTIONCODE tinyint
)
as

  set nocount on;

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

  declare @CURRENTDATE datetime = getdate();

  begin try
    update dbo.DATATUNEUP set
      [ADDRESSFORMATTINGCODE] = @ADDRESSFORMATTINGCODE,
      [DONOTABBREVIATE] = @DONOTABBREVIATE,
      [CAPITALIZE] = @CAPITALIZE,
      [FTPCONNECTIONCODE] = @FTPCONNECTIONCODE,
      [CHANGEDBYID] = @CHANGEAGENTID,
      [DATECHANGED] = @CURRENTDATE
    where 
      [ID] = @ID;
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch
return 0;