using System; using System.Data; using System.Data.SqlClient; using 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 ProductsDataLayerBase() { } /// <summary> /// Selects a record by primary key(s) /// </summary> public static Products SelectByPrimaryKey(int productID) { // add your code here throw new NotImplementedException(); } /// <summary> /// Selects all Products /// </summary> public static ProductsCollection SelectAll() { // add your code here throw new NotImplementedException(); } /// <summary> /// Selects all Products by Suppliers, related to column SupplierID /// </summary> public static ProductsCollection SelectProductsCollectionBySuppliers(int supplierID) { // add your code here throw new NotImplementedException(); } /// <summary> /// Selects all Products by Categories, related to column CategoryID /// </summary> public static ProductsCollection SelectProductsCollectionByCategories(int categoryID) { // add your code here throw new NotImplementedException(); } /// <summary> /// Selects ProductID and ProductName columns for use with a DropDownList web control /// </summary> public static ProductsCollection SelectProductsDropDownListData() { // add your code here throw new NotImplementedException(); } public static ProductsCollection SelectShared(string storedProcName, string param, object paramValue) { // add your code here throw new NotImplementedException(); } /// <summary> /// Inserts a record /// </summary> public static int Insert(Products objProducts) { // add your code here throw new NotImplementedException(); } /// <summary> /// Updates a record /// </summary> public static void Update(Products objProducts) { // add your code here throw new NotImplementedException(); } private static int InsertUpdate(Products objProducts, bool isUpdate) { // add your code here throw new NotImplementedException(); } /// <summary> /// Deletes a record based on primary key(s) /// </summary> public static void Delete(int productID) { // add your code here throw new NotImplementedException(); } public static int GetRecordCount() { // add your code here throw new NotImplementedException(); } public static int GetRecordCountBySupplierID(int supplierID) { // add your code here throw new NotImplementedException(); } public static int GetRecordCountByCategoryID(int categoryID) { // add your code here throw new NotImplementedException(); } public static int GetRecordCountDynamicWhere(int? productID, string productName, int? supplierID, int? categoryID, string quantityPerUnit, decimal? unitPrice, short? unitsInStock, short? unitsOnOrder, short? reorderLevel, bool? discontinued) { // add your code here throw new NotImplementedException(); } public static ProductsCollection SelectSkipAndTake(string sortByExpression, int startRowIndex, int end) { // add your code here throw new NotImplementedException(); } public static ProductsCollection SelectSkipAndTakeBySupplierID(string sortByExpression, int startRowIndex, int end, int supplierID) { // add your code here throw new NotImplementedException(); } public static ProductsCollection SelectSkipAndTakeByCategoryID(string sortByExpression, int startRowIndex, int end, int categoryID) { // add your code here throw new NotImplementedException(); } public static ProductsCollection SelectSkipAndTakeDynamicWhere(int? productID, string productName, int? supplierID, int? categoryID, string quantityPerUnit, decimal? unitPrice, short? unitsInStock, short? unitsOnOrder, short? reorderLevel, bool? discontinued, string sortByExpression, int startRowIndex, int maximumRows) { // add your code here throw new NotImplementedException(); } public static Products SelectTotals() { // add your code here throw new NotImplementedException(); } public static ProductsCollection SelectProductsCollectionBySupplierID(int supplierID) { // add your code here throw new NotImplementedException(); } public static ProductsCollection SelectProductsCollectionByCategoryID(int categoryID) { // add your code here throw new NotImplementedException(); } } }