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