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}");