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