/// <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); } }