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 -------------------------
}
