public static BrandList LoadBrands()
{
DataTable dataTable = DBAccessor.QueryBrands();
if (dataTable == null)
{
return(null);
}
BrandList brandList = new BrandList();
foreach (DataRow dataRow in dataTable.Rows)
{
Brand brand = LoadBrand(dataRow);
brandList.AddBrand(brand);
}
return(brandList);
}
public static ProductTypeList LoadProductTypeList()
{
DataTable dataTable = DBAccessor.QueryProductTypes();
if (dataTable == null)
{
return(null);
}
ProductTypeList productTypeList = new ProductTypeList();
foreach (DataRow dataRow in dataTable.Rows)
{
ProductType productType = LoadProductType(dataRow);
productTypeList.AddType(productType);
}
return(productTypeList);
}
private static ProductList LoadProductList(ProductTypeList productTypeList, BrandList brandList)
{
DataTable dataTable = DBAccessor.QueryProducts();
if (dataTable == null)
{
return(null);
}
ProductList productList = new ProductList();
foreach (DataRow dataRow in dataTable.Rows)
{
Product product = LoadProduct(dataRow, productTypeList, brandList);
if (product == null)
{
continue;
}
productList.AddProduct(product);
}
return(productList);
}
