/// <summary>Creates the call object for the call 'SpRoomAvailabilitySel' to stored procedure 'SpRoomAvailabilitySel'.</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>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateSpRoomAvailabilitySelCall(IDataAccessCore dataAccessProvider, System.DateTime startDate, System.DateTime endDate, System.Int32 branchId)
{
return(new StoredProcedureCall(dataAccessProvider, @"[HARS_Susmita].[dbo].[SpRoomAvailabilitySel]", "SpRoomAvailabilitySel")
.AddParameter("@StartDate", "Date", 0, ParameterDirection.Input, true, 0, 0, startDate)
.AddParameter("@EndDate", "Date", 0, ParameterDirection.Input, true, 0, 0, endDate)
.AddParameter("@BranchId", "Int", 0, ParameterDirection.Input, true, 10, 0, branchId));
}
/// <summary>Creates the call object for the call 'VenueDistance' to stored procedure 'VenueDistance'.</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>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateVenueDistanceCall(IDataAccessCore dataAccessProvider, System.Double maxDistance, System.Double lat, System.Double lng)
{
return(new StoredProcedureCall(dataAccessProvider, @"[TestOrg].[dbo].[VenueDistance]", "VenueDistance")
.AddParameter("@MaxDistance", "Float", 0, ParameterDirection.Input, true, 38, 0, maxDistance)
.AddParameter("@Lat", "Float", 0, ParameterDirection.Input, true, 38, 0, lat)
.AddParameter("@Lng", "Float", 0, ParameterDirection.Input, true, 38, 0, lng));
}
/// <summary>Creates the call object for the call 'CreateEmployeeClassification' to stored procedure 'CreateEmployeeClassification'.</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>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateCreateEmployeeClassificationCall(IDataAccessCore dataAccessProvider, System.String employeeClassificationName, System.Boolean isExempt, System.Boolean isEmployee)
{
return(new StoredProcedureCall(dataAccessProvider, @"[ORMCookbook].[HR].[CreateEmployeeClassification]", "CreateEmployeeClassification")
.AddParameter("@EmployeeClassificationName", "VarChar", 30, ParameterDirection.Input, true, 0, 0, employeeClassificationName)
.AddParameter("@IsExempt", "Bit", 0, ParameterDirection.Input, true, 0, 0, isExempt)
.AddParameter("@IsEmployee", "Bit", 0, ParameterDirection.Input, true, 0, 0, isEmployee));
}
/// <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 '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 '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 '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 '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 '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 '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 '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>Creates the call object for the call 'FriendSuggestion' to stored procedure 'FriendSuggestion'.</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>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateFriendSuggestionCall(IDataAccessCore dataAccessProvider, System.Guid userId, System.Int32 numberOfLevels, System.Int32 pageNumber, System.Int32 pageSize, System.Boolean isRandom, System.String userName)
{
return(new StoredProcedureCall(dataAccessProvider, @"[MonoX2].[dbo].[FriendSuggestion]", "FriendSuggestion")
.AddParameter("@UserId", "UniqueIdentifier", 0, ParameterDirection.Input, true, 0, 0, userId)
.AddParameter("@NumberOfLevels", "Int", 0, ParameterDirection.Input, true, 10, 0, numberOfLevels)
.AddParameter("@PageNumber", "Int", 0, ParameterDirection.Input, true, 10, 0, pageNumber)
.AddParameter("@PageSize", "Int", 0, ParameterDirection.Input, true, 10, 0, pageSize)
.AddParameter("@IsRandom", "Bit", 0, ParameterDirection.Input, true, 0, 0, isRandom)
.AddParameter("@UserName", "NVarChar", 200, ParameterDirection.Input, true, 0, 0, userName));
}
/// <summary>Creates an IRetrievalQuery object for a call to the procedure 'CreateEmployeeClassification'.</summary>
/// <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>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <returns>IRetrievalQuery object which is ready to use for datafetching</returns>
public static IRetrievalQuery GetCreateEmployeeClassificationCallAsQuery(System.String employeeClassificationName, System.Boolean isExempt, System.Boolean isEmployee, IDataAccessCore dataAccessProvider)
{
return(CreateCreateEmployeeClassificationCall(dataAccessProvider, employeeClassificationName, isExempt, isEmployee).ToRetrievalQuery());
}
/// <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>Creates the call object for the call 'CustOrdersOrders' to stored procedure 'CustOrdersOrders'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="customerId">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateCustOrdersOrdersCall(IDataAccessCore dataAccessProvider, System.String customerId)
{
return new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[CustOrdersOrders]", "CustOrdersOrders")
.AddParameter("@CustomerID", "NChar", 5, ParameterDirection.Input, true, 0, 0, customerId);
}
/// <summary>Creates the call object for the call 'TenMostExpensiveProducts' to stored procedure 'Ten Most Expensive Products'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateTenMostExpensiveProductsCall(IDataAccessCore dataAccessProvider)
{
return(new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[Ten Most Expensive Products]", "TenMostExpensiveProducts"));
}
/// <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 '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>Creates the call object for the call 'GetSegmentCustomers' to stored procedure 'GetSegmentCustomers'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="channelId">Input parameter</param>
/// <param name="totalCustomers">InputOutput parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateGetSegmentCustomersCall(IDataAccessCore dataAccessProvider, System.Int32 channelId, System.Int32 totalCustomers)
{
return(new StoredProcedureCall(dataAccessProvider, @"[mecca_cmt].[dbo].[GetSegmentCustomers]", "GetSegmentCustomers")
.AddParameter("@channelId", "Int", 0, ParameterDirection.Input, true, 10, 0, channelId)
.AddParameter("@totalCustomers", "Int", 0, ParameterDirection.InputOutput, true, 10, 0, totalCustomers));
}
/// <summary>Creates the call object for the call 'Install' to stored procedure 'pr_Install'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="adminEmailAddress">Input parameter</param>
/// <param name="adminPasswordHashed">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateInstallCall(IDataAccessCore dataAccessProvider, System.String adminEmailAddress, System.String adminPasswordHashed)
{
return(new StoredProcedureCall(dataAccessProvider, @"[HnD].[dbo].[pr_Install]", "Install")
.AddParameter("@sAdminEmailAddress", "NVarChar", 150, ParameterDirection.Input, true, 0, 0, adminEmailAddress)
.AddParameter("@sAdminPasswordHashed", "NVarChar", 128, ParameterDirection.Input, true, 0, 0, adminPasswordHashed));
}
/// <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>Creates an IRetrievalQuery object for a call to the procedure 'VenueDistance'.</summary>
/// <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>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <returns>IRetrievalQuery object which is ready to use for datafetching</returns>
public static IRetrievalQuery GetVenueDistanceCallAsQuery(System.Double maxDistance, System.Double lat, System.Double lng, IDataAccessCore dataAccessProvider)
{
return(CreateVenueDistanceCall(dataAccessProvider, maxDistance, lat, lng).ToRetrievalQuery());
}
/// <summary>Creates the call object for the call 'FriendSuggestion' to stored procedure 'FriendSuggestion'.</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>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateFriendSuggestionCall(IDataAccessCore dataAccessProvider, System.Guid userId, System.Int32 numberOfLevels, System.Int32 pageNumber, System.Int32 pageSize, System.Boolean isRandom, System.String userName)
{
return new StoredProcedureCall(dataAccessProvider, @"[MonoX2].[dbo].[FriendSuggestion]", "FriendSuggestion")
.AddParameter("@UserId", "UniqueIdentifier", 0, ParameterDirection.Input, true, 0, 0, userId)
.AddParameter("@NumberOfLevels", "Int", 0, ParameterDirection.Input, true, 10, 0, numberOfLevels)
.AddParameter("@PageNumber", "Int", 0, ParameterDirection.Input, true, 10, 0, pageNumber)
.AddParameter("@PageSize", "Int", 0, ParameterDirection.Input, true, 10, 0, pageSize)
.AddParameter("@IsRandom", "Bit", 0, ParameterDirection.Input, true, 0, 0, isRandom)
.AddParameter("@UserName", "NVarChar", 200, ParameterDirection.Input, true, 0, 0, userName);
}
/// <summary>Creates the call object for the call 'CustOrdersOrders' to stored procedure 'CustOrdersOrders'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="customerId">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateCustOrdersOrdersCall(IDataAccessCore dataAccessProvider, System.String customerId)
{
return(new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[CustOrdersOrders]", "CustOrdersOrders")
.AddParameter("@CustomerID", "NChar", 5, ParameterDirection.Input, true, 0, 0, customerId));
}
/// <summary>Creates the call object for the call 'SalesByCategoryAndYear' to stored procedure 'SalesByCategory'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="categoryName">Input parameter</param>
/// <param name="ordYear">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateSalesByCategoryAndYearCall(IDataAccessCore dataAccessProvider, System.String categoryName, System.String ordYear)
{
return(new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[SalesByCategory]", "SalesByCategoryAndYear")
.AddParameter("@CategoryName", "NVarChar", 15, ParameterDirection.Input, true, 0, 0, categoryName)
.AddParameter("@OrdYear", "NVarChar", 4, ParameterDirection.Input, true, 0, 0, ordYear));
}
/// <summary>Creates an IRetrievalQuery object for a call to the procedure 'GetEmployeeClassifications'.</summary>
/// <param name="employeeClassificationKey">Input parameter of stored procedure</param>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <returns>IRetrievalQuery object which is ready to use for datafetching</returns>
public static IRetrievalQuery GetGetEmployeeClassificationsCallAsQuery(Nullable <System.Int32> employeeClassificationKey, IDataAccessCore dataAccessProvider)
{
return(CreateGetEmployeeClassificationsCall(dataAccessProvider, employeeClassificationKey).ToRetrievalQuery());
}
/// <summary>Creates the call object for the call 'CustomersAndOrdersOnCountry' to stored procedure 'pr_CustomersAndOrdersOnCountry'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="country">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateCustomersAndOrdersOnCountryCall(IDataAccessCore dataAccessProvider, System.String country)
{
return(new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[pr_CustomersAndOrdersOnCountry]", "CustomersAndOrdersOnCountry")
.AddParameter("@country", "VarChar", 50, ParameterDirection.Input, true, 0, 0, country));
}
/// <summary>Creates the call object for the call 'CountEmployeesByClassification' to stored procedure 'CountEmployeesByClassification'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateCountEmployeesByClassificationCall(IDataAccessCore dataAccessProvider)
{
return(new StoredProcedureCall(dataAccessProvider, @"[ORMCookbook].[HR].[CountEmployeesByClassification]", "CountEmployeesByClassification"));
}
/// <summary>Creates the call object for the call 'SalesByYear' to stored procedure 'Sales by Year'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="beginningDate">Input parameter</param>
/// <param name="endingDate">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateSalesByYearCall(IDataAccessCore dataAccessProvider, System.DateTime beginningDate, System.DateTime endingDate)
{
return new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[Sales by Year]", "SalesByYear")
.AddParameter("@Beginning_Date", "DateTime", 0, ParameterDirection.Input, true, 0, 0, beginningDate)
.AddParameter("@Ending_Date", "DateTime", 0, ParameterDirection.Input, true, 0, 0, endingDate);
}
/// <summary>Creates the call object for the call 'GetEmployeeClassifications' to stored procedure 'GetEmployeeClassifications'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="employeeClassificationKey">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateGetEmployeeClassificationsCall(IDataAccessCore dataAccessProvider, Nullable <System.Int32> employeeClassificationKey)
{
return(new StoredProcedureCall(dataAccessProvider, @"[ORMCookbook].[HR].[GetEmployeeClassifications]", "GetEmployeeClassifications")
.AddParameter("@EmployeeClassificationKey", "Int", 0, ParameterDirection.Input, true, 10, 0, employeeClassificationKey));
}
/// <summary>Creates the call object for the call 'CustOrdersDetail' to stored procedure 'CustOrdersDetail'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="orderId">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateCustOrdersDetailCall(IDataAccessCore dataAccessProvider, System.Int32 orderId)
{
return(new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[CustOrdersDetail]", "CustOrdersDetail")
.AddParameter("@OrderID", "Int", 0, ParameterDirection.Input, true, 10, 0, orderId));
}
/// <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 '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>Creates the call object for the call 'CustOrdersDetail' to stored procedure 'CustOrdersDetail'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="orderId">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateCustOrdersDetailCall(IDataAccessCore dataAccessProvider, System.Int32 orderId)
{
return new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[CustOrdersDetail]", "CustOrdersDetail")
.AddParameter("@OrderID", "Int", 0, ParameterDirection.Input, true, 10, 0, orderId);
}
/// <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>Creates the call object for the call 'SalesByCategoryAndYear' to stored procedure 'SalesByCategory'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="categoryName">Input parameter</param>
/// <param name="ordYear">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateSalesByCategoryAndYearCall(IDataAccessCore dataAccessProvider, System.String categoryName, System.String ordYear)
{
return new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[SalesByCategory]", "SalesByCategoryAndYear")
.AddParameter("@CategoryName", "NVarChar", 15, ParameterDirection.Input, true, 0, 0, categoryName)
.AddParameter("@OrdYear", "NVarChar", 4, ParameterDirection.Input, true, 0, 0, ordYear);
}
/// <summary>Creates the call object for the call 'SalesByYear' to stored procedure 'Sales by Year'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <param name="beginningDate">Input parameter</param>
/// <param name="endingDate">Input parameter</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateSalesByYearCall(IDataAccessCore dataAccessProvider, System.DateTime beginningDate, System.DateTime endingDate)
{
return(new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[Sales by Year]", "SalesByYear")
.AddParameter("@Beginning_Date", "DateTime", 0, ParameterDirection.Input, true, 0, 0, beginningDate)
.AddParameter("@Ending_Date", "DateTime", 0, ParameterDirection.Input, true, 0, 0, endingDate));
}
/// <summary>Creates the call object for the call 'TenMostExpensiveProducts' to stored procedure 'Ten Most Expensive Products'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <returns>Ready to use StoredProcedureCall object</returns>
private static StoredProcedureCall CreateTenMostExpensiveProductsCall(IDataAccessCore dataAccessProvider)
{
return new StoredProcedureCall(dataAccessProvider, @"[Northwind].[dbo].[Ten Most Expensive Products]", "TenMostExpensiveProducts");
}
/// <summary>Creates an IRetrievalQuery object for a call to the procedure 'CountEmployeesByClassification'.</summary>
/// <param name="dataAccessProvider">The data access provider.</param>
/// <returns>IRetrievalQuery object which is ready to use for datafetching</returns>
public static IRetrievalQuery GetCountEmployeesByClassificationCallAsQuery(IDataAccessCore dataAccessProvider)
{
return(CreateCountEmployeesByClassificationCall(dataAccessProvider).ToRetrievalQuery());
}
/// <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 '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);
}
}
