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