private void CmbDemandAmountComparison_OnSelectedIndexChanged(object sender, EventArgs e) { Constants.Comparison comparison = Constants.ComparisonFromString((string)cmbDemandAmountComparison.SelectedItem); txtDemandAmountValue1.Enabled = comparison != Constants.Comparison.NONE; txtDemandAmountValue2.Enabled = comparison == Constants.Comparison.RANGE; OnDemandAmountFilterChanged(); }
private void OnDemandAmountFilterChanged() { Constants.Comparison comparison = Constants.ComparisonFromString((string)cmbDemandAmountComparison.SelectedItem); string value1 = txtDemandAmountValue1.Text; string value2 = txtDemandAmountValue2.Text; _presenter.SetFilterParameters(Constants.FieldNames.DEMAND_AMOUNT, comparison, value1, value2); }
private void OnCaseFiledDateFilterChanged() { Constants.Comparison comparison = Constants.ComparisonFromString((string)cmbCaseFiledDateComparison.SelectedItem); dtpCaseFiledDate1.Enabled = comparison != Constants.Comparison.NONE; dtpCaseFiledDate2.Enabled = comparison == Constants.Comparison.RANGE; string value1 = dtpCaseFiledDate1.Text; string value2 = dtpCaseFiledDate2.Text; _presenter.SetFilterParameters(Constants.FieldNames.CASE_FILED_DATE, comparison, value1, value2); }
public void SetFilterParameters(string fieldName, Constants.Comparison comparison, string value1, string value2) { if (string.IsNullOrWhiteSpace(value1) || comparison == Constants.Comparison.NONE || (comparison == Constants.Comparison.RANGE && string.IsNullOrWhiteSpace(value2))) { ComparisonFilter comparisonFilter = _comparisonFilterValues[fieldName]; comparisonFilter.Value = "true"; _comparisonFilterValues[fieldName] = comparisonFilter; } else if(comparison != Constants.Comparison.RANGE) { ComparisonFilter comparisonFilter = _comparisonFilterValues[fieldName]; comparisonFilter.Value = "[" + fieldName + "] " + comparison.ComparisonToString() + " " + value1 + " "; _comparisonFilterValues[fieldName] = comparisonFilter; } else { ComparisonFilter comparisonFilter = _comparisonFilterValues[fieldName]; comparisonFilter.Value = "([" + fieldName + "] " + Constants.Comparison.GREATER.ComparisonToString() + " " + value1 + " and [" + fieldName + "] " + Constants.Comparison.LOWER.ComparisonToString() + " " + value2 + ")"; _comparisonFilterValues[fieldName] = comparisonFilter; } }
/// <summary> /// Configure range comparison filter for a given field /// </summary> /// <param name="fieldName">The field name; see Constants.FieldNames for allowed values</param> /// <param name="comparison">Comparison operator; see Constants.Comparison</param> /// <param name="value1">The filter expression will be: value1 comparison value2</param> /// <param name="value2">The filter expression will be: value1 comparison value2</param> public void SetFilterParameters(string fieldName, Constants.Comparison comparison, string value1, string value2) { _model.SetFilterParameters(fieldName, comparison, value1, value2); }
/// <summary> /// Configuring a comparison-type filter without applying it /// </summary> /// <param name="fieldName">Database field to compare</param> /// <param name="comparison">Comparison to perform</param> /// <param name="value1">First value to compare</param> /// <param name="value2">Second value to compare; only used for RANGE comparisons</param> public void SetFilterParameters(string fieldName, Constants.Comparison comparison, string value1, string value2) { _databaseDataHandler.SetFilterParameters(fieldName, comparison, value1, value2); }