DBLayer Wizard V 1.0

using System;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Collections;
namespace DBLayer
{
/// <summary>
/// Summary description for DBSP.
/// </summary>
public class DBSP:DB
{
private DBSP()
{
}

public static DataSet Ten_Most_Expensive_Products(out Int32 RETURN_VALUE)
{
	ArrayList Parameters=new ArrayList(0);

	SqlParameter RETURN_VALUEParameter=new SqlParameter("@RETURN_VALUE",SqlDbType.Int);
	RETURN_VALUEParameter.Size=0;
	RETURN_VALUEParameter.Direction=ParameterDirection.ReturnValue;
	Parameters.Add(RETURN_VALUEParameter);

	 DataSet dsResult=ExecuteStoredProcedure("[Ten Most Expensive Products]",ref Parameters);
	RETURN_VALUE=(Int32)RETURN_VALUEParameter.Value;

	return dsResult;
}
public static DataSet Ten_Most_Expensive_Products()
{
	ArrayList Parameters=new ArrayList(0);

	 DataSet dsResult=ExecuteStoredProcedure("[Ten Most Expensive Products]",ref Parameters);

	return dsResult;
}
public static SqlDataReader Ten_Most_Expensive_ProductsReader()
{
	ArrayList Parameters=new ArrayList(0);

	 SqlDataReader readerResult=ExecuteStoredProcedureReader("[Ten Most Expensive Products]",ref Parameters);

	return readerResult;
}
public static int Ten_Most_Expensive_ProductsReturnValue()
{
	int Return_Value;
	Ten_Most_Expensive_Products(out Return_Value);
	return Return_Value;
}
public static DataSet Employee_Sales_by_Country(out Int32 RETURN_VALUE,DateTime Beginning_Date,DateTime Ending_Date)
{
	ArrayList Parameters=new ArrayList(0);

	SqlParameter RETURN_VALUEParameter=new SqlParameter("@RETURN_VALUE",SqlDbType.Int);
	RETURN_VALUEParameter.Size=0;
	RETURN_VALUEParameter.Direction=ParameterDirection.ReturnValue;
	Parameters.Add(RETURN_VALUEParameter);

	SqlParameter Beginning_DateParameter=new SqlParameter("@Beginning_Date",SqlDbType.DateTime);
	Beginning_DateParameter.Size=0;
	Beginning_DateParameter.Value=Beginning_Date;
	Parameters.Add(Beginning_DateParameter);

	SqlParameter Ending_DateParameter=new SqlParameter("@Ending_Date",SqlDbType.DateTime);
	Ending_DateParameter.Size=0;
	Ending_DateParameter.Value=Ending_Date;
	Parameters.Add(Ending_DateParameter);

	 DataSet dsResult=ExecuteStoredProcedure("[Employee Sales by Country]",ref Parameters);
	RETURN_VALUE=(Int32)RETURN_VALUEParameter.Value;

	return dsResult;
}
public static DataSet Employee_Sales_by_Country(DateTime Beginning_Date,DateTime Ending_Date)
{
	ArrayList Parameters=new ArrayList(0);

	SqlParameter Beginning_DateParameter=new SqlParameter("@Beginning_Date",SqlDbType.DateTime);
	Beginning_DateParameter.Size=0;
	Beginning_DateParameter.Value=Beginning_Date;
	Parameters.Add(Beginning_DateParameter);

	SqlParameter Ending_DateParameter=new SqlParameter("@Ending_Date",SqlDbType.DateTime);
	Ending_DateParameter.Size=0;
	Ending_DateParameter.Value=Ending_Date;
	Parameters.Add(Ending_DateParameter);

	 DataSet dsResult=ExecuteStoredProcedure("[Employee Sales by Country]",ref Parameters);

	return dsResult;
}
public static SqlDataReader Employee_Sales_by_CountryReader(DateTime Beginning_Date,DateTime Ending_Date)
{
	ArrayList Parameters=new ArrayList(0);

	SqlParameter Beginning_DateParameter=new SqlParameter("@Beginning_Date",SqlDbType.DateTime);
	Beginning_DateParameter.Size=0;
	Beginning_DateParameter.Value=Beginning_Date;
	Parameters.Add(Beginning_DateParameter);

	SqlParameter Ending_DateParameter=new SqlParameter("@Ending_Date",SqlDbType.DateTime);
	Ending_DateParameter.Size=0;
	Ending_DateParameter.Value=Ending_Date;
	Parameters.Add(Ending_DateParameter);

	 SqlDataReader readerResult=ExecuteStoredProcedureReader("[Employee Sales by Country]",ref Parameters);

	return readerResult;
}
public static int Employee_Sales_by_CountryReturnValue(DateTime Beginning_Date,DateTime Ending_Date)
{
	int Return_Value;
	Employee_Sales_by_Country(out Return_Value, Beginning_Date, Ending_Date);
	return Return_Value;
}
public static DataSet SalesByCategory(out Int32 RETURN_VALUE,String CategoryName,String OrdYear)
{
	ArrayList Parameters=new ArrayList(0);

	SqlParameter RETURN_VALUEParameter=new SqlParameter("@RETURN_VALUE",SqlDbType.Int);
	RETURN_VALUEParameter.Size=0;
	RETURN_VALUEParameter.Direction=ParameterDirection.ReturnValue;
	Parameters.Add(RETURN_VALUEParameter);

	SqlParameter CategoryNameParameter=new SqlParameter("@CategoryName",SqlDbType.NVarChar);
	CategoryNameParameter.Size=15;
	CategoryNameParameter.Value=CategoryName;
	Parameters.Add(CategoryNameParameter);

	SqlParameter OrdYearParameter=new SqlParameter("@OrdYear",SqlDbType.NVarChar);
	OrdYearParameter.Size=4;
	OrdYearParameter.Value=OrdYear;
	Parameters.Add(OrdYearParameter);

	 DataSet dsResult=ExecuteStoredProcedure("[SalesByCategory]",ref Parameters);
	RETURN_VALUE=(Int32)RETURN_VALUEParameter.Value;

	return dsResult;
}
public static DataSet SalesByCategory(String CategoryName,String OrdYear)
{
	ArrayList Parameters=new ArrayList(0);

	SqlParameter CategoryNameParameter=new SqlParameter("@CategoryName",SqlDbType.NVarChar);
	CategoryNameParameter.Size=15;
	CategoryNameParameter.Value=CategoryName;
	Parameters.Add(CategoryNameParameter);

	SqlParameter OrdYearParameter=new SqlParameter("@OrdYear",SqlDbType.NVarChar);
	OrdYearParameter.Size=4;
	OrdYearParameter.Value=OrdYear;
	Parameters.Add(OrdYearParameter);

	 DataSet dsResult=ExecuteStoredProcedure("[SalesByCategory]",ref Parameters);

	return dsResult;
}
public static SqlDataReader SalesByCategoryReader(String CategoryName,String OrdYear)
{
	ArrayList Parameters=new ArrayList(0);

	SqlParameter CategoryNameParameter=new SqlParameter("@CategoryName",SqlDbType.NVarChar);
	CategoryNameParameter.Size=15;
	CategoryNameParameter.Value=CategoryName;
	Parameters.Add(CategoryNameParameter);

	SqlParameter OrdYearParameter=new SqlParameter("@OrdYear",SqlDbType.NVarChar);
	OrdYearParameter.Size=4;
	OrdYearParameter.Value=OrdYear;
	Parameters.Add(OrdYearParameter);

	 SqlDataReader readerResult=ExecuteStoredProcedureReader("[SalesByCategory]",ref Parameters);

	return readerResult;
}
public static int SalesByCategoryReturnValue(String CategoryName,String OrdYear)
{
	int Return_Value;
	SalesByCategory(out Return_Value, CategoryName, OrdYear);
	return Return_Value;
}
}
}