/// <summary>Calls stored procedure 'CustOrdersDetail'.<br/><br/></summary>
/// <param name="orderId">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable CustOrdersDetail(System.Int32 orderId)
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return CustOrdersDetail(orderId, dataAccessProvider);
}
}
/// <summary>Calls stored procedure 'CustOrdersOrders'.<br/><br/></summary>
/// <param name="customerId">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable CustOrdersOrders(System.String customerId)
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return CustOrdersOrders(customerId, dataAccessProvider);
}
}
/// <summary>Calls stored procedure 'Sales by Year'.<br/><br/></summary>
/// <param name="beginningDate">Input parameter. </param>
/// <param name="endingDate">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable SalesByYear(System.DateTime beginningDate, System.DateTime endingDate)
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return SalesByYear(beginningDate, endingDate, dataAccessProvider);
}
}
/// <summary>Calls stored procedure 'Ten Most Expensive Products'.<br/><br/></summary>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable TenMostExpensiveProducts()
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return TenMostExpensiveProducts(dataAccessProvider);
}
}
/// <summary>Creates an IRetrievalQuery object for a call to the procedure 'Ten Most Expensive Products'.</summary>
/// <returns>IRetrievalQuery object which is ready to use for datafetching</returns>
public static IRetrievalQuery GetTenMostExpensiveProductsCallAsQuery()
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return CreateTenMostExpensiveProductsCall(dataAccessProvider).ToRetrievalQuery();
}
}
/// <summary>Calls stored procedure 'SalesByCategory'.<br/><br/></summary>
/// <param name="categoryName">Input parameter. </param>
/// <param name="ordYear">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable SalesByCategoryAndYear(System.String categoryName, System.String ordYear)
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return SalesByCategoryAndYear(categoryName, ordYear, dataAccessProvider);
}
}
/// <summary>Creates an IRetrievalQuery object for a call to the procedure 'Sales by Year'.</summary>
/// <param name="beginningDate">Input parameter of stored procedure</param>
/// <param name="endingDate">Input parameter of stored procedure</param>
/// <returns>IRetrievalQuery object which is ready to use for datafetching</returns>
public static IRetrievalQuery GetSalesByYearCallAsQuery(System.DateTime beginningDate, System.DateTime endingDate)
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return CreateSalesByYearCall(dataAccessProvider, beginningDate, endingDate).ToRetrievalQuery();
}
}
/// <summary>Creates an IRetrievalQuery object for a call to the procedure 'SalesByCategory'.</summary>
/// <param name="categoryName">Input parameter of stored procedure</param>
/// <param name="ordYear">Input parameter of stored procedure</param>
/// <returns>IRetrievalQuery object which is ready to use for datafetching</returns>
public static IRetrievalQuery GetSalesByCategoryAndYearCallAsQuery(System.String categoryName, System.String ordYear)
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return CreateSalesByCategoryAndYearCall(dataAccessProvider, categoryName, ordYear).ToRetrievalQuery();
}
}
/// <summary>Creates an IRetrievalQuery object for a call to the procedure 'CustOrdersOrders'.</summary>
/// <param name="customerId">Input parameter of stored procedure</param>
/// <returns>IRetrievalQuery object which is ready to use for datafetching</returns>
public static IRetrievalQuery GetCustOrdersOrdersCallAsQuery(System.String customerId)
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return CreateCustOrdersOrdersCall(dataAccessProvider, customerId).ToRetrievalQuery();
}
}
/// <summary>Creates an IRetrievalQuery object for a call to the procedure 'CustOrdersDetail'.</summary>
/// <param name="orderId">Input parameter of stored procedure</param>
/// <returns>IRetrievalQuery object which is ready to use for datafetching</returns>
public static IRetrievalQuery GetCustOrdersDetailCallAsQuery(System.Int32 orderId)
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return CreateCustOrdersDetailCall(dataAccessProvider, orderId).ToRetrievalQuery();
}
}
/// <summary>Calls stored procedure 'Employee Sales by Country'.<br/><br/></summary>
/// <param name="beginningDate">Input parameter. </param>
/// <param name="endingDate">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable EmployeeSalesByCountry(System.DateTime beginningDate, System.DateTime endingDate)
{
using(DataAccessAdapter dataAccessProvider = new DataAccessAdapter())
{
return EmployeeSalesByCountry(beginningDate, endingDate, dataAccessProvider);
}
}
