MsSql 2000 Stored Procedure convert to MySql Procedure

See more:

SQL-server-2000

C#

SQL-Server

, +

The following Stored procedure created to use with C# 2005. Now, I would like to convert this procedure to MySQL / C#.

Please help me to change to use with the C# 2005.

CREATE PROCEDURE AUTOGENERATEBILLNUMBER 
(
@ACCYEAR INT
)
AS	
BEGIN
	DECLARE @COUNT INT
	DECLARE @BILLNUMBER INT
	DECLARE @MAXBILLNUMBER INT
	DECLARE @LENGTH INT

	SELECT @MAXBILLNUMBER  = MAX(BILL_NO) FROM BILLS WHERE ACC_YEAR = @ACCYEAR
	IF(@MAXBILLNUMBER IS NULL)
	BEGIN
	SET @MAXBILLNUMBER = 1
	
	END

	ELSE
	BEGIN
	SET @MAXBILLNUMBER = @MAXBILLNUMBER + 1
	
	END
	INSERT INTO BILLS (BILL_NO,ACC_YEAR) VALUES (@MAXBILLNUMBER,@ACCYEAR)
END
GO