public ICollection <Category> GetCategories()
{
DataSet ds = StoreDbDataSet.ReadDataSet();
ObservableCollection <Category> categories = new ObservableCollection <Category>();
foreach (DataRow dr in ds.Tables["Categories"].Rows)
{
categories.Add(new Category((string)dr["CategoryName"], (int)dr["CategoryID"]));
}
return(categories);
}
public Product GetProduct(int ID)
{
DataSet ds = StoreDbDataSet.ReadDataSet();
DataRow productRow = ds.Tables["Products"].Select("ProductID = " + ID.ToString())[0];
Product product = new Product((string)productRow["ModelNumber"],
(string)productRow["ModelName"], (decimal)productRow["UnitCost"],
(string)productRow["Description"], (int)productRow["CategoryID"],
(string)productRow["CategoryName"], (string)productRow["ProductImage"]);
return(product);
}
public ICollection <Product> GetProducts()
{
DataSet ds = StoreDbDataSet.ReadDataSet();
ObservableCollection <Product> products = new ObservableCollection <Product>();
foreach (DataRow productRow in ds.Tables["Products"].Rows)
{
products.Add(new Product(modelName: (string)productRow["ModelName"],
year: (string)productRow["Year"], engineCapacity:
(string)productRow["EngineCapacity"], description: (string)productRow["Description"]));
}
return(products);
}
public ICollection <Product> GetProducts()
{
DataSet ds = StoreDbDataSet.ReadDataSet();
ObservableCollection <Product> products = new ObservableCollection <Product>();
foreach (DataRow productRow in ds.Tables["Products"].Rows)
{
products.Add(new Product((string)productRow["ModelNumber"],
(string)productRow["ModelName"], (decimal)productRow["UnitCost"],
(string)productRow["Description"], (int)productRow["CategoryID"],
(string)productRow["CategoryName"], (string)productRow["ProductImage"]));
}
return(products);
}
public ICollection <Category> GetCategoriesAndProducts()
{
DataSet ds = StoreDbDataSet.ReadDataSet();
DataRelation relCategoryProduct = ds.Relations[0];
ObservableCollection <Category> categories = new ObservableCollection <Category>();
foreach (DataRow categoryRow in ds.Tables["Categories"].Rows)
{
ObservableCollection <Product> products = new ObservableCollection <Product>();
foreach (DataRow productRow in categoryRow.GetChildRows(relCategoryProduct))
{
products.Add(new Product(productRow["ModelNumber"].ToString(),
productRow["ModelName"].ToString(), (decimal)productRow["UnitCost"],
productRow["Description"].ToString()));
}
categories.Add(new Category(categoryRow["CategoryName"].ToString(), products));
}
return(categories);
}