/// <summary> /// Gets the formula value. /// </summary> /// <param name="columnName">The columnName.</param> /// <param name="valueFromForm">Value From Form</param> /// <returns>selectedformulaValue</returns> private FormulaAlteredValue GetFormulaValue(string columnName, string valueFromForm) { FormulaAlteredValue currentFormulaAlteredValue; UltraGridColumn createdColumn; createdColumn = this.FormulaBuilderInfraGrid.DisplayLayout.Bands[SharedFunctions.GetResourceString("SelectedBandValue")].Columns[columnName]; if (null == createdColumn.Layout.Grid.CalcManager) { createdColumn.Layout.Grid.CalcManager = new UltraCalcManager(); } FormulaBuilderDialog formulaBuilderDialog = new FormulaBuilderDialog(createdColumn, true); this.loadedFormulaValue = valueFromForm; formulaBuilderDialog.Load += new EventHandler(this.FormulaBuilderDialog_Load); DialogResult result = formulaBuilderDialog.ShowDialog(this.ParentForm); if (result.Equals(DialogResult.OK)) { currentFormulaAlteredValue.FlagAltered = true; currentFormulaAlteredValue.AlteredValue = formulaBuilderDialog.Formula; } else { currentFormulaAlteredValue.FlagAltered = false; currentFormulaAlteredValue.AlteredValue = formulaBuilderDialog.Formula; } this.loadedFormulaValue = string.Empty; return(currentFormulaAlteredValue); }
////Added by Latha #region ShowFormulaBuilderDialog method /// <summary> /// Shows the formula builder dialog. /// </summary> /// <param name="formulaProvider">The formula provider.</param> private void ShowFormulaBuilderDialog(IFormulaProvider formulaProvider) { ////Declare a new FormulaBuilderDialog FormulaBuilderDialog formulaBuilderDialog = new FormulaBuilderDialog(formulaProvider); formulaBuilderDialog.FunctionInitializing += new FunctionInitializingEventHandler(this.FormulaBuilder_FunctionInitializing); formulaBuilderDialog.OperandInitializing += new OperandInitializingEventHandler(formulaBuilderDialog_OperandInitializing); try { //// Show the dialog DialogResult dialResult = formulaBuilderDialog.ShowDialog(this); if (DialogResult.OK == dialResult) { if (!this.flagFormDataModify) { this.FormulaTextBox.Text = formulaBuilderDialog.Formula; this.createdColumn.Formula = this.FormulaTextBox.Text; this.createdColumn.Format = this.FormatTextBox.Text; object type = this.createdColumn.DataType.FullName; } else { this.FormulaTextBox.Text = formulaBuilderDialog.Formula; this.band.Columns[this.columnIndex].Formula = this.FormulaTextBox.Text; this.band.Columns[this.columnIndex].Format = this.FormatTextBox.Text; } } } finally { //// Disconnect from the events formulaBuilderDialog.FunctionInitializing -= new FunctionInitializingEventHandler(this.FormulaBuilder_FunctionInitializing); } }