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);
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
generateMapclass();
string strTabName = ddlTableName.SelectedValue.ToString().ToUpper();
//strTabName = "tre_random".ToUpper();;
dataschemaGrid.Refresh();
DataTable dt = (DataTable)dataschemaGrid.DataSource;
DataRow[] drs = dt.Select("TYPE=" + (int)Enums.ColType.Key);
if (drs.Length == 0)
{
Telerik.WinControls.RadMessageBox.Show(this, "Should map 'Key' to at least one column.", "Information", MessageBoxButtons.OK, RadMessageIcon.Info, MessageBoxDefaultButton.Button1);
return;
}
drs = dt.Select("TYPE=" + (int)Enums.ColType.Time);
if (drs.Length > 1)
{
// Telerik.WinControls.RadMessageBox.Show(this, "Should not map 'Time' to more than one column.", "Information", MessageBoxButtons.OK, RadMessageIcon.Info, MessageBoxDefaultButton.Button1);
}
else if (drs.Length == 0)
{
Telerik.WinControls.RadMessageBox.Show(this, "Should map 'Time' to at least one column.", "Information", MessageBoxButtons.OK, RadMessageIcon.Info, MessageBoxDefaultButton.Button1);
return;
}
drs = dt.Select("Required='True'");
if (drs.Length > 0)
{
Common.strfiltertxt = clsDSOBJ.fnselectFilterCondition(Common.iProjectID);
clsDSOBJ.fnInsertTreMApping(drs, strTabName, Common.strfiltertxt, Common.iProjectID);
// clsDSOBJ.fnCreateTreMApping(drs, strTabName,Common.strfiltertxt);
Common.strTableName = ddlTableName.SelectedValue.ToString();
// Common.strTableName = "tre_random";
Common.bIsTableMapped = true;
Common.SetLoginDetailsToRegistry();
dataschemaGridbinding();
}
}
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);
}
}
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);
}
}
