Three Tier Code Generator For ASP.NET

/*==========================================================================================
**
** FILE  : ProcAddUsers_Tb.sql
** Author:Stevan Rodrigues
**
**==========================================================================================
**
** (c) The contents of this file , and of any file or document derived from it , are copyright 
** to Site Builders . Unlicensed alteration, change or copying in any form, 
** whether written, by photocopy, by print or by any other methods of reproduction is 
** strictly prohibited.
**
**==========================================================================================
**
** PURPOSE OF FILE :
**
** DETAILED DESCRIPTION OF FUNCTIONALITY
** LIST OF PARAMETERS USED
	@UserId int output,
	@FirstName VARCHAR(75),
	@LastName VARCHAR(75),
	@Email VARCHAR(100),
	@Comments VARCHAR(500),
	@AddedDate datetime,
	@UpdatedDate datetime, 
	@EditUsername varchar(25) 
**
** LIST OF RETURN VALUES AND THEIR DEFINITIONS
** 0	:   Successful
**=========================================================================================*/
if exists( select * from sysobjects where id = object_id(N'[dbo].[ProcAddUsers_Tb]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
	drop proc [dbo].[ProcAddUsers_Tb]
go
create procedure ProcAddUsers_Tb
	@UserId int output,
	@FirstName VARCHAR(75),
	@LastName VARCHAR(75),
	@Email VARCHAR(100),
	@Comments VARCHAR(500),
	@AddedDate datetime,
	@UpdatedDate datetime, 
	@EditUsername varchar(25) 
as
	set nocount on
	Declare @ErrorNumber int,
		@RowCount int,
		@CountRec int,
		@EditAdminId int,
		@TableName varchar(50),
		@PrimaryId int,
		@Action varchar(15),
		@ActionDate datetime

	select @CountRec = COUNT(*) FROM Users_Tb
	where Email = @Email
	if @CountRec = 0
	begin
		insert into Users_Tb(
			FirstName, 
			LastName, 
			Email, 
			Comments, 
			AddedDate,
			UpdatedDate
		)
		values (
			@FirstName, 
			@LastName, 
			@Email, 
			@Comments, 
			@AddedDate,
			@UpdatedDate
		)

		-- error checking
		select @ErrorNumber = @@error, 
		@RowCount = @@rowcount
		if ( @ErrorNumber <> 0 )
		begin
			/*exec ErrorHandler @ErrorNumber, 'Users_Tb', 'adding'*/
			set nocount off
			return 1
		end

		select @UserId = @@IDENTITY
		select @EditAdminId = AdminId from Admin_Tb
			where Username = @EditUsername
		select @TableName = 'Users_Tb'
		select @PrimaryId = @UserId
		select @Action = 'Add'
		select @ActionDate = @AddedDate 
		exec ProcAddRecordAction_Tb @EditAdminId, @TableName, @PrimaryId, @Action, @ActionDate
	end
	else
	begin
		select  @UserId =  0 
		 return 2 
	end
	set nocount off
	return 0
go