public void AddItem(TaxonomyCategoryItem item)
{
if (CategoryItems == null)
{
CategoryItems = new List<TaxonomyCategoryItem>();
}
CategoryItems.Add(item);
}
public List<TaxonomyCategory> GetOperatorTaxonomy(int companyId)
{
var categories = new List<TaxonomyCategory>();
using (var connection = CreateConnection())
{
using (var command = CreateCommand(connection, "[easds].GetCompanyTaxonomies", new { @CompanyId = companyId }))
{
var sqlReader = command.ExecuteReader();
while (sqlReader.Read())
{
var category = new TaxonomyCategory
{
CategoryId = sqlReader.GetValue<int>("liCategoryID"),
CategoryName = sqlReader.GetValue<string>("sCategoryName")
};
categories.Add(category);
}
sqlReader.NextResult();
while (sqlReader.Read())
{
int categoryId = sqlReader.GetValue<int>("liCategoryID");
var category = categories.Find(i => i.CategoryId == categoryId);
var categoryItem = new TaxonomyCategoryItem()
{
CategoryItemId =sqlReader.GetValue<int>("liCategoryItemID"),
CategoryItemName = sqlReader.GetValue<string>("sItemName"),
ParentItemId = sqlReader.GetValue<int>("liParentID")
};
category.AddItem(categoryItem);
}
}
}
return categories;
}
