USP_BATCHSTATISTICS_ADD

Used to count the number of batch transactions by a user for a specific batch type.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@BATCHID	uniqueidentifier	IN
@APPUSERID	uniqueidentifier	IN
@BATCHTYPECATALOGID	uniqueidentifier	IN
@NUMBERROWSADDED	int	IN
@NUMBERROWSCHANGED	int	IN
@NUMBERROWSDELETED	int	IN
@NUMBERROWSCOMMITTEDSUCCESSFULLY	int	IN
@NUMBERROWEXCEPTIONS	int	IN

Definition

Copy



            CREATE procedure [dbo].[USP_BATCHSTATISTICS_ADD](
                @ID uniqueidentifier = null output,                        
                @CHANGEAGENTID uniqueidentifier = null,                        
                @BATCHID uniqueidentifier = null,
                @APPUSERID uniqueidentifier = null,
                @BATCHTYPECATALOGID uniqueidentifier = null,
                @NUMBERROWSADDED int = 0,
                @NUMBERROWSCHANGED int = 0,
                @NUMBERROWSDELETED int = 0,
                @NUMBERROWSCOMMITTEDSUCCESSFULLY int = 0,
                @NUMBERROWEXCEPTIONS int = 0
            )
            as

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

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

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

            /* Only add a record if there are values to store */
            if @NUMBERROWSADDED > 0 or @NUMBERROWSCHANGED > 0 or @NUMBERROWSDELETED > 0 or @NUMBERROWSCOMMITTEDSUCCESSFULLY > 0 or @NUMBERROWEXCEPTIONS > 0
            begin
                begin try                        
                    insert into dbo.BATCHSTATISTICS 
                        (ID,
                        BATCHID,
                        APPUSERID,
                        BATCHTYPECATALOGID,
                        NUMBERROWSADDED,
                        NUMBERROWSCHANGED,
                        NUMBERROWSDELETED,
                        NUMBERROWSCOMMITTEDSUCCESSFULLY,
                        NUMBERROWEXCEPTIONS,            
                        ADDEDBYID,
                        CHANGEDBYID,
                        DATEADDED,
                        DATECHANGED)
                    values
                        (@ID,
                        @BATCHID,
                        @APPUSERID,
                        @BATCHTYPECATALOGID,
                        @NUMBERROWSADDED,
                        @NUMBERROWSCHANGED,
                        @NUMBERROWSDELETED,
                        @NUMBERROWSCOMMITTEDSUCCESSFULLY,
                        @NUMBERROWEXCEPTIONS,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CURRENTDATE,
                        @CURRENTDATE)
                end try

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

            return 0;