public bool fnRunOPoortunitiesfrmExport(int iProjectId, string strTabName, string Timeperiod1, string Timeperiod2, string strMainFilter)
{
try
{
//((OraDBManager)Common.dbMgr).BeginTrans();
DataTable dt = new DataTable();
string strSql = "SELECT O.OPPORTUNITY_ID,O.OPP_NAME,O.FORMULA,O.ELGBL_FORMULA,O.PTNL_FORMULA,S.DROPPERS_CUTOFF ,S.STOPPERS_CUTOFF,S.GROWERS_CUTOFF,";
strSql += " '" + Timeperiod1 + "' as T1,'" + Timeperiod2 + "' as T2,S.CURRENTSEGMENT,S.SEGMENTISACTIVE,TT.TIMEPERIOD_ID ";
strSql += " FROM OPPORTUNITY O INNER JOIN STATUS_BREAKDOWN S ON O.OPPORTUNITY_ID=S.OPPORTUNITY_ID ";
strSql += " LEFT JOIN TRE_TIMEPERIOD TT ON TT.T1='" + Timeperiod1 + "' AND TT.T2='" + Timeperiod2 + "'";
strSql += " WHERE O.PROJECT_ID= " + iProjectId;
//strSql += " AND O.ISONMAIN=1";
dt = ((OraDBManager)Common.dbMgr).ExecuteDataTable(CommandType.Text, strSql);
#region Comments by sravanthi
/* Commented by Sravanthi
*
* for (int i = 0; i < dt.Rows.Count; i++)
* {
* if (!fnSaveOppRecomendationSettings(dt.Rows[i], strTabName, iProjectId))
* {
* ((OraDBManager)Common.dbMgr).RollbackTrans();
* return false;
* }
* if (!fnSaveThresholdfrmExport(dt.Rows[i], strTabName, iProjectId,strMainFilter))
* {
* ((OraDBManager)Common.dbMgr).RollbackTrans();
* return false;
* }
* //commented by arun
* //strSql = "Update OPPORTUNITY A Set ISONMAIN=1 Where OPPORTUNITY_ID=" + dt.Rows[i]["OPPORTUNITY_ID"];
* //dt = ((OraDBManager)Common.dbMgr).ExecuteDataTable(CommandType.Text, strSql);
* } */
#endregion
if (!fnSaveOppRecomendationSettings(dt.Rows[0], strTabName, iProjectId))
{
((OraDBManager)Common.dbMgr).RollbackTrans();
return(false);
}
strSql = " Declare";
strSql += " BaseTable string(200);";
strSql += " BEGIN";
strSql += " BaseTable := 'ets_tre_base';";
strSql += " TRE_GET_DELTASTATUS(BaseTable);";
strSql += " END;";
((OraDBManager)Common.dbMgr).ExecuteNonQuery(CommandType.Text, strSql);
//((OraDBManager)Common.dbMgr).ExecuteNonQuery(CommandType.Text, strSql);
strSql = " Declare";
strSql += " MainTableName string(200);";
strSql += " Week int;";
strSql += " BEGIN";
strSql += " MainTableName := '" + strTabName + "_V'" + ";";
strSql += " Week :=" + objclsTreDetails.fnMaxWeek(strTabName) + ";";
strSql += " TRE_GET_PTNL(MainTableName, Week);";
strSql += " END;";
((OraDBManager)Common.dbMgr).ExecuteNonQuery(CommandType.Text, strSql);
// //((OraDBManager)Common.dbMgr).CommitTrans();
return(true);
}
catch (Exception ex)
{
((OraDBManager)Common.dbMgr).RollbackTrans();
throw ex;
}
}
public bool fnRunOPoortunitiesfrmExport(int iProjectId, string strTabName, string Timeperiod1, string Timeperiod2, string strMainFilter)
{
try
{
//((OraDBManager)Common.dbMgr).BeginTrans();
DataTable dt = new DataTable();
string strSql = "SELECT O.OPPORTUNITY_ID,O.OPP_NAME,O.FORMULA,O.ELGBL_FORMULA,O.PTNL_FORMULA,S.DROPPERS_CUTOFF ,S.STOPPERS_CUTOFF,S.GROWERS_CUTOFF,";
strSql += " '" + Timeperiod1 + "' as T1,'" + Timeperiod2 + "' as T2,S.CURRENTSEGMENT,S.SEGMENTISACTIVE,TT.TIMEPERIOD_ID ";
strSql += " FROM OPPORTUNITY O INNER JOIN STATUS_BREAKDOWN S ON O.OPPORTUNITY_ID=S.OPPORTUNITY_ID ";
strSql += " LEFT JOIN TRE_TIMEPERIOD TT ON TT.T1='" + Timeperiod1 + "' AND TT.T2='" + Timeperiod2 + "'";
strSql += " WHERE O.PROJECT_ID= " + iProjectId;
//strSql += " AND O.ISONMAIN=1";
dt = ((OraDBManager)Common.dbMgr).ExecuteDataTable(CommandType.Text, strSql);
if (Common.iDBType == (int)Enums.DBType.Oracle)
{
dt = ((OraDBManager)Common.dbMgr).ExecuteDataTable(CommandType.Text, strSql);
}
else if (Common.iDBType == (int)Enums.DBType.Mysql)
{
dt = ((MySqlDBManager)Common.dbMgr).ExecuteDataTable(CommandType.Text, strSql);
}
if (!fnSaveOppRecomendationSettings(dt.Rows[0], strTabName, iProjectId))
{
if (Common.iDBType == (int)Enums.DBType.Oracle)
{
((OraDBManager)Common.dbMgr).RollbackTrans();
}
else if (Common.iDBType == (int)Enums.DBType.Mysql)
{
((MySqlDBManager)Common.dbMgr).RollbackTrans();
}
return(false);
}
strSql = " Declare";
strSql += " BaseTable string(200);";
strSql += " BEGIN";
strSql += " BaseTable := 'ets_tre_base';";
strSql += " TRE_GET_DELTASTATUS(BaseTable);";
strSql += " END;";
if (Common.iDBType == (int)Enums.DBType.Oracle)
{
((OraDBManager)Common.dbMgr).ExecuteNonQuery(CommandType.Text, strSql);
}
else if (Common.iDBType == (int)Enums.DBType.Mysql)
{
((MySqlDBManager)Common.dbMgr).ExecuteNonQuery(CommandType.Text, strSql);
}
//((OraDBManager)Common.dbMgr).ExecuteNonQuery(CommandType.Text, strSql);
strSql = " Declare";
strSql += " MainTableName string(200);";
strSql += " Week int;";
strSql += " BEGIN";
strSql += " MainTableName := '" + strTabName + "_V'" + ";";
strSql += " Week :=" + objclsTreDetails.fnMaxWeek(strTabName) + ";";
strSql += " TRE_GET_PTNL(MainTableName, Week);";
strSql += " END;";
if (Common.iDBType == (int)Enums.DBType.Oracle)
{
((OraDBManager)Common.dbMgr).ExecuteNonQuery(CommandType.Text, strSql);
}
else if (Common.iDBType == (int)Enums.DBType.Mysql)
{
((MySqlDBManager)Common.dbMgr).ExecuteNonQuery(CommandType.Text, strSql);
}
// //((OraDBManager)Common.dbMgr).CommitTrans();
return(true);
}
catch (Exception ex)
{
if (Common.iDBType == (int)Enums.DBType.Oracle)
{
((OraDBManager)Common.dbMgr).RollbackTrans();
}
else if (Common.iDBType == (int)Enums.DBType.Mysql)
{
((MySqlDBManager)Common.dbMgr).RollbackTrans();
}
throw ex;
}
}