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;
}
public void ArticleController_Get_ArticleWithTaxonomy_ReturnedArticleHasTaxonomyInfo()
{
TaxonomyCategory category = new TaxonomyCategory() { CategoryId=1, CategoryName="ArticleSection" };
category.AddItem(new TaxonomyCategoryItem() { CategoryItemId = 1, CategoryItemName = "test", ParentItemId = null });
List<TaxonomyCategory> categories = new List<TaxonomyCategory>() {category };
_articleTaxonomyRepository.Stub(r => r.Get(Arg<int>.Is.Anything)).Return(categories);
_articleRepository.Stub(r => r.Get(Arg<int>.Is.Anything)).Return(new Article());
_urlHelper.Stub(h => h.GenerateUrl(Arg<String>.Is.Anything, Arg<Object>.Is.Anything)).Return("http://dummylink.co.uk");
_staticContentLinkService.Stub(s => s.GetStaticContentLinkForSite()).Return(new List<StaticContentLink>());
var articleFeed = _objectUnderTest.Get(1);
var article = (Article)articleFeed.Entries.FirstOrDefault().Content;
Assert.IsNotNull(article.Taxonomy);
}
public void TaxonomyController_GetAllTaxonomyCategories_ReturnsListOfTaxonomyCategoriesAndItems()
{
TaxonomyCategory category = new TaxonomyCategory() { CategoryId = 1, CategoryName = "ArticleSection" };
category.AddItem(new TaxonomyCategoryItem() { CategoryItemId = 1, CategoryItemName = "test", ParentItemId = null });
List<TaxonomyCategory> categories = new List<TaxonomyCategory>() { category };
_taxonomyRepository.Stub(s => s.GetAllTaxonomyCategoriesAndItems()).Return(categories);
var list = _objectUnderTest.GetAllTaxonomyCategories();
Assert.IsNotNull(list);
}