public void FilterColumnConstructorTest()
{
FilterColumn target = new FilterColumn();
target.ColumnName = "TestColumn1";
target.ColumnSelectedDataList = new System.Collections.Generic.List<string>();
target.ColumnSelectedDataList.Add("1");
target.ColumnSelectedDataList.Add("2");
target.ColumnSelectedDataList.Add("3");
target.ColumnSelectedDataList.Add("4");
target.ConditionList = new System.Collections.Generic.List<Condition>();
target.CurrentRowDataValue = 15;
target.Filter = null;
target.FilterType = FilterSelectionType.NUMERIC_EQ;
target.Id = 25;
Assert.AreEqual("TestColumn1", target.ColumnName);
Assert.AreEqual(4, target.ColumnSelectedDataList.Count);
Assert.AreEqual(0, target.ConditionList.Count);
Assert.AreEqual(15, target.CurrentRowDataValue);
Assert.AreEqual(null, target.Filter);
Assert.AreEqual(FilterSelectionType.NUMERIC_EQ, target.FilterType);
Assert.AreEqual(25, target.Id);
Assert.AreEqual(false, target.IsConditionListExist);
target.ConditionList.Add(new Condition("TestColumn1", OperatorType.EQUAL));
Assert.AreEqual(true, target.IsConditionListExist);
target.ConditionList = null;
Assert.AreEqual(false, target.IsConditionListExist);
}
public void InitTest_CUST_AndPreviouslyApplied()
{
NumericFilterVM target = new NumericFilterVM();
string columnName = "TestColumn1";
string columnTitle = "Test Column 1";
NumericFilterSelectionType _filterType = new NumericFilterSelectionType();
_filterType = NumericFilterSelectionType.CUSTOM;
FilterColumn _column = new FilterColumn();
_column.ColumnName = columnName;
_column.FilterType = FilterSelectionType.NUMERIC_CUST;
_column.ColumnSelectedDataList = new System.Collections.Generic.List<string>();
_column.ConditionList = new System.Collections.Generic.List<Condition>();
Condition cond = new Condition();
cond.IncludedConditionList = new System.Collections.ObjectModel.ObservableCollection<Condition>();
cond.LogicalOperatorOfIncludedCondition = LogicOperatorType.AND;
Condition cond1 = new Condition("TestColumn1", OperatorType.GREATER_THAN_OR_EQUAL);
Condition cond2 = new Condition("TestColumn1", OperatorType.LESS_THAN_OR_EQUAL);
cond.IncludedConditionList.Add(cond1);
cond.IncludedConditionList.Add(cond2);
_column.ConditionList.Add(cond);
_column.CurrentRowDataValue = null;
target.Init(columnName, columnTitle, _filterType, _column);
Assert.AreEqual(columnName, target.FieldName);
Assert.AreEqual(columnTitle, target.FieldNameTitle);
Assert.AreEqual(OperatorType.GREATER_THAN_OR_EQUAL, target.FirstCondition.ConditionOperator);
Assert.AreEqual(cond1, target.FirstCondition);
Assert.AreEqual(cond2, target.SecondCondition);
}
public NumericFilterView(string _fieldName, string _fieldTitle, NumericFilterSelectionType _type, FilterColumn _column)
: this()
{
Column = _column;
if (_type == NumericFilterSelectionType.RANGE)
{
this.txtAND.Visibility = System.Windows.Visibility.Visible;
this.Condition2Operator.Visibility = System.Windows.Visibility.Visible;
this.Condition2Value.Visibility = System.Windows.Visibility.Visible;
}
else if (_type == NumericFilterSelectionType.CUSTOM)
{
this.SktPnlLogic.Visibility = System.Windows.Visibility.Visible;
this.Condition2Operator.Visibility = System.Windows.Visibility.Visible;
this.Condition2Value.Visibility = System.Windows.Visibility.Visible;
}
this.VM.Init(_fieldName, _fieldTitle, _type, _column);
}
public void RefreshFilteredDataTest_IfFilterAlreadyDefinedWitNumericFilter()
{
FilterSelectionVM target = new FilterSelectionVM();
string columnName = "TestColumn1";
target.SelectedFilterColumn = new FilterColumn();
ObservableCollection<string> filterStringList = new ObservableCollection<string>();
filterStringList.Add("Data 1");
filterStringList.Add("Data 2");
filterStringList.Add("Data 3");
filterStringList.Add("Data 4");
FilterColumn filterColumn = new FilterColumn();
filterColumn.FilterType = FilterSelectionType.NUMERIC_EQ;
filterColumn.ColumnSelectedDataList = new System.Collections.Generic.List<string>();
target.RefreshFilteredData(columnName, filterStringList, filterColumn);
Assert.AreEqual(6, target.FilterItemList.Count);
Assert.AreEqual("Select all", target.FilterItemList[0].Data);
Assert.AreEqual(false, target.FilterItemList[0].IsSelected);
Assert.AreEqual("Unselect all", target.FilterItemList[1].Data);
Assert.AreEqual(false, target.FilterItemList[1].IsSelected);
Assert.AreEqual("Data 1", target.FilterItemList[2].Data);
Assert.AreEqual(false, target.FilterItemList[2].IsSelected);
Assert.AreEqual("Data 2", target.FilterItemList[3].Data);
Assert.AreEqual(false, target.FilterItemList[3].IsSelected);
Assert.AreEqual("Data 3", target.FilterItemList[4].Data);
Assert.AreEqual(false, target.FilterItemList[4].IsSelected);
Assert.AreEqual("Data 4", target.FilterItemList[5].Data);
Assert.AreEqual(false, target.FilterItemList[5].IsSelected);
}
public void InitTest_EQ()
{
NumericFilterVM target = new NumericFilterVM();
string columnName = "TestColumn1";
string columnTitle = "Test Column 1";
NumericFilterSelectionType _filterType = new NumericFilterSelectionType();
_filterType = NumericFilterSelectionType.EQUAL;
FilterColumn _column = new FilterColumn();
_column.ColumnName = columnName;
_column.ColumnSelectedDataList = new System.Collections.Generic.List<string>();
_column.ConditionList = new System.Collections.Generic.List<Condition>();
_column.CurrentRowDataValue = null;
target.Init(columnName, columnTitle, _filterType, _column);
Assert.AreEqual(columnName, target.FieldName);
Assert.AreEqual(columnTitle, target.FieldNameTitle);
Assert.AreEqual(OperatorType.EQUAL, target.FirstCondition.ConditionOperator);
}
public void InitTest_NE_AndPreviouslyApplied()
{
NumericFilterVM target = new NumericFilterVM();
string columnName = "TestColumn1";
string columnTitle = "Test Column 1";
NumericFilterSelectionType _filterType = new NumericFilterSelectionType();
_filterType = NumericFilterSelectionType.NOT_EQUAL;
FilterColumn _column = new FilterColumn();
_column.ColumnName = columnName;
_column.FilterType = FilterSelectionType.NUMERIC_NE;
_column.ColumnSelectedDataList = new System.Collections.Generic.List<string>();
_column.ConditionList = new System.Collections.Generic.List<Condition>();
Condition cond = new Condition("TestColumn1", OperatorType.NOT_EQUAL);
_column.ConditionList.Add(cond);
_column.CurrentRowDataValue = null;
target.Init(columnName, columnTitle, _filterType, _column);
Assert.AreEqual(columnName, target.FieldName);
Assert.AreEqual(columnTitle, target.FieldNameTitle);
Assert.AreEqual(OperatorType.NOT_EQUAL, target.FirstCondition.ConditionOperator);
Assert.AreEqual(cond, target.FirstCondition);
}
public void RefreshFilteredData(string columnName, ObservableCollection<string> filterStringList, FilterColumn filterColumn)
{
FilterItemList = new ObservableCollection<FilterItem>();
FilterItemList.Add(new FilterItem() { Data = EZXWPFLibrary.Properties.Resources.FILTER_SELECTALL, IsSelected = true });
FilterItemList.Add(new FilterItem() { Data = EZXWPFLibrary.Properties.Resources.FILTER_UNSELECTALL, IsSelected = false });
if (filterColumn == null || filterColumn.FilterType == FilterSelectionType.NA)
{
if (filterColumn == null)
{
foreach (string item in filterStringList.ToList())
{
FilterItemList.Add(new FilterItem() { Data = item, IsSelected = true });
}
}
else
{
foreach (string item in filterStringList.ToList())
{
if (filterColumn.ColumnSelectedDataList.Any(x => x == item))
{
FilterItemList.Add(new FilterItem() { Data = item, IsSelected = true });
}
else
{
FilterItemList.Add(new FilterItem() { Data = item, IsSelected = false });
FilterItemList[0].IsSelected = false;
}
}
}
if (this.SelectedFilterColumn != null)
{
this.SelectedFilterColumn.ConditionList = new List<Condition>();
this.SelectedFilterColumn.FilterType = FilterSelectionType.NA;
}
}
else
{
FilterItemList[0].IsSelected = false;
FilterItemList[1].IsSelected = false;
foreach (string item in filterStringList.ToList())
{
FilterItemList.Add(new FilterItem() { Data = item, IsSelected = false });
}
}
this.RaisePropertyChanged(p => p.SelectedFilterColumn);
}
public void Init(string columnName, string columnTitle, NumericFilterSelectionType _filterType, FilterColumn _column)
{
this.NumericFilterType = _filterType;
this.FieldName = columnName;
this.FieldNameTitle = columnTitle;
bool previouslyExist = false;
if (_filterType == NumericFilterSelectionType.RANGE)
{
if (_column.FilterType == FilterSelectionType.NUMERIC_RNG)
{
previouslyExist = true;
}
FirstCondition = new Condition(columnName, OperatorType.GREATER_THAN_OR_EQUAL);
SecondCondition = new Condition(columnName, OperatorType.LESS_THAN_OR_EQUAL);
}
else if (_filterType == NumericFilterSelectionType.EQUAL)
{
if (_column.FilterType == FilterSelectionType.NUMERIC_EQ)
{
previouslyExist = true;
}
FirstCondition = new Condition(columnName, OperatorType.EQUAL);
}
else if (_filterType == NumericFilterSelectionType.NOT_EQUAL)
{
if (_column.FilterType == FilterSelectionType.NUMERIC_NE)
{
previouslyExist = true;
}
FirstCondition = new Condition(columnName, OperatorType.NOT_EQUAL);
}
else if (_filterType == NumericFilterSelectionType.GREATER_THAN)
{
if (_column.FilterType == FilterSelectionType.NUMERIC_GT)
{
previouslyExist = true;
}
FirstCondition = new Condition(columnName, OperatorType.GREATER_THAN);
}
else if (_filterType == NumericFilterSelectionType.GREATER_THAN_OR_EQUALTO)
{
if (_column.FilterType == FilterSelectionType.NUMERIC_GE)
{
previouslyExist = true;
}
FirstCondition = new Condition(columnName, OperatorType.GREATER_THAN_OR_EQUAL);
}
else if (_filterType == NumericFilterSelectionType.LESS_THAN)
{
if (_column.FilterType == FilterSelectionType.NUMERIC_LT)
{
previouslyExist = true;
}
FirstCondition = new Condition(columnName, OperatorType.LESS_THAN);
}
else if (_filterType == NumericFilterSelectionType.LESS_THAN_OR_EQUALTO)
{
if (_column.FilterType == FilterSelectionType.NUMERIC_LE)
{
previouslyExist = true;
}
FirstCondition = new Condition(columnName, OperatorType.LESS_THAN_OR_EQUAL);
}
else if (_filterType == NumericFilterSelectionType.CUSTOM)
{
if (_column.FilterType == FilterSelectionType.NUMERIC_CUST)
{
previouslyExist = true;
}
FirstCondition = new Condition(columnName, OperatorType.GREATER_THAN_OR_EQUAL);
SecondCondition = new Condition(columnName, OperatorType.GREATER_THAN_OR_EQUAL);
}
if (previouslyExist && _column.ConditionList != null && _column.ConditionList.Count > 0)
{
if (_filterType == NumericFilterSelectionType.RANGE || _filterType == NumericFilterSelectionType.CUSTOM)
{
if (_column.ConditionList[0].IsLogicalOperatorOfIncludedConditionSpecified == true &&
_column.ConditionList[0].IncludedConditionList != null
&& _column.ConditionList[0].IncludedConditionList.Count > 1)
FirstCondition = _column.ConditionList[0].IncludedConditionList[0];
SecondCondition = _column.ConditionList[0].IncludedConditionList[1];
}
else
{
FirstCondition = _column.ConditionList[0];
}
}
if (FirstCondition != null)
{
FirstCondition.FieldToMatchValueType = ValueDataType.NUMERIC;
}
if (SecondCondition != null)
{
SecondCondition.FieldToMatchValueType = ValueDataType.NUMERIC;
}
}
private void ShowNumericView(NumericFilterSelectionType _type)
{
FilterColumn column = this.autofilterDataGrid.GetFilterColumnByName(this.selectedColumn);
if (column == null)
{
column = new FilterColumn();
column.ColumnName = this.selectedColumn;
}
NumericFilterView view = new NumericFilterView(this.selectedColumn, columnTitle, _type, column);
bool? status = view.ShowDialog();
if (status != null && status == true)
{
this.autofilterDataGrid.FilterDataGrid(column);
this.Close();
}
}
