/// <summary>Calls stored procedure 'CreateEmployeeClassification'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="employeeClassificationName">Input parameter. </param>
/// <param name="isExempt">Input parameter. </param>
/// <param name="isEmployee">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable CreateEmployeeClassification(System.String employeeClassificationName, System.Boolean isExempt, System.Boolean isEmployee, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateCreateEmployeeClassificationCall(dataAccessProvider, employeeClassificationName, isExempt, isEmployee))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'GetEmployeeClassifications'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="employeeClassificationKey">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable GetEmployeeClassifications(Nullable <System.Int32> employeeClassificationKey, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateGetEmployeeClassificationsCall(dataAccessProvider, employeeClassificationKey))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'FriendSuggestion'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="userId">Input parameter. </param>
/// <param name="numberOfLevels">Input parameter. </param>
/// <param name="pageNumber">Input parameter. </param>
/// <param name="pageSize">Input parameter. </param>
/// <param name="isRandom">Input parameter. </param>
/// <param name="userName">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable FriendSuggestion(System.Guid userId, System.Int32 numberOfLevels, System.Int32 pageNumber, System.Int32 pageSize, System.Boolean isRandom, System.String userName, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateFriendSuggestionCall(dataAccessProvider, userId, numberOfLevels, pageNumber, pageSize, isRandom, userName))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'CountEmployeesByClassification'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable CountEmployeesByClassification(IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateCountEmployeesByClassificationCall(dataAccessProvider))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'CustOrdersDetail'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="orderId">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable CustOrdersDetail(System.Int32 orderId, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateCustOrdersDetailCall(dataAccessProvider, orderId))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'VenueDistance'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="maxDistance">Input parameter. </param>
/// <param name="lat">Input parameter. </param>
/// <param name="lng">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable VenueDistance(System.Double maxDistance, System.Double lat, System.Double lng, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateVenueDistanceCall(dataAccessProvider, maxDistance, lat, lng))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'Ten Most Expensive Products'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable TenMostExpensiveProducts(IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateTenMostExpensiveProductsCall(dataAccessProvider))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'CustOrderHist'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="customerId">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable CustOrderHist(System.String customerId, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateCustOrderHistCall(dataAccessProvider, customerId))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'Sales by Year'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <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, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateSalesByYearCall(dataAccessProvider, beginningDate, endingDate))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'SalesByCategory'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <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, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateSalesByCategoryAndYearCall(dataAccessProvider, categoryName, ordYear))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'SpBranchSel'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="branchId">Input parameter. </param>
/// <param name="searchText">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable SpBranchSel(System.Int32 branchId, System.String searchText, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateSpBranchSelCall(dataAccessProvider, branchId, searchText))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'SpRoomSel'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="roomId">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable SpRoomSel(System.Int32 roomId, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateSpRoomSelCall(dataAccessProvider, roomId))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'SpRoomAvailabilitySel'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="startDate">Input parameter. </param>
/// <param name="endDate">Input parameter. </param>
/// <param name="branchId">Input parameter. </param>
/// <returns>Filled DataTable with resultset(s) of stored procedure</returns>
public static DataTable SpRoomAvailabilitySel(System.DateTime startDate, System.DateTime endDate, System.Int32 branchId, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateSpRoomAvailabilitySelCall(dataAccessProvider, startDate, endDate, branchId))
{
DataTable toReturn = call.FillDataTable();
return(toReturn);
}
}