private MSCommerceCatalogCollection2CatalogCategory[] GenerateCategories()
{
List <MSCommerceCatalogCollection2CatalogCategory> categories = new List <MSCommerceCatalogCollection2CatalogCategory>();
var prefixesToExclude = Configuration.CategoryPrefixesToExclude.Split(',')
.ToList();
var dataTable = stagingRepository.ReadParentCategories();
var childTable = stagingRepository.ReadSubCategories();
foreach (DataRow cat in dataTable.Rows)
{
var newSubCat = new MSCommerceCatalogCollection2CatalogCategory()
{
name = cat.GetString("CategoryId"), Definition = "Category"
};
newSubCat.DisplayName = CreateDisplayName(cat.GetString("CategoryName"));
categories.Add(newSubCat);
}
foreach (DataRow subCat in childTable.Rows)
{
if (prefixesToExclude.Contains(subCat.GetString("CategoryId")
.Substring(0, 2)))
{
continue;
}
var newSubCat = new MSCommerceCatalogCollection2CatalogCategory()
{
name = subCat.GetString("CategoryId"), Definition = "Category"
};
newSubCat.DisplayName = CreateDisplayName(subCat.GetString("CategoryName"));
newSubCat.ParentCategory = new ParentCategory[1] {
new ParentCategory()
{
Value = string.Format("{0}000", subCat.GetString("CategoryId", true)
.Substring(0, 2))
}
};
categories.Add(newSubCat);
}
return(categories.ToArray());
}
private MSCommerceCatalogCollection2CatalogCategory[] GenerateUNFIEastCategories()
{
List <MSCommerceCatalogCollection2CatalogCategory> categories = new List <MSCommerceCatalogCollection2CatalogCategory>();
var prefixesToExclude = Configuration.CategoryPrefixesToExclude.Split(',')
.ToList();
var dataTable = stagingRepository.ReadUNFIEastItems();
DataView dataView = new DataView(dataTable);
var parentCategories = dataView.ToTable(true, "Category");
var childCategories = dataView.ToTable(true, "Category", "Subgroup");
foreach (DataRow cat in parentCategories.Rows)
{
var newSubCat = new MSCommerceCatalogCollection2CatalogCategory()
{
name = cat.GetString("Category"), Definition = "Category"
};
newSubCat.DisplayName = CreateDisplayName(cat.GetString("Category"));
categories.Add(newSubCat);
}
foreach (DataRow subCat in childCategories.Rows)
{
var newSubCat = new MSCommerceCatalogCollection2CatalogCategory()
{
name = subCat.GetString("Subgroup"), Definition = "Category"
};
newSubCat.DisplayName = CreateDisplayName(subCat.GetString("Subgroup"));
newSubCat.ParentCategory = new ParentCategory[1] {
new ParentCategory()
{
Value = subCat.GetString("Category")
}
};
categories.Add(newSubCat);
}
return(categories.ToArray());
}