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