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