USP_DATAFORMTEMPLATE_ADD_DISBURSEMENTFORMAT

The save procedure used by the add dataform template "Disbursement Format Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@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 order1
@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_ADD_DISBURSEMENTFORMAT
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(20) = '',
  @DESCRIPTION nvarchar(100) = '',
  @PAYMENTMETHODCODE tinyint = 0,
  @REPORTCATALOGID uniqueidentifier = null,
  @TYPECODE tinyint = 0,
  @PRENUMBERED bit = 0,
  @PRINTTRANSACTIONSORDERCODE tinyint = 0,
  @PRINTORDERCODE tinyint = 0,
  @SORTTRANSACTIONSCODE tinyint = 0,
  @SORTORDERCODE tinyint = 0,
  @PRINTCUSTOMERNUMBER bit = 0,
  @PRINTSITEADDRESS bit = 0,
  @SITEADDRESSID uniqueidentifier = null,
  @PRINTSTUBLOGO bit = 0,
  @STUBLOGO varbinary(max) = null,
  @PRINTTRANSITABANUMBER bit = 0,
  @PRINTORGANIZATIONNAME bit = 0,
  @ORGANIZATIONNAME nvarchar(100) = '',
  @PRINTMESSAGE bit = 0,
  @MESSAGE1 nvarchar(60) = '',
  @MESSAGE2 nvarchar(60) = '',
  @PRINTCHECKLOGO bit = 0,
  @CHECKLOGO varbinary(max) = null
    ,@PRINTNUMBER bit = 1
)
as

  set nocount on;

  if @ID is null
    set @ID = newid();

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

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

  begin try
      -- handle inserting the data

      insert into dbo.DISBURSEMENTFORMAT(
      ID, 
      NAME, 
      DESCRIPTION, 
      PAYMENTMETHODCODE, 
      REPORTCATALOGID,
      TYPECODE,
        PRENUMBERED,
      PRINTTRANSACTIONSORDERCODE,
      PRINTORDERCODE,
      SORTTRANSACTIONSCODE,
      SORTORDERCODE,
      PRINTCUSTOMERNUMBER,
      PRINTSITEADDRESS,
      --SITEADDRESSID,

      PRINTSTUBLOGO,
      STUBLOGO,
      PRINTTRANSITABANUMBER,
      PRINTORGANIZATIONNAME,
      ORGANIZATIONNAME,
      PRINTMESSAGE,
      MESSAGE1,
      MESSAGE2,
      PRINTCHECKLOGO,
      CHECKLOGO,
            PRINTNUMBER,
      ADDEDBYID, 
      CHANGEDBYID, 
      DATEADDED, 
      DATECHANGED)
    values(
      @ID, 
      @NAME, 
      @DESCRIPTION, 
      @PAYMENTMETHODCODE, 
      @REPORTCATALOGID,
      @TYPECODE,
        @PRENUMBERED,
      @PRINTTRANSACTIONSORDERCODE,
      @PRINTORDERCODE,
      @SORTTRANSACTIONSCODE,
      @SORTORDERCODE,
      @PRINTCUSTOMERNUMBER,
      @PRINTSITEADDRESS,
      --@SITEADDRESSID,

      @PRINTSTUBLOGO,
      @STUBLOGO,
      @PRINTTRANSITABANUMBER,
      @PRINTORGANIZATIONNAME,
      @ORGANIZATIONNAME,
      @PRINTMESSAGE,
      @MESSAGE1,
      @MESSAGE2,
      @PRINTCHECKLOGO,
      @CHECKLOGO,
            @PRINTNUMBER,
      @CHANGEAGENTID, 
      @CHANGEAGENTID, 
      @CURRENTDATE, 
      @CURRENTDATE)

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