private void Addfilters() { string sfilterOperand = string.Empty; string[] shilowvars; string svarname; this.datafilters = rowfiltercontrol.DataFilters; List <string> sconditionval = datafilters.GetFilterConditionsAsList(); string strreadablecondition = datafilters.GenerateReadableDataFilterString().Trim(); if (!(string.IsNullOrEmpty(strreadablecondition))) { if (strreadablecondition.Contains(SharedStrings.FRIENDLY_OPERATOR_EQUAL_TO)) { sfilterOperand = SharedStrings.FRIENDLY_OPERATOR_EQUAL_TO; } else if (strreadablecondition.Contains(SharedStrings.FRIENDLY_OPERATOR_GREATER_THAN)) { sfilterOperand = SharedStrings.FRIENDLY_OPERATOR_GREATER_THAN; } else if (strreadablecondition.Contains(SharedStrings.FRIENDLY_OPERATOR_GREATER_THAN_OR_EQUAL)) { sfilterOperand = SharedStrings.FRIENDLY_OPERATOR_GREATER_THAN_OR_EQUAL; } else if (strreadablecondition.Contains(SharedStrings.FRIENDLY_OPERATOR_LESS_THAN)) { sfilterOperand = SharedStrings.FRIENDLY_OPERATOR_LESS_THAN; } else if (strreadablecondition.Contains(SharedStrings.FRIENDLY_OPERATOR_LESS_THAN_OR_EQUAL)) { sfilterOperand = SharedStrings.FRIENDLY_OPERATOR_LESS_THAN_OR_EQUAL; } else if (strreadablecondition.Contains(SharedStrings.FRIENDLY_OPERATOR_NOT_MISSING)) { sfilterOperand = SharedStrings.FRIENDLY_OPERATOR_NOT_MISSING; } else if (strreadablecondition.Contains(SharedStrings.FRIENDLY_OPERATOR_MISSING)) { sfilterOperand = SharedStrings.FRIENDLY_OPERATOR_MISSING; } if (!(strreadablecondition.Contains(SharedStrings.FRIENDLY_OPERATOR_BETWEEN))) { svarname = strreadablecondition.Substring(strreadablecondition.IndexOf("[") + 1, strreadablecondition.IndexOf("]") - strreadablecondition.IndexOf("[") - 1); dashboardHelper.AddDataFilterCondition(sfilterOperand, sconditionval[0].ToString(), svarname, ConditionJoinType.And); } else if (strreadablecondition.Contains(SharedStrings.FRIENDLY_OPERATOR_BETWEEN)) { sfilterOperand = SharedStrings.FRIENDLY_OPERATOR_BETWEEN; string strcondition = strreadablecondition.Substring(0, strreadablecondition.IndexOf(sfilterOperand)).Trim(); string[] strVarstrings = strcondition.Split(' '); svarname = strVarstrings[3].ToString(); string sValues = strreadablecondition.ToString().Substring(strreadablecondition.IndexOf(sfilterOperand) + sfilterOperand.Length, (strreadablecondition.ToString().Length) - (strreadablecondition.ToString().IndexOf(sfilterOperand) + sfilterOperand.Length)).Trim(); shilowvars = sValues.Split(' '); dashboardHelper.AddDataFilterCondition(sfilterOperand, shilowvars[0].ToString(), shilowvars[2].ToString(), svarname, ConditionJoinType.And); } } }
private void btnIfCondition_Click(object sender, EventArgs e) { RowFilterDialog rfd = new RowFilterDialog(this.dashboardHelper, FilterDialogMode.ConditionalMode, DataFilters, true); DialogResult result = rfd.ShowDialog(); if (result == DialogResult.OK) { this.DataFilters = rfd.DataFilters; this.txtAssignCondition.Text = DataFilters.GenerateReadableDataFilterString();//this.DataFilters.GenerateDataFilterString(); } }
private void btnDenominatorRule_Click(object sender, RoutedEventArgs e) { Dialogs.RowFilterDialog rowFilterDialog = new Dialogs.RowFilterDialog(this.DashboardHelper, Dialogs.FilterDialogMode.ConditionalMode, Parameters.DenomFilter, true); System.Windows.Forms.DialogResult result = rowFilterDialog.ShowDialog(); if (result == System.Windows.Forms.DialogResult.OK) { _denomFilter = rowFilterDialog.DataFilters; Parameters.DenomFilter = rowFilterDialog.DataFilters; denominatorRule.Content = _denomFilter.GenerateReadableDataFilterString(); } }
public ConditionalAssignDialog(DashboardHelper dashboardHelper, Rule_ConditionalAssign conditionalAssignRule) { InitializeComponent(); this.dashboardHelper = dashboardHelper; this.DataFilters = conditionalAssignRule.DataFilters; editMode = true; FillComboBoxes(); this.txtDestinationField.Text = conditionalAssignRule.DestinationColumnName; this.txtDestinationField.Enabled = false; SetAssignValue setAssignValue = new SetAssignValue(SetAssignmentValue); switch (conditionalAssignRule.DestinationColumnType) { case "System.SByte": case "System.Byte": case "System.Boolean": this.cbxFieldType.SelectedItem = "Yes/No"; setAssignValue = new SetAssignValue(SetBooleanAssignmentValue); break; case "System.String": this.cbxFieldType.SelectedItem = "Text"; break; case "System.Single": case "System.Double": case "System.Decimal": case "System.Int32": case "System.Int16": this.cbxFieldType.SelectedItem = "Numeric"; break; } cbxFieldType.Enabled = false; this.txtAssignCondition.Text = DataFilters.GenerateReadableDataFilterString(); //foreach (KeyValuePair<string, object> kvp in conditionalAssignRule.Conditions) //{ // this.txtAssignValue.Text = kvp.Value.ToString(); // break; //} setAssignValue(conditionalAssignRule); }
public ConditionalAssignDialog(DashboardHelper dashboardHelper, Rule_ConditionalAssign conditionalAssignRule) { InitializeComponent(); this.dashboardHelper = dashboardHelper; this.DataFilters = conditionalAssignRule.DataFilters; editMode = true; FillComboBoxes(); this.txtDestinationField.Text = conditionalAssignRule.DestinationColumnName; this.txtDestinationField.Enabled = false; SetAssignValue setAssignValue = new SetAssignValue(SetAssignmentValue); switch (conditionalAssignRule.DestinationColumnType) { case "System.SByte": case "System.Byte": case "System.Boolean": this.cbxFieldType.SelectedItem = "Yes/No"; setAssignValue = new SetAssignValue(SetBooleanAssignmentValue); break; case "System.String": this.cbxFieldType.SelectedItem = "Text"; break; case "System.Single": case "System.Double": case "System.Decimal": case "System.Int32": case "System.Int16": this.cbxFieldType.SelectedItem = "Numeric"; break; } cbxFieldType.Enabled = false; this.txtAssignCondition.Text = DataFilters.GenerateReadableDataFilterString(); //foreach (KeyValuePair<string, object> kvp in conditionalAssignRule.Conditions) //{ // this.txtAssignValue.Text = kvp.Value.ToString(); // break; //} setAssignValue(conditionalAssignRule); }
private void btnIfCondition_Click(object sender, EventArgs e) { RowFilterDialog rfd = new RowFilterDialog(this.dashboardHelper, FilterDialogMode.ConditionalMode, DataFilters, true); DialogResult result = rfd.ShowDialog(); if (result == DialogResult.OK) { this.DataFilters = rfd.DataFilters; this.txtAssignCondition.Text = DataFilters.GenerateReadableDataFilterString();//this.DataFilters.GenerateDataFilterString(); } }