private void fnCreateView()
{
string str = "";
clsDataSource _clsDataSource = new clsDataSource();
this.strMainFilter = _clsDataSource.fnselectFilterCondition(Common.iProjectID);
DataTable dataTable = _clsDataSource.fnGetTreDetailsSchema(Common.strTableName);
foreach (DataRow row in dataTable.Rows)
{
str = string.Concat(str, row[0].ToString());
str = string.Concat(str, ",");
}
dataTable = _clsDataSource.fnGetCalaculatedColMappingData(Common.iProjectID, Common.strTableName);
foreach (DataRow dataRow in dataTable.Rows)
{
str = string.Concat(str, dataRow["COMBINE_COLUMNS"].ToString(), " ", dataRow["COLNAME"].ToString());
str = string.Concat(str, ",");
}
if (str.Length > 0)
{
str = str.Remove(str.Length - 1, 1);
}
this.clstreDetails.fnCreateTableView(Common.strTableName, str, this.strMainFilter);
}
void fnCreateView()
{
string strColumns = "";
clsDataSource objDatsource = new clsDataSource();
strMainFilter = objDatsource.fnselectFilterCondition(Common.iProjectID);
DataTable dtcol = objDatsource.fnGetTreDetailsSchema(Common.strTableName);
foreach (DataRow dr in dtcol.Rows)
{
strColumns += dr[0].ToString();
strColumns += ",";
}
dtcol = objDatsource.fnGetCalaculatedColMappingData(Common.iProjectID, Common.strTableName);
foreach (DataRow dr in dtcol.Rows)
{
strColumns += dr["COMBINE_COLUMNS"].ToString() + " " + dr["COLNAME"].ToString();
strColumns += ",";
}
if (strColumns.Length > 0)
{
strColumns = strColumns.Remove(strColumns.Length - 1, 1);
}
clstreDetails.fnCreateTableTab(Common.strTableName, strColumns, strMainFilter);
}
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 fnRunProject(int iProjectID)
{
try
{
Common.timePeriods.strtp1 = chkddlTP1.m_TextBox.Text.ToString().Split(';').ToArray();
Common.timePeriods.strtp2 = cntrlchkDropDowntp2.m_TextBox.Text.ToString().Split(';').ToArray();
int TimePeriodId = clstreDetails.fnInsertTREtimePeriodfrmExport(Common.timePeriods.strtp1, Common.timePeriods.strtp2, Common.strTableName, Common.iProjectID);
string strColumns = "";
DataTable dtcol = objDatsource.fnGetTreDetailsSchema(Common.strTableName);
foreach (DataRow dr in dtcol.Rows)
{
strColumns += dr[0].ToString();
strColumns += ",";
}
dtcol = objDatsource.fnGetCalaculatedColMappingData(Common.iProjectID, Common.strTableName);
string strMainFilter = objDatsource.fnselectFilterCondition(Common.iProjectID);
foreach (DataRow dr in dtcol.Rows)
{
strColumns += dr["COMBINE_COLUMNS"].ToString() + " " + dr["COLNAME"].ToString();
strColumns += ",";
}
if (strColumns.Length > 0)
{
strColumns = strColumns.Remove(strColumns.Length - 1, 1);
}
clstreDetails.fnCreateTableTab(Common.strTableName, strColumns, strMainFilter);
string strT1String = clstreDetails.fnBuildTimePeriod(Common.timePeriods.strtp1);
string strT2String = clstreDetails.fnBuildTimePeriod(Common.timePeriods.strtp2);
//Common.timePeriods.strtp1=
if (objRanking.fnRankingcriteria(iProjectID).Rows.Count > 0)
{
//if (InvokeRequired)
//{
// this.Invoke(new Action(() => fnCheckExport(Common.iProjectID)));
if (fnCheckExport(Common.iProjectID))
{
// clstreDetails.fnDeleteTreOppfrmExport();
if (ClsObj.fnRunOPoortunitiesfrmExport(iProjectID, Common.strTableName, strT1String, strT2String, strMainFilter))
{
objRanking.fnMainRankingfrmExport(iProjectID);
objCampaigns.fnDelteCampaignRankingsfrmExport(Common.iProjectID, Common.strTableName);
DataTable dt = objExport.fnGetCampaigns(iProjectID);
if (dt.Rows.Count > 0)
{
//foreach (DataRow dr in dt.Rows)
//{
// objCampaigns.fnSaveCampaignRankingsfrmExport(dr["ELIGIBILITY"].ToString(), Convert.ToInt16(dr["PROJECT_ID"]), dr["SEGMENT_DESCRIPTION"].ToString(), Convert.ToInt16(dr["CAMPAIGN_ID"]), Common.strTableName, strMainFilter);
//}
//CntrlOfferLibrary col = new CntrlOfferLibrary(0);
//string strPriorVal=col.getPriortiseVal();
string strPriorVal = "Avg_Ptnl";
int iPriorVal = 0;
if (strPriorVal == "Avg_Ptnl")
{
iPriorVal = 1;
}
objCampaigns.fnSaveCampaignRankingsfrmExport(iPriorVal, Common.iProjectID, Common.strTableName, strMainFilter);
//objCampaigns.fnPrioritizeRankingsfrmExport(Common.iProjectID, "Average");
fnExport();
}
else
{
Telerik.WinControls.RadMessageBox.Show(this, "There are no campaigns to export", "", MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
}
}//
}
else
{
MessageBox.Show("Export Settings are not choosen");
return;
}
//}
}
else
{
Telerik.WinControls.RadMessageBox.Show(this, "Ranking Criteria is not choosen for Selected Project", "Information", MessageBoxButtons.OK, RadMessageIcon.Error, MessageBoxDefaultButton.Button1);
return;
}
}
catch (Exception ex)
{
alert.Close();
MessageBox.Show(ex.Message);
}
}