public DataAccessLayer() { adpCategories = new NorthwindDataSetTableAdapters.CategoriesTableAdapter(); tblCategories = new NorthwindDataSet.CategoriesDataTable(); adpSuppliers = new NorthwindDataSetTableAdapters.SuppliersTableAdapter(); tblSuppliers = new NorthwindDataSet.SuppliersDataTable(); adpProducts = new NorthwindDataSetTableAdapters.ProductsTableAdapter(); tblProducts = new NorthwindDataSet.ProductsDataTable(); }
// method to get all the products public void GetAllProducts() { // using Fill() method //_adpProducts.FillProducts(_tblProducts); // using Get() method _tblProducts = _adpProducts.GetProducts(); //Console.WriteLine("\n\n+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+\n"); foreach (var row in _tblProducts) { Console.WriteLine($"{row.ProductID,5} {row.ProductName,-40} {row.UnitPrice,10} {row.UnitsInStock,10}"); } }
// method to get a product by ID public void GetProductById(int id) { _tblProducts = _adpProducts.GetProducts(); var row = _tblProducts.FindByProductID(id); if (row != null) { Console.WriteLine($"{row.ProductID,5} {row.ProductName,-40} {row.UnitPrice,10} {row.UnitsInStock,10}"); } else { Console.WriteLine("Invalid Product ID. Please try again."); } }
// method to get a product by name public void GetProductByName(string name) { _tblProducts = _adpProducts.GetProductByName(name); if (_tblProducts.Count > 0) { var row = _tblProducts[0]; // read the fetched row Console.WriteLine("\n\n+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+\n"); Console.WriteLine($"{row.ProductID,5} {row.ProductName,-40} {row.UnitPrice,10} {row.UnitsInStock,10}"); } else { Console.WriteLine("Invalid Product Name. Please try again."); } }
public List <BusinessLogicLayer> GetProductsBySupplier(int id) { tblProducts = adpProducts.GetProductsBySupplierID(id); if (tblProducts.Count > 0) { listProductsBySupplier = new List <BusinessLogicLayer>(); foreach (var row in tblProducts) { BusinessLogicLayer supplierProduct = new BusinessLogicLayer(); supplierProduct.Id = row.ProductID; supplierProduct.Name = row.ProductName; supplierProduct.Price = row.UnitPrice; supplierProduct.Stock = row.UnitsInStock; listProductsBySupplier.Add(supplierProduct); } } return(listProductsBySupplier); }
public List <BusinessLogicLayer> GetProductsByCategory(int id) { tblProducts = adpProducts.GetProductsByCategoryID(id); if (tblProducts.Count > 0) { listProductsByCategory = new List <BusinessLogicLayer>(); foreach (var row in tblProducts) { BusinessLogicLayer categoryProduct = new BusinessLogicLayer(); categoryProduct.Id = row.ProductID; categoryProduct.Name = row.ProductName; categoryProduct.Price = row.UnitPrice; categoryProduct.Stock = row.UnitsInStock; listProductsByCategory.Add(categoryProduct); } } return(listProductsByCategory); }
NorthwindDataSet.ProductsRow GetCurrentRowInDB(NorthwindDataSet.ProductsRow RowWithError) { TempProductsDataTable = new NorthwindDataSet.ProductsDataTable(); this.productsTableAdapter1.Fill(TempProductsDataTable); NorthwindDataSet.ProductsRow currentRowInDb = TempProductsDataTable.FindByProductID(RowWithError.ProductID); return currentRowInDb; }
// constructor public CrudOperationsInTypedDataSet() { _adpProducts = new NorthwindDataSetTableAdapters.ProductsTableAdapter(); _tblProducts = new NorthwindDataSet.ProductsDataTable(); }
public virtual NorthwindDataSet.ProductsDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; NorthwindDataSet.ProductsDataTable dataTable = new NorthwindDataSet.ProductsDataTable(); this.Adapter.Fill(dataTable); return dataTable; }