//method to get all products from Northwind Database
internal void GetAllProducts()
{
//Get Method
_tblProducts = _adpProducts.GetProducts();
foreach (var row in _tblProducts)
{
Console.WriteLine($"{row.ProductID,10} | {row.ProductName,-40} | {row.CategoryName,-25} | {row.CompanyName,-40} | {row.UnitPrice.ToString("C"),10} | {row.UnitsInStock,10}");
}
}
//constructor
internal CrudOperationsUsingTypedDataSet()
{
_adpProducts = new NorthwindDatasetTableAdapters.ProductsTableAdapter();
_tblProducts = new NorthwindDataset.ProductsDataTable();
_adpCategories = new NorthwindDatasetTableAdapters.CategoriesTableAdapter();
_tblCategories = new NorthwindDataset.CategoriesDataTable();
_adpProd1 = new NorthwindDatasetTableAdapters.Products1TableAdapter();
_tblProd1 = new NorthwindDataset.Products1DataTable();
_adpSuppliers = new NorthwindDatasetTableAdapters.SuppliersTableAdapter();
_tblSuppliers = new NorthwindDataset.SuppliersDataTable();
}
//method to get all products by ID
internal void GetProductByID(int id)
{
_tblProducts = _adpProducts.GetProducts();
var row = _tblProducts.FindByProductID(id);
if (row != null)
{
Console.WriteLine($"{row.ProductID,10} | {row.ProductName,-40} | {row.CategoryName,-25} | {row.CompanyName,-40} | {row.UnitPrice.ToString("C"),10} | {row.UnitsInStock,10}");
}
else
{
Console.WriteLine("Invalid Product ID. Please try again!");
}
}
//method to get all the product by name
internal void GetProductByName(string name)
{
_tblProducts = _adpProducts.GetDataByProductName(name);
if (_tblProducts.Count > 0)
{
foreach (var row in _tblProducts)
{
Console.WriteLine($"{row.ProductID,10} | {row.ProductName,-40} | {row.CategoryName,-25} | {row.CompanyName,-40} | {row.UnitPrice.ToString("C"),10} | {row.UnitsInStock,10}");
}
}
else
{
Console.WriteLine("Invalid Product Name. Please try again!");
}
}
//method to get latest id
internal void GetNewInsertedID()
{
_tblProducts = _adpProducts.GetLatestID();
if (_tblProducts.Count > 0)
{
foreach (var row in _tblProducts)
{
Console.WriteLine($"{row.ProductID,10} | {row.ProductName,-40} | {row.CategoryName,-25} | {row.CompanyName,-40} | {row.UnitPrice.ToString("C"),10} | {row.UnitsInStock,10}");
}
}
else
{
Console.WriteLine("Need to Insert Data Again!");
}
}
