public void MultipleFilters() { //---------------Set up test pack------------------- IFilterClauseFactory filterClauseFactory = new DataViewFilterClauseFactory(); IFilterControl filterControl = GetControlFactory().CreateFilterControl(); ITextBox tb = filterControl.AddStringFilterTextBox("Test:", "TestColumn"); tb.Text = "testvalue"; IFilterClause clause = filterClauseFactory.CreateStringFilterClause("TestColumn", FilterClauseOperator.OpLike, "testvalue"); ITextBox tb2 = filterControl.AddStringFilterTextBox("Test2:", "TestColumn2"); tb2.Text = "testvalue2"; //---------------Execute Test ---------------------- string filterClause = filterControl.GetFilterClause().GetFilterClauseString(); //---------------Test Result ----------------------- IFilterClause clause2 = filterClauseFactory.CreateStringFilterClause("TestColumn2", FilterClauseOperator.OpLike, "testvalue2"); IFilterClause compositeClause = filterClauseFactory.CreateCompositeFilterClause(clause, FilterClauseCompositeOperator.OpAnd, clause2); Assert.AreEqual(compositeClause.GetFilterClauseString(), filterClause); //---------------Tear Down ------------------------- }
public void TestCreateNullFilterClause() { //---------------Set up test pack------------------- IFilterClauseFactory itsFilterClauseFactory = new DataViewFilterClauseFactory(); //---------------Execute Test ---------------------- IFilterClause filterClause = itsFilterClauseFactory.CreateNullFilterClause(); //---------------Test Result ----------------------- Assert.AreEqual("", filterClause.GetFilterClauseString()); }
public void SetupDataView() { DataTable dt = new DataTable(); dt.Columns.Add("h a"); dt.Rows.Add(new object[] {"Peter"}); dt.Rows.Add(new object[] {"Kelly"}); dt.Rows.Add(new object[] {"Yorishma"}); dt.Rows.Add(new object[] {"Doutch"}); dv = dt.DefaultView; filterClauseFactory = new DataViewFilterClauseFactory(); }
public void TestAddStringFilterCheckBox() { //---------------Set up test pack------------------- IFilterClauseFactory filterClauseFactory = new DataViewFilterClauseFactory(); IFilterControl filterControl = GetControlFactory().CreateFilterControl(); //---------------Execute Test ---------------------- filterControl.AddBooleanFilterCheckBox("Test?", "TestColumn", true); //---------------Test Result ----------------------- IFilterClause clause = filterClauseFactory.CreateStringFilterClause("TestColumn", FilterClauseOperator.OpEquals, "true"); Assert.AreEqual(clause.GetFilterClauseString(), filterControl.GetFilterClause().GetFilterClauseString()); //---------------Tear Down ------------------------- }
public void ClearFilters_FIXBUG() { //---------------Set up test pack------------------- GridLayoutManager layoutManager = new GridLayoutManager(GetControlFactory().CreatePanel(), GetControlFactory()); IFilterClauseFactory filterClauseFactory = new DataViewFilterClauseFactory(); FilterControlManager filterControlManager = new FilterControlManager(GetControlFactory(), layoutManager); filterControlManager.AddStringFilterTextBox("Test:", "TestColumn"); filterClauseFactory.CreateStringFilterClause("TestColumn", FilterClauseOperator.OpLike, "testvalue"); filterControlManager.AddStringFilterTextBox("Test2:", "TestColumn2"); filterControlManager.GetFilterClause().GetFilterClauseString(); //---------------Execute Test ---------------------- filterControlManager.ClearFilters(); //---------------Test Result ----------------------- Assert.IsTrue(true, "Should not cause an Erro"); }
public void TestGetComboBoxFilterClause_SelectDeselect() { //---------------Set up test pack------------------- IFilterClauseFactory filterClauseFactory = new DataViewFilterClauseFactory(); IFilterControl filterControl = GetControlFactory().CreateFilterControl(); IComboBox comboBox = GetFilterComboBox_2Items(filterControl); //---------------Execute Test ---------------------- comboBox.SelectedIndex = 1; comboBox.SelectedIndex = -1; string filterClauseString = filterControl.GetFilterClause().GetFilterClauseString(); //---------------Test Result ----------------------- IFilterClause nullClause = filterClauseFactory.CreateNullFilterClause(); Assert.AreEqual(nullClause.GetFilterClauseString(), filterClauseString); //---------------Tear Down ------------------------- }
public void TestGetComboBoxFilterClause() { //---------------Set up test pack------------------- IFilterClauseFactory filterClauseFactory = new DataViewFilterClauseFactory(); IFilterControl filterControl = GetControlFactory().CreateFilterControl(); IComboBox comboBox = GetFilterComboBox_2Items(filterControl); //---------------Execute Test ---------------------- comboBox.SelectedIndex = 1; string filterClauseString = filterControl.GetFilterClause().GetFilterClauseString(); //---------------Test Result ----------------------- IFilterClause clause = filterClauseFactory.CreateStringFilterClause("TestColumn", FilterClauseOperator.OpEquals, "1"); Assert.AreEqual(clause.GetFilterClauseString(), filterClauseString); //---------------Tear Down ------------------------- }
public void TestGetMultiplePropTextBoxFilterClause_Equals() { //---------------Set up test pack------------------- IFilterClauseFactory itsFilterClauseFactory = new DataViewFilterClauseFactory(); IFilterControl filterControl = GetControlFactory().CreateFilterControl(); ITextBox tb = filterControl.AddMultiplePropStringTextBox("Test:", new List<string> { "TestColumn" }, FilterClauseOperator.OpEquals); //---------------Execute Test ---------------------- tb.Text = "testvalue"; string filterClauseString = filterControl.GetFilterClause().GetFilterClauseString(); //---------------Test Result ----------------------- IFilterClause clause = itsFilterClauseFactory.CreateStringFilterClause("TestColumn", FilterClauseOperator.OpEquals, "testvalue"); Assert.AreEqual(clause.GetFilterClauseString(), filterClauseString); //---------------Tear Down ------------------------- }
public void TestAdd_DateRangeFilterComboBoxExclusive() { //---------------Set up test pack------------------- IFilterControl filterControl = GetControlFactory().CreateFilterControl(); IFilterClauseFactory filterClauseFactory = new DataViewFilterClauseFactory(); DateTime testDate = new DateTime(2007, 1, 2, 3, 4, 5, 6); //---------------Execute Test ---------------------- IDateRangeComboBox dr1 = filterControl.AddDateRangeFilterComboBox("test", "test", false, false); dr1.UseFixedNowDate = true; dr1.FixedNowDate = testDate; dr1.SelectedItem = "Today"; IFilterClause clause1 = filterClauseFactory.CreateDateFilterClause("test", FilterClauseOperator.OpGreaterThan, new DateTime(2007, 1, 2, 0, 0, 0)); IFilterClause clause2 = filterClauseFactory.CreateDateFilterClause("test", FilterClauseOperator.OpLessThan, new DateTime(2007, 1, 2, 23, 59, 59, 999)); IFilterClause compClause = filterClauseFactory.CreateCompositeFilterClause(clause1, FilterClauseCompositeOperator.OpAnd, clause2); //---------------Test Result ----------------------- Assert.AreEqual(compClause.GetFilterClauseString(), filterControl.GetFilterClause().GetFilterClauseString()); }
public void TestClearFilter() { //---------------Set up test pack------------------- BusinessObjectCollection<MyBO> col; IGridBase gridBase = GetGridBaseWith_4_Rows(out col); string filterString = col[2].TestProp.Substring(5, 10); IFilterClauseFactory factory = new DataViewFilterClauseFactory(); IFilterClause filterClause = factory.CreateStringFilterClause("TestProp", FilterClauseOperator.OpLike, filterString); gridBase.ApplyFilter(filterClause); //---------------Verify PreConditions -------------- Assert.AreEqual(1, gridBase.Rows.Count); //---------------Execute Test ---------------------- gridBase.ApplyFilter(null); //---------------Test Result ----------------------- Assert.AreEqual(4, gridBase.Rows.Count); //---------------Tear Down ------------------------- }
public void TestApplyFilter_SetBusinessObject_ToAnObjectNoLongerInTheGrid_ReturnsNullSelectedBO() { //---------------Set up test pack------------------- BusinessObjectCollection<MyBO> boColllection; IGridBase gridBase = GetGridBaseWith_4_Rows(out boColllection); MyBO boRemainingInThisGrid = boColllection[2]; string filterString = boRemainingInThisGrid.TestProp.Substring(5, 10); IFilterClauseFactory factory = new DataViewFilterClauseFactory(); IFilterClause filterClause = factory.CreateStringFilterClause("TestProp", FilterClauseOperator.OpLike, filterString); MyBO boNotInGrid = boColllection[1]; //---------------Execute Test ---------------------- gridBase.ApplyFilter(filterClause); gridBase.SelectedBusinessObject = boNotInGrid; //---------------Test Result ----------------------- Assert.AreSame(null, gridBase.SelectedBusinessObject); //---------------Tear Down ------------------------- }
public void TestApplyFilter_SetBusinessObject_SetsTheCorrectBusinessObject() { //---------------Set up test pack------------------- BusinessObjectCollection<MyBO> boCollection; var gridBase = GetGridBaseWith_4_Rows(out boCollection); var filterString = boCollection[2].TestProp.Substring(5, 10); var factory = new DataViewFilterClauseFactory(); var filterClause = factory.CreateStringFilterClause("TestProp", FilterClauseOperator.OpLike, filterString); var bo = boCollection[2]; //---------------Execute Test ---------------------- gridBase.ApplyFilter(filterClause); gridBase.SelectedBusinessObject = bo; //---------------Test Result ----------------------- Assert.AreSame(bo, gridBase.SelectedBusinessObject); }
public void TestAddDateFilterDateTimePicker_Composites() { //---------------Set up test pack------------------- IControlFactory factory = GetControlFactory(); IFilterClauseFactory filterClauseFactory = new DataViewFilterClauseFactory(); IFilterControl filterControl = factory.CreateFilterControl(); DateTime testDate1 = DateTime.Now; DateTime testDate2 = testDate1.AddDays(1); filterControl.AddDateFilterDateTimePicker("test1:", "TestColumn1", testDate1, FilterClauseOperator.OpLessThan, false); filterControl.AddDateFilterDateTimePicker("test2:", "TestColumn2", testDate2, FilterClauseOperator.OpLessThan, false); //---------------Execute Test ---------------------- string expectedFilterClause = filterControl.GetFilterClause().GetFilterClauseString(); //---------------Test Result ----------------------- IFilterClause clause1 = filterClauseFactory.CreateDateFilterClause("TestColumn1", FilterClauseOperator.OpLessThan, new DateTime(testDate1.Year, testDate1.Month, testDate1.Day)); IFilterClause clause2 = filterClauseFactory.CreateDateFilterClause("TestColumn2", FilterClauseOperator.OpLessThan, new DateTime(testDate2.Year, testDate2.Month, testDate2.Day)); IFilterClause compClause = filterClauseFactory.CreateCompositeFilterClause(clause1, FilterClauseCompositeOperator.OpAnd, clause2); Assert.AreEqual(compClause.GetFilterClauseString(), expectedFilterClause); //---------------Tear Down ------------------------- }
public void TestAddDateFilterDateTimePicker_IgnoresTime() { //---------------Set up test pack------------------- IControlFactory factory = GetControlFactory(); IFilterClauseFactory filterClauseFactory = new DataViewFilterClauseFactory(); IFilterControl filterControl = factory.CreateFilterControl(); DateTime testDate = DateTime.Now; filterControl.AddDateFilterDateTimePicker("test:", "TestColumn", testDate, FilterClauseOperator.OpLessThan, false); //---------------Execute Test ---------------------- string expectedFilterClause = filterControl.GetFilterClause().GetFilterClauseString(); //---------------Test Result ----------------------- IFilterClause clause = filterClauseFactory.CreateDateFilterClause("TestColumn", FilterClauseOperator.OpLessThan, new DateTime(testDate.Year, testDate.Month, testDate.Day, 0, 0, 0, 0)); Assert.AreEqual(clause.GetFilterClauseString(), expectedFilterClause); //---------------Tear Down ------------------------- }
public void TestAddDateFilterDateTimePicker_OpLessThanOperator() { //---------------Set up test pack------------------- IControlFactory factory = GetControlFactory(); IFilterClauseFactory filterClauseFactory = new DataViewFilterClauseFactory(); IFilterControl filterControl = factory.CreateFilterControl(); DateTime testDate = DateTime.Today.AddDays(-2); IDateTimePicker dtePicker = filterControl.AddDateFilterDateTimePicker("test:", "TestColumn", testDate, FilterClauseOperator.OpLessThan, false); //---------------Execute Test ---------------------- DateTime newDateTime = DateTime.Today.AddDays(+4); dtePicker.Value = newDateTime; string expectedFilterClause = filterControl.GetFilterClause().GetFilterClauseString(); //---------------Test Result ----------------------- IFilterClause clause = filterClauseFactory.CreateDateFilterClause("TestColumn", FilterClauseOperator.OpLessThan, new DateTime(newDateTime.Year, newDateTime.Month, newDateTime.Day)); Assert.AreEqual(clause.GetFilterClauseString(), expectedFilterClause); //---------------Tear Down ------------------------- }
public virtual void TestWinApplySearch_WithFilterClause_ShouldFireFilterUpdatedEvent() { //---------------Set up test pack------------------- BusinessObjectCollection<MyBO> col; GridBaseWin gridBase = (GridBaseWin)GetGridBaseWith_4_Rows(out col).GetControl(); string filterString = col[2].ID.ToString().Substring(5, 30); IFilterClauseFactory factory = new DataViewFilterClauseFactory(); IFilterClause filterClause = factory.CreateStringFilterClause("TestProp", FilterClauseOperator.OpLike, filterString); bool filterUpdatedFired = false; gridBase.FilterUpdated += delegate { filterUpdatedFired = true; }; //---------------Execute Test ---------------------- gridBase.ApplySearch(filterClause, ""); //---------------Test Result ----------------------- Assert.IsTrue(filterUpdatedFired); }
public void Test_ClearFilters() { //---------------Set up test pack------------------- IFilterClauseFactory filterClauseFactory = new DataViewFilterClauseFactory(); IFilterControl filterControl = GetControlFactory().CreateFilterControl(); ITextBox tb = filterControl.AddStringFilterTextBox("Test:", "TestColumn"); tb.Text = "testvalue"; filterClauseFactory.CreateStringFilterClause("TestColumn", FilterClauseOperator.OpLike, "testvalue"); ITextBox tb2 = filterControl.AddStringFilterTextBox("Test2:", "TestColumn2"); tb2.Text = "testvalue2"; string initialFilterClause = filterControl.GetFilterClause().GetFilterClauseString(); //---------------Assert Precondition---------------- Assert.IsFalse(string.IsNullOrEmpty(initialFilterClause), "Should not be empty : " + initialFilterClause); //---------------Execute Test ---------------------- filterControl.ClearFilters(); //---------------Test Result ----------------------- string finalFilterClause = filterControl.GetFilterClause().GetFilterClauseString(); Assert.IsTrue(string.IsNullOrEmpty(finalFilterClause), "Should be empty : " + finalFilterClause); }
public void TestTwoCheckBoxFilter() { //---------------Set up test pack------------------- IFilterClauseFactory itsFilterClauseFactory = new DataViewFilterClauseFactory(); IFilterControl filterControl = GetControlFactory().CreateFilterControl(); filterControl.AddBooleanFilterCheckBox("Test1?", "TestColumn1", true); filterControl.AddBooleanFilterCheckBox("Test2?", "TestColumn2", false); //---------------Execute Test ---------------------- string filterClauseString = filterControl.GetFilterClause().GetFilterClauseString(); //---------------Test Result ----------------------- IFilterClause clause1 = itsFilterClauseFactory.CreateStringFilterClause("TestColumn1", FilterClauseOperator.OpEquals, "true"); IFilterClause clause2 = itsFilterClauseFactory.CreateStringFilterClause("TestColumn2", FilterClauseOperator.OpEquals, "false"); IFilterClause fullClause = itsFilterClauseFactory.CreateCompositeFilterClause(clause1, FilterClauseCompositeOperator.OpAnd, clause2); Assert.AreEqual(fullClause.GetFilterClauseString(), filterClauseString); //---------------Tear Down ------------------------- }