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 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 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 NumericFilterVMConstructorTest()
{
string columnName = "TestColumn1";
NumericFilterSelectionType _filterType = new NumericFilterSelectionType();
_filterType = NumericFilterSelectionType.EQUAL;
NumericFilterVM target = new NumericFilterVM(columnName, _filterType);
Assert.AreNotEqual(columnName, target.FieldName);
Assert.AreNotEqual(_filterType, target.NumericFilterType);
Assert.IsTrue(string.IsNullOrEmpty(target.FieldName));
Assert.AreEqual(NumericFilterSelectionType.CUSTOM, target.NumericFilterType);
}
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 NumericFilterVM(string columnName, NumericFilterSelectionType _filterType)
: base()
{
}
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();
}
}
