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