USP_DATAFORMTEMPLATE_EDIT_DISBURSEMENTFORMAT

The save procedure used by the edit dataform template "Disbursement Format 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.
@NAME	nvarchar(20)	IN	Name
@DESCRIPTION	nvarchar(100)	IN	Description
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@REPORTCATALOGID	uniqueidentifier	IN	Layout template
@TYPECODE	tinyint	IN	Stock type
@PRENUMBERED	bit	IN	Pre-numbered stock
@PRINTTRANSACTIONSORDERCODE	tinyint	IN	Print order
@PRINTORDERCODE	tinyint	IN	Print order
@SORTTRANSACTIONSCODE	tinyint	IN	Sort transactions on the check stub by
@SORTORDERCODE	tinyint	IN	Sort order
@PRINTCUSTOMERNUMBER	bit	IN	Print customer number on the check stub
@PRINTSITEADDRESS	bit	IN	Print a site address on the check stub
@SITEADDRESSID	uniqueidentifier	IN	Address
@PRINTSTUBLOGO	bit	IN	Print a logo on the check stub
@STUBLOGO	varbinary	IN	Check stub logo
@PRINTTRANSITABANUMBER	bit	IN	Print Transit ABA number on the check
@PRINTORGANIZATIONNAME	bit	IN	Print organization name on the check
@ORGANIZATIONNAME	nvarchar(100)	IN	Organization name
@PRINTMESSAGE	bit	IN	Print messages on the check
@MESSAGE1	nvarchar(60)	IN	Message 1
@MESSAGE2	nvarchar(60)	IN	Message 2
@PRINTCHECKLOGO	bit	IN	Print a logo on the check
@CHECKLOGO	varbinary	IN	Check logo
@PRINTNUMBER	bit	IN	Print disbursement number

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DISBURSEMENTFORMAT (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(20),
  @DESCRIPTION nvarchar(100),
  @PAYMENTMETHODCODE tinyint,
  @REPORTCATALOGID uniqueidentifier,
  @TYPECODE tinyint,
  @PRENUMBERED bit,
  @PRINTTRANSACTIONSORDERCODE tinyint,
  @PRINTORDERCODE tinyint,
  @SORTTRANSACTIONSCODE tinyint,
  @SORTORDERCODE tinyint,
  @PRINTCUSTOMERNUMBER bit,
  @PRINTSITEADDRESS bit,
  @SITEADDRESSID uniqueidentifier,
  @PRINTSTUBLOGO bit,
  @STUBLOGO varbinary(max),
  @PRINTTRANSITABANUMBER bit,
  @PRINTORGANIZATIONNAME bit,
  @ORGANIZATIONNAME nvarchar(100),
  @PRINTMESSAGE bit,
  @MESSAGE1 nvarchar(60),
  @MESSAGE2 nvarchar(60),
  @PRINTCHECKLOGO bit,
  @CHECKLOGO varbinary(max)
    ,@PRINTNUMBER bit
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime;
    set @CURRENTDATE = getdate();

    begin try
        -- handle updating the data

        update dbo.DISBURSEMENTFORMAT set
            NAME = @NAME,
            DESCRIPTION = @DESCRIPTION,
            PAYMENTMETHODCODE = @PAYMENTMETHODCODE,
      REPORTCATALOGID = @REPORTCATALOGID,
      TYPECODE = @TYPECODE,
        PRENUMBERED = @PRENUMBERED,
      PRINTTRANSACTIONSORDERCODE = @PRINTTRANSACTIONSORDERCODE,
      PRINTORDERCODE = @PRINTORDERCODE,
      SORTTRANSACTIONSCODE = @SORTTRANSACTIONSCODE,
      SORTORDERCODE = @SORTORDERCODE,
      PRINTCUSTOMERNUMBER = @PRINTCUSTOMERNUMBER,
      PRINTSITEADDRESS = @PRINTSITEADDRESS,
      --SITEADDRESSID = @SITEADDRESSID,

      PRINTSTUBLOGO = @PRINTSTUBLOGO,
      STUBLOGO = @STUBLOGO,
      PRINTTRANSITABANUMBER = @PRINTTRANSITABANUMBER,
      PRINTORGANIZATIONNAME = @PRINTORGANIZATIONNAME,
      ORGANIZATIONNAME = @ORGANIZATIONNAME,
      PRINTMESSAGE = @PRINTMESSAGE,
      MESSAGE1 = @MESSAGE1,
      MESSAGE2 = @MESSAGE2,
      PRINTCHECKLOGO = @PRINTCHECKLOGO,
      CHECKLOGO = @CHECKLOGO,
            PRINTNUMBER = @PRINTNUMBER,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;