/// <summary>Calls stored procedure 'pr_CustomersAndOrdersOnCountry'.<br/><br/></summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="country">Input parameter. </param>
/// <returns>Number of rows affected, if the database / routine doesn't suppress rowcounting.</returns>
public static int CustomersAndOrdersOnCountry(System.String country, IDataAccessCore dataAccessProvider)
{
using (StoredProcedureCall call = CreateCustomersAndOrdersOnCountryCall(dataAccessProvider, country))
{
int toReturn = call.Call();
return(toReturn);
}
}
/// <summary>Calls stored procedure 'DeleteSegmentCustomers'.<br/><br/></summary>
/// <param name="channelId">Input parameter of stored procedure. </param>
/// <param name="transactionToUse">the transaction to use, or null if no transaction is available.</param>
/// <returns>Number of rows affected, if the database / routine doesn't surpress rowcounting.</returns>
public static int DeleteSegmentCustomers(System.Int32 channelId, ITransaction transactionToUse)
{
using (StoredProcedureCall call = CreateDeleteSegmentCustomersCall(new DataAccessCoreImpl(new CommonDaoBase(), transactionToUse), channelId))
{
int toReturn = call.Call();
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 '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 '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);
}
}
/// <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 '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 '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 '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 '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 '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 '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 '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 'GetSegmentCustomers'.<br/><br/></summary>
/// <param name="channelId">Input parameter of stored procedure. </param>
/// <param name="totalCustomers">InputOutput parameter of stored procedure. </param>
/// <param name="transactionToUse">the transaction to use, or null if no transaction is available.</param>
/// <returns>Number of rows affected, if the database / routine doesn't surpress rowcounting.</returns>
public static int GetSegmentCustomers(System.Int32 channelId, ref System.Int32 totalCustomers, ITransaction transactionToUse)
{
using (StoredProcedureCall call = CreateGetSegmentCustomersCall(new DataAccessCoreImpl(new CommonDaoBase(), transactionToUse), channelId, totalCustomers))
{
int toReturn = call.Call();
totalCustomers = call.GetParameterValue <System.Int32>(1);
return(toReturn);
}
}
/// <summary>Fetches instances of the the typed view row 'CreateEmployeeClassificationResultRow' class using a stored procedure call. </summary>
/// <typeparam name="T">The type of the typed view row</typeparam>
/// <param name="adapter">The adapter.</param>
/// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetCreateEmployeeClassificationResultTypedViewProjection().</param>
/// <param name="employeeClassificationName">Input parameter of stored procedure</param>
/// <param name="isExempt">Input parameter of stored procedure</param>
/// <param name="isEmployee">Input parameter of stored procedure</param>
/// <returns>The results in a List</returns>
public static List <T> FetchCreateEmployeeClassificationResultTypedView <T>(IDataAccessAdapter adapter, SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, System.String employeeClassificationName, System.Boolean isExempt, System.Boolean isEmployee)
{
StoredProcedureCall call = CreateCreateEmployeeClassificationCall(adapter, employeeClassificationName, isExempt, isEmployee);
IRetrievalQuery query = call.ToRetrievalQuery();
query.ResultsetNumber = 1;
var toReturn = adapter.FetchQueryFromSource(projectionOfTypedView, query);
return(toReturn);
}
/// <summary>Fetches instances of the the typed view row 'CountEmployeesByClassificationResultRow' class using a stored procedure call. </summary>
/// <typeparam name="T">The type of the typed view row</typeparam>
/// <param name="adapter">The adapter.</param>
/// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetCountEmployeesByClassificationResultTypedViewProjection().</param>
/// <returns>The results in a List</returns>
public static List <T> FetchCountEmployeesByClassificationResultTypedView <T>(IDataAccessAdapter adapter, SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView)
{
StoredProcedureCall call = CreateCountEmployeesByClassificationCall(adapter);
IRetrievalQuery query = call.ToRetrievalQuery();
query.ResultsetNumber = 1;
var toReturn = adapter.FetchQueryFromSource(projectionOfTypedView, query);
return(toReturn);
}
/// <summary>Fetches instances of the the typed view row 'GetEmployeeClassificationsResultRow' class using a stored procedure call. </summary>
/// <typeparam name="T">The type of the typed view row</typeparam>
/// <param name="adapter">The adapter.</param>
/// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetGetEmployeeClassificationsResultTypedViewProjection().</param>
/// <param name="employeeClassificationKey">Input parameter of stored procedure</param>
/// <returns>The results in a List</returns>
public static List <T> FetchGetEmployeeClassificationsResultTypedView <T>(IDataAccessAdapter adapter, SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, Nullable <System.Int32> employeeClassificationKey)
{
StoredProcedureCall call = CreateGetEmployeeClassificationsCall(adapter, employeeClassificationKey);
IRetrievalQuery query = call.ToRetrievalQuery();
query.ResultsetNumber = 1;
var toReturn = adapter.FetchQueryFromSource(projectionOfTypedView, query);
return(toReturn);
}
/// <summary>Fetches instances of the the typed view row 'VenueDistanceResultRow' class using a stored procedure call. </summary>
/// <typeparam name="T">The type of the typed view row</typeparam>
/// <param name="adapter">The adapter.</param>
/// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetVenueDistanceResultTypedViewProjection().</param>
/// <param name="maxDistance">Input parameter of stored procedure</param>
/// <param name="lat">Input parameter of stored procedure</param>
/// <param name="lng">Input parameter of stored procedure</param>
/// <returns>The results in a List</returns>
public static List <T> FetchVenueDistanceResultTypedView <T>(IDataAccessAdapter adapter, SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, System.Double maxDistance, System.Double lat, System.Double lng)
{
StoredProcedureCall call = CreateVenueDistanceCall(adapter, maxDistance, lat, lng);
IRetrievalQuery query = call.ToRetrievalQuery();
query.ResultsetNumber = 1;
var toReturn = adapter.FetchQueryFromSource(projectionOfTypedView, query);
return(toReturn);
}
