public void Contains()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(string), "strCol");
columnFilterLogic.SetFilter("Hello");
columnFilterLogic.Operator = ColumnFilterLogic.GetOperators(typeof(string)).First().ToString();
TestFilterExpression("[strCol] like '%Hello%'", columnFilterLogic);
}
public void AllFilterBool()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(bool), "strCol");
columnFilterLogic.SetFilter("true");
foreach (var op in ColumnFilterLogic.GetOperators(columnFilterLogic.ColumnDataType))
{
columnFilterLogic.Operator = op.ToString();
Assert.IsNotNull(columnFilterLogic.FilterExpression);
}
}
public void AllFilterString()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(string), "strCol")
{
ValueText = "Hello"
};
foreach (var op in ColumnFilterLogic.GetOperators(columnFilterLogic.ColumnDataType))
{
columnFilterLogic.Operator = op.ToString();
columnFilterLogic.Active = true;
Assert.IsNotNull(columnFilterLogic.FilterExpression);
}
}
public void GetOperatorsTest()
{
var stringType = ColumnFilterLogic.GetOperators(typeof(string));
Assert.AreEqual(9, stringType.Length);
var dateTimeType = ColumnFilterLogic.GetOperators(typeof(DateTime));
Assert.AreEqual(8, dateTimeType.Length);
var boolType = ColumnFilterLogic.GetOperators(typeof(bool));
Assert.AreEqual(4, boolType.Length);
}
public void AllFilterInt()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(int), "intCol")
{
ValueText = "-10"
};
Assert.AreEqual("-10", columnFilterLogic.ValueText);
foreach (var op in ColumnFilterLogic.GetOperators(columnFilterLogic.ColumnDataType))
{
columnFilterLogic.Operator = op.ToString();
columnFilterLogic.Active = true;
Assert.IsNotNull(columnFilterLogic.FilterExpression);
}
}
public void AllFilterDateTime()
{
var dtm = DateTime.Now;
var columnFilterLogic = new ColumnFilterLogic(typeof(DateTime), "dtmCol")
{
ValueDateTime = dtm
};
Assert.AreEqual(dtm, columnFilterLogic.ValueDateTime);
foreach (var op in ColumnFilterLogic.GetOperators(columnFilterLogic.ColumnDataType))
{
columnFilterLogic.Operator = op.ToString();
columnFilterLogic.Active = true;
Assert.IsNotNull(columnFilterLogic.FilterExpression);
}
}
