Imports System Imports System.Data Imports System.Data.SqlClient Imports Northwind45.BusinessObject Namespace Northwind45.DataLayer.Base ''' <summary> ''' Base class for ProductsDataLayer. Do not make changes to this class, ''' instead, put additional code in the ProductsDataLayer class ''' </summary> Public Class ProductsDataLayerBase ' constructor Public Sub New() End Sub ''' <summary> ''' Selects a record by primary key(s) ''' </summary> Public Shared Function SelectByPrimaryKey(ByVal productID As Integer) As Products ' add your code here Throw New NotImplementedException() End Function ''' <summary> ''' Selects all Products ''' </summary> Public Shared Function SelectAll() As ProductsCollection ' add your code here Throw New NotImplementedException() End Function ''' <summary> ''' Selects all Products by Suppliers, related to column SupplierID ''' </summary> Public Shared Function SelectProductsCollectionBySuppliers(supplierID As Integer) As ProductsCollection ' add your code here Throw New NotImplementedException() End Function ''' <summary> ''' Selects all Products by Categories, related to column CategoryID ''' </summary> Public Shared Function SelectProductsCollectionByCategories(categoryID As Integer) As ProductsCollection ' add your code here Throw New NotImplementedException() End Function ''' <summary> ''' Selects ProductID and ProductName columns for use with a DropDownList web control ''' </summary> Public Shared Function SelectProductsDropDownListData() As ProductsCollection ' add your code here Throw New NotImplementedException() End Function Public Shared Function SelectShared(storedProcName As String, param As String, paramValue As Object) As ProductsCollection ' add your code here Throw New NotImplementedException() End Function ''' <summary> ''' Inserts a record ''' </summary> Public Shared Function Insert(objProducts As Products) As Integer ' add your code here Throw New NotImplementedException() End Function ''' <summary> ''' Updates a record ''' </summary> Public Shared Sub Update(objProducts As Products) ' add your code here Throw New NotImplementedException() End Sub Private Shared Function InsertUpdate(ByVal objProducts As Products, isUpdate As Boolean, storedProcName As String) As Integer ' add your code here Throw New NotImplementedException() End Function ''' <summary> ''' Deletes a record based on primary key(s) ''' </summary> Public Shared Sub Delete(ByVal productID As Integer) ' add your code here Throw New NotImplementedException() End Sub Public Shared Function GetRecordCount() As Integer ' add your code here Throw New NotImplementedException End Function Public Shared Function GetRecordCountBySupplierID(supplierID As Integer) As Integer ' add your code here Throw New NotImplementedException End Function Public Shared Function GetRecordCountByCategoryID(categoryID As Integer) As Integer ' add your code here Throw New NotImplementedException End Function Public Shared Function GetRecordCountDynamicWhere(productID As Integer?, productName As String, supplierID As Integer?, categoryID As Integer?, quantityPerUnit As String, unitPrice As Decimal?, unitsInStock As Short?, unitsOnOrder As Short?, reorderLevel As Short?, discontinued As Boolean?) As Integer ' add your code here Throw New NotImplementedException End Function Public Shared Function SelectSkipAndTake(sortByExpression As String, startRowIndex As Integer, ending As Integer) As ProductsCollection ' add your code here Throw New NotImplementedException End Function Public Shared Function SelectSkipAndTakeBySupplierID(sortByExpression As String, startRowIndex As Integer, ending As Integer, supplierID As Integer) As ProductsCollection ' add your code here Throw New NotImplementedException End Function Public Shared Function SelectSkipAndTakeByCategoryID(sortByExpression As String, startRowIndex As Integer, ending As Integer, categoryID As Integer) As ProductsCollection ' add your code here Throw New NotImplementedException End Function Public Shared Function SelectSkipAndTakeDynamicWhere(productID As Integer?, productName As String, supplierID As Integer?, categoryID As Integer?, quantityPerUnit As String, unitPrice As Decimal?, unitsInStock As Short?, unitsOnOrder As Short?, reorderLevel As Short?, discontinued As Boolean?, sortByExpression As String, startRowIndex As Integer, maximumRows As Integer) As ProductsCollection ' add your code here Throw New NotImplementedException End Function Public Shared Function SelectTotals() As Products ' add your code here Throw New NotImplementedException End Function End Class End Namespace