private void fnFillSource()
{
try
{
clsDataSource clsObj = new clsDataSource();
DataTable dtSource = clsObj.fnGetColMappingData(Common.iProjectID);
DataRow[] dr = dtSource.Select("TYPE=" + ((int)Enums.ColType.Input).ToString() + " And ISREQUIRED=1");
DataTable dt = dr.CopyToDataTable();
ddlSource.DataSource = dt;
ddlSource.ValueMember = "COLNAME";
ddlSource.DisplayMember = "COLNAME";
ddlSource.SelectedIndex = 0;
foreach (string opptype in OpportunityTypes)
{
ddlOpportunityType.Items.Add(opptype);
}
ddlOpportunityType.SelectedIndex = 0;
}
catch (Exception ex)
{
throw ex;
}
}
private void pctFormula_Click(object sender, EventArgs e)
{
try
{
clsDataSource clsObj = new clsDataSource();
// frmExpressEditor frm = new frmExpressEditor();
DataTable dtSource = clsObj.fnGetColMappingData();
DataTable dt = new DataTable();
for (int i = 0; i < dtSource.Rows.Count; i++)
{
if ((dtSource.Rows[i]["TYPE"].ToString() == ((int)Enums.ColType.Key).ToString()) ||
(dtSource.Rows[i]["TYPE"].ToString() == ((int)Enums.ColType.Input).ToString() && dtSource.Rows[i]["ISREQUIRED"].ToString() == "1"))
{
if (dtSource.Rows[i]["COLDATATYPE"].ToString().ToUpper() == "System.Decimal".ToUpper())
{
dt.Columns.Add(new DataColumn(dtSource.Rows[i]["COLNAME"].ToString(), typeof(decimal)));
}
else if (dtSource.Rows[i]["COLDATATYPE"].ToString().ToUpper() == "System.DateTime".ToUpper())
{
dt.Columns.Add(new DataColumn(dtSource.Rows[i]["COLNAME"].ToString(), typeof(DateTime)));
}
else if (dtSource.Rows[i]["COLDATATYPE"].ToString().ToUpper() == "System.String".ToUpper())
{
dt.Columns.Add(new DataColumn(dtSource.Rows[i]["COLNAME"].ToString(), typeof(string)));
}
else if (dtSource.Rows[i]["COLDATATYPE"].ToString().ToUpper() == "System.int".ToUpper() ||
dtSource.Rows[i]["COLDATATYPE"].ToString().ToUpper() == "System.Int16".ToUpper() ||
dtSource.Rows[i]["COLDATATYPE"].ToString().ToUpper() == "System.Int32".ToUpper() ||
dtSource.Rows[i]["COLDATATYPE"].ToString().ToUpper() == "System.Int64".ToUpper())
{
dt.Columns.Add(new DataColumn(dtSource.Rows[i]["COLNAME"].ToString(), typeof(int)));
}
}
}
dt.Columns.Add(new DataColumn("OPPValue", typeof(decimal)));
using (var frm = new frmExpressEditor((int)Enums.ExpressionType.Opp_ptnl, Common.strTableName, strExpression))
{
frm._fieldDict = GetDict(dt);
frm.AvailableFields = frm._fieldDict.ToList <KeyValuePair <string, Type> >();
frm.dtSource = dtSource;
var res = frm.ShowDialog();
if (res == System.Windows.Forms.DialogResult.OK)
{
strExpression = frm.strExpression;
}
}
}
catch (Exception ex)
{
Telerik.WinControls.RadMessageBox.Show(this, ex.Message, ex.TargetSite.Name.ToString(), MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
}
}
private void fnIsTableMapped()
{
DataTable dt = clsObj.fnGetColMappingData(Common.iProjectID);
if (dt.Rows.Count == 0)
{
Common.strTableName = "";
fnDisableControls(false, true);
}
else
{
Common.strTableName = dt.Rows[0]["TableName"].ToString();
DataRow[] drRow = dt.Select("TYPE=" + (int)Enums.ColType.Key);
if (drRow.Length > 0)
{
Common.strKeyName = drRow[0]["COLNAME"].ToString();
}
Common.SetLoginDetailsToRegistry();
}
}
void dataschemaGridbinding()
{
try
{
DataTable dt = clsDSOBJ.fnGetTreDetailsSchema(ddlTableName.SelectedValue.ToString());
DataTable dtcalaculated = clsDSOBJ.fnGetCalaculatedColMappingData(Common.iProjectID, Common.strTableName);
DataTable dt1 = clsDSOBJ.fnGetColMappingData(Common.iProjectID);
DataRow row;
dt.Columns.Add(new DataColumn("Table", typeof(string)));
dt.Columns.Add(new DataColumn("Type", typeof(int)));
dt.Columns.Add(new DataColumn("Required", typeof(bool)));
foreach (DataRow drcal in dtcalaculated.Rows)
{
row = dt.NewRow();
row["ColumnName"] = drcal["COLNAME"].ToString();
row["Table"] = "C";
//if (drcal["COLDATATYPE"].ToString() == "NUMBER")
//{
// row["DataType"] = typeof(decimal);
//}
row["DataType"] = drcal["COLDATATYPE"].ToString() == "NUMBER" ? typeof(Decimal) : drcal["COLDATATYPE"].ToString() == "DATE" ? typeof(DateTime) : typeof(String);
dt.Rows.Add(row);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt1.Rows.Count > 0)
{
DataRow[] dr = dt1.Select("COLNAME='" + dt.Rows[i][0].ToString() + "'");
if (dr.Length > 0 && dr[0]["TABLENAME"].ToString().ToLower() == ddlTableName.SelectedValue.ToString().ToLower())
{
dt.Rows[i]["Type"] = dr[0]["Type"];
dt.Rows[i]["Required"] = dr[0]["ISREQUIRED"];
if (dt.Rows[i]["Table"].ToString() != "C")
{
dt.Rows[i]["Table"] = "M";
}
}
else
{
dt.Rows[i]["Type"] = (int)Enums.ColType.None;
if (dt.Rows[i]["Table"] != "C")
{
dt.Rows[i]["Table"] = "M";
}
dt.Rows[i]["Required"] = false;
}
}
else
{
dt.Rows[i]["Type"] = (int)Enums.ColType.None;
if (dt.Rows[i]["Table"] != "C")
{
dt.Rows[i]["Table"] = "M";
}
dt.Rows[i]["Required"] = false;
}
}
dataschemaGrid.DataSource = dt;
//// DataTable dtmain = (DataTable)dataschemaGrid.DataSource;
// if (dtmain.Rows.Count > 0)
// {
// //dtmain.Merge(dt, true);
// if (dtmain.Rows.Count != dt.Rows.Count)
// {
// DataRow dr = dtmain.NewRow();
// dr = dt.Rows[dt.Rows.Count - 1] as DataRow;
// dt.Rows[dt.Rows.Count - 1].Delete();
// dtmain.Rows.Add(dr.ItemArray);
// dataschemaGrid.DataSource = dtmain;
// dtmain = null;
// }
// }
// else
// {
// dataschemaGrid.DataSource = dt;
// }
GridViewComboBoxColumn categoryColumn = new GridViewComboBoxColumn();
categoryColumn.HeaderText = "Type";
categoryColumn.ValueMember = "TypeId";
categoryColumn.DisplayMember = "Type";
categoryColumn.FieldName = "Type";
categoryColumn.DataSource = clsDSOBJ.fnCreateColTypes();
categoryColumn.Width = 200;
if (dataschemaGrid.MasterTemplate.Columns.Contains("Type1"))
{
dataschemaGrid.MasterTemplate.Columns.Remove("Type1");
}
dataschemaGrid.MasterTemplate.Columns.Add(categoryColumn);
dataschemaGrid.Columns["ColumnName"].ReadOnly = true;
dataschemaGrid.Columns["DataType"].ReadOnly = true;
dataschemaGrid.Columns["Type"].ReadOnly = true;
dataschemaGrid.Columns["Type"].IsVisible = false;
dataschemaGrid.Columns["Table"].IsVisible = true;
dataschemaGrid.Columns[0].Width = 200;
// dataschemaGrid.Columns[1].AutoSizeMode = BestFitColumnMode.DisplayedDataCells;
dataschemaGrid.Columns["DataType"].Width = 300;
dataschemaGrid.Columns["Required"].Width = 50;
dataschemaGrid.Columns["Table"].Width = 30;
dataschemaGrid.Columns.Remove("NumericPrecision");
dataschemaGrid.Columns.Remove("NumericScale");
dataschemaGrid.Columns.Remove("ProviderType");
dataschemaGrid.Columns.Remove("IsLong");
dataschemaGrid.Columns.Remove("AllowDBNull");
dataschemaGrid.Columns.Remove("IsReadOnly");
dataschemaGrid.Columns.Remove("IsUnique");
dataschemaGrid.Columns.Remove("IsKey");
dataschemaGrid.Columns.Remove("IsAutoIncrement");
dataschemaGrid.Columns.Remove("IsRowVersion");
dataschemaGrid.Columns.Remove("ColumnMapping");
dataschemaGrid.Columns.Remove("AutoIncrementSeed");
dataschemaGrid.Columns.Remove("AutoIncrementStep");
dataschemaGrid.Columns.Remove("BaseCatalogName");
dataschemaGrid.Columns.Remove("BaseSchemaName");
dataschemaGrid.Columns.Remove("BaseTableName");
dataschemaGrid.Columns.Remove("BaseTableNameSpace");
dataschemaGrid.Columns.Remove("BaseColumnName");
dataschemaGrid.Columns.Remove("BaseColumnNameSpace");
dataschemaGrid.Columns.Remove("Expression");
dataschemaGrid.Columns.Remove("DefaultValue");
dataschemaGrid.Columns.Remove("ColumnOrdinal");
dataschemaGrid.Columns.Remove("ColumnSize");
dataschemaGrid.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
//dataschemaGrid.MasterTemplate.BestFitColumns();
dataschemaGrid.CellValueChanged += new GridViewCellEventHandler(dataschemaGrid_CellValueChanged);
}
catch (Exception ex)
{
throw ex;
}
}
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);
}
}