USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTDEPOSITCORRECTIONATTACHMENT

The save procedure used by the edit dataform template "Bank Account Deposit Correction Attachment Edit Data 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.
@DATEENTERED	datetime	IN	Date
@TITLE	nvarchar(50)	IN	Title
@AUTHORID	uniqueidentifier	IN	Author
@ATTACHMENTTYPECODEID	uniqueidentifier	IN	Type
@FILE	varbinary	IN	File
@FILENAME	nvarchar(255)	IN	File
@DISPLAYEDFILENAME	nvarchar(255)	IN	File
@FILECHANGED	bit	IN	File changed?

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BANKACCOUNTDEPOSITCORRECTIONATTACHMENT (
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @DATEENTERED datetime, 
  @TITLE nvarchar(50),
  @AUTHORID uniqueidentifier,
  @ATTACHMENTTYPECODEID uniqueidentifier,
  @FILE varbinary(max),
  @FILENAME nvarchar(255),
  @DISPLAYEDFILENAME nvarchar(255),
  @FILECHANGED bit
)
as

    set nocount on;

    declare @CURRENTDATE datetime;

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

      set @CURRENTDATE = getdate();

      if @FILECHANGED = 1
          update
              dbo.[BANKACCOUNTDEPOSITCORRECTIONATTACHMENT]
          set
              [DATEENTERED] = @DATEENTERED,
              [TITLE] = @TITLE,
              [AUTHORID] = @AUTHORID,
              [CORRECTIONATTACHMENTTYPECODEID] = @ATTACHMENTTYPECODEID,
              [FILE] = @FILE,
              [FILENAME] = @DISPLAYEDFILENAME,
              [CHANGEDBYID] = @CHANGEAGENTID,
              [DATECHANGED] = @CURRENTDATE
          where
              [ID] = @ID;
      else
          update
              dbo.[BANKACCOUNTDEPOSITCORRECTIONATTACHMENT]
          set
              [DATEENTERED] = @DATEENTERED,
              [TITLE] = @TITLE,
              [AUTHORID] = @AUTHORID,
              [CORRECTIONATTACHMENTTYPECODEID] = @ATTACHMENTTYPECODEID,
              [CHANGEDBYID] = @CHANGEAGENTID,
              [DATECHANGED] = @CURRENTDATE
          where
              [ID] = @ID;
  end try

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

  return 0;