void bindingExpressionEditor(int iExpressionType)
{
try
{
clsDataSource clsDSOBJ = new clsDataSource();
// DataTable dt = clsDSOBJ.fnGetTreDetails(Common.strTableName);
DataTable dt = clsDSOBJ.fnGetTreDetails("Tre_Random");
DataTableReader dr = new DataTableReader(dt);
DataTable dtSchema = dr.GetSchemaTable();
using (var frm = new frmExpressEditor(iExpressionType, "Tre_Random", strPtnlFilter))
{
frm._fieldDict = Common.GetDict(dt);
frm.AvailableFields = frm._fieldDict.ToList <KeyValuePair <string, Type> >();
frm.dtSource = dtSchema;
var res = frm.ShowDialog();
if (res == System.Windows.Forms.DialogResult.OK)
{
strPtnlFilter = frm.strExpression;
Common.strPtnlFilter = strPtnlFilter;
}
}
}
catch (Exception ex)
{
Telerik.WinControls.RadMessageBox.Show(this, ex.Message, ex.TargetSite.Name.ToString(), MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void fnLoadPreview()
{
try
{
if (Common.bIsConnectionStringEstablish)
{
lblError.Visible = false;
if (!bPreviewLoaded)
{
//DataTable dt = clsDSObj.fnGetTreDetails(Common.strTableName);
DataTable dt = clsDSObj.fnGetTreDetails("Tre_Random");
grdPreview.DataSource = dt;
this.grdPreview.MasterTemplate.Refresh(null);
grdPreview.Refresh();
grdPreview.AllowAddNewRow = false;
grdPreview.ShowRowHeaderColumn = false;
grdPreview.EnableGrouping = false;
grdPreview.ShowFilteringRow = false;
grdPreview.AutoSizeRows = false;
grdPreview.AllowEditRow = false;
grdPreview.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.None;
grdPreview.MasterTemplate.BestFitColumns();
grdPreview.AutoScroll = true;
}
}
else
{
grdPreview.Visible = false;
lblError.Visible = true;
}
}
catch (Exception ex)
{
Telerik.WinControls.RadMessageBox.Show(this, ex.Message, ex.TargetSite.Name.ToString(), MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
}
}
void bindingExpressionEditor(int iExpressionType, string CalaculatedColumnValue = "", string strColname = "")
{
try
{
clsDataSource clsObj = new clsDataSource();
DataTable dtSource = clsObj.fnGetColMappingData(Common.iProjectID);
DataTable dt = clsDSOBJ.fnGetTreDetails(Common.strTableName);
DataTableReader dr = new DataTableReader(dt);
DataTable dtSchema = dr.GetSchemaTable();
string strExpression = "";
if (iExpressionType == (int)Enums.ExpressionType.Filter)
{
strExpression = clsObj.fnselectFilterCondition(Common.iProjectID);
}
else
{
strExpression = "";
}
if (iExpressionType == (int)Enums.ExpressionType.CalaculatedColumn)
{
strExpression = CalaculatedColumnValue;
}
using (var frm = new frmExpressEditor(iExpressionType, Common.strTableName, strExpression))
{
frm._fieldDict = Common.GetDict(dt);
frm.AvailableFields = frm._fieldDict.ToList <KeyValuePair <string, Type> >();
frm.dtSource = dtSchema;
var res = frm.ShowDialog();
if (res == System.Windows.Forms.DialogResult.OK)
{
if (iExpressionType == (int)Enums.ExpressionType.Filter)
{
clsObj.fnInserFilter(frm.strExpression, Common.iProjectID);
}
else if (iExpressionType == (int)Enums.ExpressionType.AddColumn)
{
// Common.strfiltertxt = "";
string strColName = frm.strColName;
string strMsg = "";
strExpression = frm.strExpression;
if (!clsObj.fnAddCalaculatedColumn(Common.strTableName, strColName, strExpression, ref strMsg, Common.iProjectID))
{
if (strMsg != "")
{
Telerik.WinControls.RadMessageBox.Show(this, strMsg, "Information", MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
}
return;
}
}
else if (iExpressionType == (int)Enums.ExpressionType.CalaculatedColumn)
{
if (!clsObj.fnUpdateCalaculatedColumn(Common.strTableName, strColname, frm.strExpression, Common.iProjectID))
{
}
}
dtmain = (DataTable)dataschemaGrid.DataSource;
dataschemaGridbinding();
}
}
}
catch (Exception ex)
{
Telerik.WinControls.RadMessageBox.Show(this, ex.Message, ex.TargetSite.Name.ToString(), MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
}
}