USP_RECEIPTSTACKINFO_ADD

The save procedure used by the add dataform template "Define Receipt Stack".

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(100)	IN	Name
@SHORTNAME	nvarchar(10)	IN	Short name
@NEXTRECEIPTNUMBER	int	IN	Next number
@RECEIPTSTACKCODEID	uniqueidentifier	IN	Type

Definition

Copy



         CREATE procedure dbo.USP_RECEIPTSTACKINFO_ADD
(
      @ID uniqueidentifier = null output,
      @CHANGEAGENTID uniqueidentifier = null,
      @NAME nvarchar(100) = '',
    @SHORTNAME nvarchar(10) = '',
    @NEXTRECEIPTNUMBER int = 0,
      @RECEIPTSTACKCODEID uniqueidentifier = null
      )
      as                    
      set nocount on;

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

     declare @ISDEFAULT bit = 0;

      declare @CURRENTDATE datetime;

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

      set @CURRENTDATE = getdate();

      begin try
        insert into dbo.RECEIPTSTACKINFO
    (
ID,
NAME, 
SHORTNAME,
NEXTRECEIPTNUMBER,
ISACTIVE, 
RECEIPTSTACKCODEID, 
ADDEDBYID, 
CHANGEDBYID, 
DATEADDED, 
DATECHANGED
) 
values
(
  @ID,
  @NAME,
  @SHORTNAME,
  @NEXTRECEIPTNUMBER,
  1, 
  @RECEIPTSTACKCODEID, 
  @CHANGEAGENTID, 
  @CHANGEAGENTID,
  @CURRENTDATE, 
  @CURRENTDATE
);
      end try
        begin catch
          exec dbo.USP_RAISE_ERROR;
          return 1;
        end catch

        return 0;