Executing Stored Procedure from ASP.net

Hello,

I have get_sales stored procedure which is working absolutely fine when org_id,sales_limit are passed from the query analyzer. Now from the asp.net page I have this function to get the sales.


from my page I am trying to execute this function

Private Function getNewSales(ByVal sales_limit As Double) As Double
getSales(Session.Item("BB").ToString, sales_limit, 0)

Return getNewSales

End Function

But I am not getting the value. Please help.



Public Function getSales(ByVal _org_id As String, ByVal sales_limit As Double, ByRef _FF As Double) As Boolean



            Dim cmd As New System.Data.SqlClient.SqlCommand
            cmd.CommandText = "dbo.[get_sales]"
            cmd.CommandType = System.Data.CommandType.StoredProcedure
            cmd.Connection = sql_connection
            cmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4,    System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
            cmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@org_id", System.Data.SqlDbType.VarChar, 10))
            cmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@sales_limit", System.Data.SqlDbType.Float, 8))
            cmd.Parameters.Add(New System.Data.SqlClient.SqlParameter("@FF", System.Data.SqlDbType.Float, 8, System.Data.ParameterDirection.Output, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))

            cmd.Parameters("@franchise_id").Value = _org_id
            cmd.Parameters("@sales_limit").Value = sales_limit


            sql_connection.Open()

            Dim reader As SqlDataReader = cmd.ExecuteReader()

            If reader.Read() Then
                _ff = Convert.ToDouble(reader("ff"))
            Else
                _f = 0


            End If
            sql_connection.Close()

            If CInt(cmd.Parameters("@RETURN_VALUE").Value) = 0 Then
                Return True
            Else
                Return False
            End If


        End Function