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