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 dataschemaGrid_DoubleClick(object sender, EventArgs e)
{
try
{
if (dataschemaGrid.CurrentRow != null)
{
GridViewRowInfo drRow = dataschemaGrid.CurrentRow;
if (drRow.Cells["Table"].Value.ToString() == "C")
{
DataTable dtcalaculated = clsDSOBJ.fnGetCalaculatedColMappingData(Common.iProjectID, Common.strTableName);
string str = drRow.Cells["ColumnName"].Value.ToString();
DataRow[] dtrows = dtcalaculated.Select("COLNAME = '" + str + "'");
bindingExpressionEditor((int)Enums.ExpressionType.CalaculatedColumn, dtrows[0]["COMBINE_COLUMNS"].ToString(), dtrows[0]["COLNAME"].ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
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);
}
}
