private void BuildNumericFilter(TextboxQueueViewModel ctrlTextFilter, decimal? max, decimal? min, bool? isAndOr, bool isMaxEqual, bool isMinEqual)
{
if (min != null)
{
// If Filter is Arrears Days or Client Arrears Days is formatted as Integer
if (ctrlTextFilter.Title == "# Arrears Days" || ctrlTextFilter.Title == "# Client Arrears Days")
{
ctrlTextFilter.Value1 = ((int)min).ToString("D");
}
else
{
ctrlTextFilter.Value1 = ((decimal)min).ToString("C2");
}
ctrlTextFilter.LocalSelectedOperators1 = ctrlTextFilter.AllOperators.FirstOrDefault(p => p.Value == CollectionQueueCondition.IsGreaterthan);
if (isMinEqual)
{
ctrlTextFilter.LocalSelectedOperators1 = ctrlTextFilter.AllOperators.FirstOrDefault(p => p.Value == CollectionQueueCondition.IsGreaterthanOrEqualTo);
}
}
if (isAndOr != null)
{
if (isAndOr == true)
{
ctrlTextFilter.LocalSelectedCondition = CollectionQueueOperators.And.ToString();
}
else
{
ctrlTextFilter.LocalSelectedCondition = CollectionQueueOperators.Or.ToString();
}
}
if (max != null)
{
if (min == null)
{
// If Filter is Arrears Days or Client Arrears Days is formatted as Integer
if (ctrlTextFilter.Title == "# Arrears Days" || ctrlTextFilter.Title == "# Client Arrears Days")
{
ctrlTextFilter.Value1 = ((int)max).ToString("D");
}
else
{
ctrlTextFilter.Value1 = ((decimal)max).ToString("C2");
}
ctrlTextFilter.LocalSelectedOperators1 = ctrlTextFilter.AllOperators.FirstOrDefault(p => p.Value == CollectionQueueCondition.IsLessthan);
if (isMaxEqual)
{
ctrlTextFilter.LocalSelectedOperators1 = ctrlTextFilter.AllOperators.FirstOrDefault(p => p.Value == CollectionQueueCondition.IsLessthanOrEqualTo);
}
}
else
{
// If Filter is Arrears Days or Client Arrears Days is formatted as Integer
if (ctrlTextFilter.Title == "# Arrears Days" || ctrlTextFilter.Title == "# Client Arrears Days")
{
ctrlTextFilter.Value2 = ((int)max).ToString("D");
}
else
{
ctrlTextFilter.Value2 = ((decimal)max).ToString("C2");
}
ctrlTextFilter.LocalSelectedOperators2 = ctrlTextFilter.AllOperators.FirstOrDefault(p => p.Value == CollectionQueueCondition.IsLessthan);
if (isMaxEqual)
{
ctrlTextFilter.LocalSelectedOperators2 = ctrlTextFilter.AllOperators.FirstOrDefault(p => p.Value == CollectionQueueCondition.IsLessthanOrEqualTo);
}
}
}
}
public CollectionsManagementViewModel()
{
this.Edit = new EditQueueViewModel(this);
this.InstanceGUID = new Guid();
this.IsQueueSelected = false;
//this.CheckIsContentEditing = this.CheckContentEditing;
this.PropertyChanged += this.ViewCollectionsManagementViewModel_PropertyChanged;
ListAssignee = new CheckboxQueueViewModel();
ListCompany = new CheckboxQueueViewModel();
ListWorkgroup = new CheckboxQueueViewModel();
ListFinancier = new CheckboxQueueViewModel();
ListState = new CheckboxQueueViewModel();
ClientName = new TextboxQueueViewModel("Client Name");
Introducer = new TextboxQueueViewModel("Introducer");
ArrearsAmount = new TextboxQueueViewModel("Arrears $");
ArrearsDays = new TextboxQueueViewModel("# Arrears Days");
InvestBalance = new TextboxQueueViewModel("Investment Balance");
ClientArrearAmount = new TextboxQueueViewModel("Client Arrears $");
ClientArrearDays = new TextboxQueueViewModel("# Client Arrears Days");
ClientInvestBalance = new TextboxQueueViewModel("Client Investment Balance");
}
private async void LoadTextQuueFilterControl(TextboxQueueViewModel viewModel, bool isNumeric = false)
{
List<OperatorModel> AllOperators = new List<OperatorModel>();
List<string> AllConditionals = new List<string>();
AllConditionals.Add(CollectionQueueOperators.And.ToString());
AllConditionals.Add(CollectionQueueOperators.Or.ToString());
if (isNumeric)
{
AllOperators.Add(new OperatorModel() { Text = CollectionQueueCondition.None, Value = CollectionQueueCondition.None });
AllOperators.Add(new OperatorModel() { Text = CollectionQueueCondition.IsGreaterthan, Value = CollectionQueueCondition.IsGreaterthan });
AllOperators.Add(new OperatorModel() { Text = CollectionQueueCondition.IsGreaterthanOrEqualTo, Value = CollectionQueueCondition.IsGreaterthanOrEqualTo });
AllOperators.Add(new OperatorModel() { Text = CollectionQueueCondition.IsLessthan, Value = CollectionQueueCondition.IsLessthan });
AllOperators.Add(new OperatorModel() { Text = CollectionQueueCondition.IsLessthanOrEqualTo, Value = CollectionQueueCondition.IsLessthanOrEqualTo });
viewModel.AllOperators = AllOperators;
viewModel.LocalSelectedOperators1 = AllOperators.FirstOrDefault(op => op.Value == CollectionQueueCondition.None);
viewModel.LocalSelectedOperators2 = AllOperators.FirstOrDefault(op => op.Value == CollectionQueueCondition.None);
}
else
{
viewModel.AllOperators = Operators.ToList();
viewModel.LocalSelectedOperators1 = viewModel.AllOperators.FirstOrDefault(p => p.Value == null);
viewModel.LocalSelectedOperators2 = viewModel.AllOperators.FirstOrDefault(p => p.Value == null);
}
viewModel.AllConditionals = AllConditionals;
viewModel.LocalSelectedCondition = CollectionQueueOperators.And.ToString();
viewModel.IsNumeric = isNumeric;
viewModel.Value1 = string.Empty;
viewModel.Value2 = string.Empty;
}
private ConditionModel ParserTextboxFilter(TextboxQueueViewModel textboxViewModel)
{
ConditionModel result = new ConditionModel();
if (textboxViewModel.LocalSelectedCondition.Equals(CollectionQueueOperators.And.ToString()))
result.isAnd = true;
else if (textboxViewModel.LocalSelectedCondition.Equals(CollectionQueueOperators.Or.ToString()))
result.isAnd = false;
if (textboxViewModel.LocalSelectedOperators1.Text.Equals(CollectionQueueCondition.None) && textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.None))
{
result.MinValue = null;
result.MaxValue = null;
result.isAnd = null;
}
else
{
if (textboxViewModel.LocalSelectedOperators1.Text.Equals(CollectionQueueCondition.None))
{
if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsGreaterthan))
{
result.MinValue = textboxViewModel.Value2 == "" ? 0 : Convert.ToDecimal(textboxViewModel.Value2);
result.MaxValue = null;
result.isAnd = null;
}
else if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsLessthan))
{
result.MinValue = null;
result.MaxValue = textboxViewModel.Value2 == "" ? 0 : Convert.ToDecimal(textboxViewModel.Value2);
result.isAnd = null;
}
}
else if (textboxViewModel.LocalSelectedOperators1.Text.Equals(CollectionQueueCondition.IsGreaterthan))
{
if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.None))
{
result.MinValue = textboxViewModel.Value1 == "" ? 0 : Convert.ToDecimal(textboxViewModel.Value1);
result.MaxValue = null;
result.isAnd = null;
}
else if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsLessthan))
{
result.MinValue = textboxViewModel.Value1 == "" ? 0 : Convert.ToDecimal(textboxViewModel.Value1);
result.MaxValue = textboxViewModel.Value2 == "" ? 0 : Convert.ToDecimal(textboxViewModel.Value2);
}
else if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsGreaterthan))
{
if (result.isAnd == true)
result.MinValue = Convert.ToDouble(textboxViewModel.Value2) > Convert.ToDouble(textboxViewModel.Value1) ? Convert.ToDecimal(textboxViewModel.Value2) : Convert.ToDecimal(textboxViewModel.Value1);
else
result.MinValue = Convert.ToDouble(textboxViewModel.Value2) < Convert.ToDouble(textboxViewModel.Value1) ? Convert.ToDecimal(textboxViewModel.Value2) : Convert.ToDecimal(textboxViewModel.Value1);
result.MaxValue = null;
result.isAnd = null;
}
}
else if (textboxViewModel.LocalSelectedOperators1.Text.Equals(CollectionQueueCondition.IsLessthan))
{
if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.None))
{
result.MinValue = null;
result.MaxValue = Convert.ToDecimal(textboxViewModel.Value1);
result.isAnd = null;
}
else if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsGreaterthan))
{
result.MinValue = Convert.ToDecimal(textboxViewModel.Value2);
result.MaxValue = Convert.ToDecimal(textboxViewModel.Value1);
}
else if (textboxViewModel.LocalSelectedOperators2.Text.Equals(CollectionQueueCondition.IsLessthan))
{
result.MinValue = null;
if (result.isAnd == true)
result.MaxValue = Convert.ToDouble(textboxViewModel.Value2) < Convert.ToDouble(textboxViewModel.Value1) ? Convert.ToDecimal(textboxViewModel.Value2) : Convert.ToDecimal(textboxViewModel.Value1);
else
result.MaxValue = Convert.ToDouble(textboxViewModel.Value2) > Convert.ToDouble(textboxViewModel.Value1) ? Convert.ToDecimal(textboxViewModel.Value2) : Convert.ToDecimal(textboxViewModel.Value1);
result.isAnd = null;
}
}
}
return result;
}
private void BuildStringFilter(TextboxQueueViewModel ctrlTextFilter, CollectionQueueFilterString collectionqueuestring)
{
if (collectionqueuestring.IsAnd != null && collectionqueuestring.IsAnd == false)
{
ctrlTextFilter.LocalSelectedCondition = CollectionQueueOperators.Or.ToString();
}
else
{
ctrlTextFilter.LocalSelectedCondition = CollectionQueueOperators.And.ToString();
}
if (collectionqueuestring.Operator1 != null)
{
ctrlTextFilter.LocalSelectedOperators1 = ctrlTextFilter.AllOperators.FirstOrDefault(p => p.Value == collectionqueuestring.Operator1.Value.ToString());
ctrlTextFilter.Value1 = collectionqueuestring.Value1 == null ? "" : collectionqueuestring.Value1;
}
if (collectionqueuestring.Operator2 != null)
{
ctrlTextFilter.LocalSelectedOperators2 = ctrlTextFilter.AllOperators.FirstOrDefault(p => p.Value == collectionqueuestring.Operator2.Value.ToString());
ctrlTextFilter.Value2 = collectionqueuestring.Value2 == null ? "" : collectionqueuestring.Value2;
}
}