public void AssertFacetSortOrdersEqual(PivotFacetSortOrder expected, PivotFacetSortOrder actual)
{
if (expected == null && actual == null)
{
return;
}
AssertEqual(expected.Name, actual.Name);
AssertEqual(String.Join(",", expected.Values.ToArray()), String.Join(",", actual.Values.ToArray()));
}
public void TestSetSortOrderMultipleValues()
{
PivotFacetSortOrder sortOrder = new PivotFacetSortOrder("alpha");
sortOrder.AddValue("zulu");
sortOrder.AddValue("yankee");
sortOrder.AddValue("whiskey");
subjectFacet.SortOrder = sortOrder;
AssertEqual("zulu", subjectFacet.SortOrder.Values.ToArray()[0]);
AssertEqual("yankee", subjectFacet.SortOrder.Values.ToArray()[1]);
AssertEqual("whiskey", subjectFacet.SortOrder.Values.ToArray()[2]);
AssertEqual(3, subjectFacet.SortOrder.Values.Count());
}
public void TestSetSortOrderDuplicateValues()
{
try
{
PivotFacetSortOrder sortOrder = new PivotFacetSortOrder("alpha");
sortOrder.AddValue("zulu");
sortOrder.AddValue("yankee");
sortOrder.AddValue("whiskey");
sortOrder.AddValue("alpha");
sortOrder.AddValue("whiskey");
Fail("Expected an exception");
}
catch (ArgumentException e)
{
AssertEqual("Cannot have duplicate sort order values: whiskey", e.Message);
}
}
private void LoadFacetCategoriesData(OleDbConnection connection)
{
String facetCategoriesDataQuery = this.FacetCategoriesDataQuery;
if (facetCategoriesDataQuery == null)
{
return;
}
OleDbCommand command = new OleDbCommand(facetCategoriesDataQuery, connection);
OleDbDataReader dataReader = command.ExecuteReader();
while (dataReader.Read())
{
PivotFacetCategory facetCategory = this.CreateFacetCategory(dataReader);
for (int column = 0; column < dataReader.FieldCount; column++)
{
if (dataReader.IsDBNull(column))
{
continue;
}
String columnName = dataReader.GetName(column).ToLowerInvariant();
String value = dataReader.GetValue(column).ToString();
if (columnName == OleDbSchemaConstants.FacetCategory.Format)
{
facetCategory.Format = value;
}
else if (columnName == OleDbSchemaConstants.FacetCategory.IsFilterVisible)
{
facetCategory.IsFilterVisible = Boolean.Parse(value.ToLowerInvariant());
}
else if (columnName == OleDbSchemaConstants.FacetCategory.IsMetadataVisible)
{
facetCategory.IsMetaDataVisible = Boolean.Parse(value.ToLowerInvariant());
}
else if (columnName == OleDbSchemaConstants.FacetCategory.IsWordWheelVisible)
{
facetCategory.IsWordWheelVisible = Boolean.Parse(value.ToLowerInvariant());
}
else if (columnName == OleDbSchemaConstants.FacetCategory.SortName)
{
PivotFacetSortOrder sortOrder = new PivotFacetSortOrder(value);
if (facetCategory.SortOrder != null)
{
sortOrder.AddAllValues(facetCategory.SortOrder.Values);
}
facetCategory.SortOrder = sortOrder;
}
else if (columnName == OleDbSchemaConstants.FacetCategory.SortValues)
{
if (facetCategory.SortOrder == null)
{
facetCategory.SortOrder = new PivotFacetSortOrder(facetCategory.Name);
}
facetCategory.SortOrder.AddAllValues(this.SplitJoinedStrings(value));
}
}
this.CachedCollectionData.FacetCategories.Add(facetCategory);
m_facetCategoryMap.Add(facetCategory.Name.ToLowerInvariant(), facetCategory);
}
}
