public void GetWhereCondition_EmptyViewMode_EmptyWhereCondition()
{
var filter = new CoffeeFilterViewModel();
filter.Load();
var where = filter.GetWhereCondition();
CMSAssert.All(
() => Assert.IsNotNull(where),
() => Assert.IsEmpty(where.ToString(true))
);
}
public void GetWhereCondition_SetUpDecaf_RestrictionInWhereCondition()
{
var filter = new CoffeeFilterViewModel
{
OnlyDecaf = true
};
filter.Load();
var where = filter.GetWhereCondition();
CMSAssert.All(
() => Assert.IsNotNull(where),
() => Assert.AreEqual("[CoffeeIsDecaf] = 1", where.ToString(true))
);
}
public void GetWhereCondition_SetUpCoffeeProcessingType_RestrictionInWhereCondition()
{
var filter = new CoffeeFilterViewModel();
filter.Load();
filter.ProcessingTypes[0].IsChecked = true;
filter.ProcessingTypes[1].IsChecked = false;
filter.ProcessingTypes[2].IsChecked = true;
var where = filter.GetWhereCondition();
CMSAssert.All(
() => Assert.IsNotNull(where),
() => Assert.AreEqual("[CoffeeProcessing] IN (N'Washed', N'Natural')", where.ToString(true))
);
}