public void FilterExpressionNumber()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(float), "Column1");
columnFilterLogic.SetFilter(5.0);
TestFilterExpression("[Column1] = 5", columnFilterLogic);
}
public void SetFilter()
{
var control = new ColumnFilterLogic(typeof(double), "Column1");
control.SetFilter(2);
Assert.AreEqual("[Column1] = 2", control.BuildSQLCommand(control.ValueText));
}
public void SetFilterTest()
{
using (var crtl = new ColumnFilterLogic(typeof(double), "Column1"))
{
crtl.SetFilter(2);
Assert.AreEqual("[Column1] = 2", crtl.BuildSQLCommand(crtl.ValueText));
}
}
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 Active()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(DateTime), "Column1");
var dtm = DateTime.Now;
columnFilterLogic.SetFilter(dtm);
columnFilterLogic.Active = true;
Assert.IsTrue(columnFilterLogic.Active);
}
public void FilterExpressionBool()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(bool), "Column1");
columnFilterLogic.SetFilter(true);
TestFilterExpression("[COLUMN1] = 1", columnFilterLogic);
columnFilterLogic.SetFilter(false);
TestFilterExpression("[COLUMN1] = 0", columnFilterLogic);
}
public void ApplyFilterTest()
{
using (var crtl = new ColumnFilterLogic(typeof(double), "Column1"))
{
var called = false;
crtl.ColumnFilterApply += delegate { called = true; };
crtl.ApplyFilter();
Assert.IsTrue(called);
}
}
public void SetActiveTest()
{
using (var crtl = new ColumnFilterLogic(typeof(DateTime), "Column1"))
{
var dtm = DateTime.Now;
crtl.SetFilter(dtm);
crtl.Active = true;
Assert.IsTrue(crtl.Active);
}
}
public void FilterExpressionDate()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(DateTime), "Column1");
columnFilterLogic.SetFilter(new DateTime(2020, 02, 20));
var test = columnFilterLogic.FilterExpression.ToUpperInvariant().Replace(" ", "");
Assert.IsTrue(test.Contains("[COLUMN1]>=#02/20/2020#"));
Assert.IsTrue(test.Contains("[COLUMN1]<#02/21/2020#"));
}
public void NotifyPropertyChangedTest()
{
using (var crtl = new ColumnFilterLogic(typeof(double), "Column1"))
{
string prop = null;
crtl.PropertyChanged += delegate(object sender, PropertyChangedEventArgs e) { prop = e.PropertyName; };
crtl.ValueText = "2";
Assert.AreEqual("ValueText", prop);
Assert.AreEqual("[Column1] = 2", crtl.BuildSQLCommand(crtl.ValueText));
}
}
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 ColumnFilterLogicCtor()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(double), "Column1");
Assert.IsNotNull(columnFilterLogic);
Assert.AreEqual(typeof(double), columnFilterLogic.ColumnDataType);
Assert.AreEqual("Column1", columnFilterLogic.DataPropertyName);
var columnFilterLogic2 = new ColumnFilterLogic(typeof(double), "[Column1]");
Assert.AreEqual("Column1", columnFilterLogic2.DataPropertyName);
}
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 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 FilterExpressionText()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(string), "Column1");
columnFilterLogic.SetFilter("Hello");
TestFilterExpression("[COLUMN1]='Hello'", columnFilterLogic);
columnFilterLogic.SetFilter("He\'llo");
TestFilterExpression("[Column1]='He\'\'llo'", columnFilterLogic);
columnFilterLogic.SetFilter(10);
columnFilterLogic.Operator = "longer";
TestFilterExpression("Len([Column1]) > 10", columnFilterLogic);
}
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 BuildSQLCommandTest()
{
using (var crtl = new ColumnFilterLogic(typeof(double), "Column1"))
{
Assert.AreEqual("[Column1] = 2", crtl.BuildSQLCommand("2"));
}
using (var crtl = new ColumnFilterLogic(typeof(double), "[Column1]"))
{
Assert.AreEqual("[Column1] = 2", crtl.BuildSQLCommand("2"));
}
using (var crtl = new ColumnFilterLogic(typeof(string), "Column1"))
{
Assert.AreEqual("[Column1] = '2'", crtl.BuildSQLCommand("2"));
}
}
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);
}
}
public void BuildSQLCommand()
{
{
var columnFilterLogic = new ColumnFilterLogic(typeof(double), "Column1");
Assert.AreEqual("[Column1] = 2", columnFilterLogic.BuildSQLCommand("2"));
}
{
var columnFilterLogic = new ColumnFilterLogic(typeof(double), "[Column1]");
Assert.AreEqual("[Column1] = 2", columnFilterLogic.BuildSQLCommand("2"));
}
{
var columnFilterLogic = new ColumnFilterLogic(typeof(string), "Column1");
Assert.AreEqual("[Column1] = '2'", columnFilterLogic.BuildSQLCommand("2"));
}
}
public void ValueClusterCollection()
{
var columnFilterLogic = new ColumnFilterLogic(typeof(int), "intCol");
using (var data = UnitTestStatic.GetDataTable(200))
{
using (var dataView = new DataView(data, null, null, DataViewRowState.CurrentRows))
{
columnFilterLogic.ValueClusterCollection.BuildValueClusters(dataView, typeof(int), 1);
var i = 0;
foreach (var cluster in columnFilterLogic.ValueClusterCollection.ValueClusters)
{
cluster.Active = true;
if (i++ > 2)
{
break;
}
}
columnFilterLogic.Active = true;
Assert.IsNotNull(columnFilterLogic.FilterExpression);
}
}
}
public void ColumnFilterLogicTest()
{
var crtl = new ColumnFilterLogic(typeof(double), "Column1");
Assert.IsNotNull(crtl);
}
public void IsNullCompareTest() => Assert.IsFalse(ColumnFilterLogic.IsNotNullCompare(ColumnFilterLogic.OperatorIsNull));
private void TestFilterExpression(string expected, ColumnFilterLogic columnFilterLogic) => Assert.AreEqual(
expected.ToUpperInvariant().Replace(" ", ""),
columnFilterLogic.FilterExpression.ToUpperInvariant().Replace(" ", ""),
$"Ignoring case and space, Expected: {expected} Actual: {columnFilterLogic.FilterExpression}");