private void fnSaveThresholdAndPotential(int iOpportunityId)
{
try
{
//bIsThresholdModified = true;
//saving Thrishould
clsTre_Details clsTObj = new clsTre_Details();
if (bIsThresholdModified)
{
string strCtDropper = strCt[0] == "" ? "0" : strCt[0];
string strCtGrower = strCt[1] == "" ? "0" : strCt[1];
string srtCtStopper = strCt[2] == "" ? "0" : strCt[2];
string strCFlat = strCount[0] == "" ? "0" : strCount[0];
string strCDropper = strCount[1] == "" ? "0" : strCount[1];
string strCGrower = strCount[2] == "" ? "0" : strCount[2];
string srtCStopper = strCount[3] == "" ? "0" : strCount[3];
string strCNonUser = strCount[4] == "" ? "0" : strCount[4];
string strCNewUser = strCount[5] == "" ? "0" : strCount[5];
string strAvgFlat = strAvg[0] == "" ? "0" : strAvg[0];
string strAvgDropper = strAvg[1] == "" ? "0" : strAvg[1];
string strAvgGrower = strAvg[2] == "" ? "0" : strAvg[2];
string srtAvgStopper = strAvg[3] == "" ? "0" : strAvg[3];
string strAvgNonUser = strAvg[4] == "" ? "0" : strAvg[4];
string strAvgNewUser = strAvg[5] == "" ? "0" : strAvg[5];
if (clsTObj.fnSaveTREThreShold(Common.timePeriods.strtp1, Common.timePeriods.strtp2, Common.sOpportunityName, strCtDropper, strCtGrower, srtCtStopper, iOpportunityId, "Tre_Random", Common.iProjectID, Common.strPtnlFilter, bIsOnMain))
{
clsTObj.fnGetBaseData(Common.strTableName, strCtGrower, Common.iProjectID);
clsTObj.fnSaveOPPBreakDownStatus(iOpportunityId, Convert.ToDecimal(strCtDropper), Convert.ToDecimal(strCtGrower), Convert.ToDecimal(srtCtStopper),
Common.timePeriods.strtp1, Common.timePeriods.strtp2, strCurrentSegmentColumn, iIsActive);
clsTObj.fnInsertOppValues(iOpportunityId);
// clsTObj.fnSaveOPPBreakDownStatus(iOpportunityId, 0, Convert.ToDecimal(strCtDropper), Convert.ToDecimal(strCtGrower), Convert.ToDecimal(srtCtStopper), 0, 0,
// Convert.ToDecimal(strCFlat), Convert.ToDecimal(strCDropper), Convert.ToDecimal(strCtGrower), Convert.ToDecimal(srtCStopper), Convert.ToDecimal(strCNonUser),
//Convert.ToDecimal(strCNewUser), Convert.ToDecimal(strAvgFlat), Convert.ToDecimal(strAvgDropper),
// Convert.ToDecimal(srtAvgStopper), Convert.ToDecimal(strAvgGrower), Convert.ToDecimal(strAvgNonUser), Convert.ToDecimal(strAvgNewUser), timePeriods.strtp1, timePeriods.strtp2, strCurrentSegmentColumn, iIsActive);
}
}
// saving Opportunity Potentail
if (bIsPtnlModified)
{
clsTObj.fnSaveOPPPotential(Common.sOpportunityName, iOpportunityId, Common.strTableName, strPntlExpression);
}
}
catch (Exception ex)
{
throw ex;
}
}
private bool fnSaveThreshold(DataRow dr, string strTabName, int iProjectid)
{
try
{
string strPtnlFilter = "";
clsTObj.fnSaveTREThreShold(dr["T1"].ToString().Split(','), dr["T2"].ToString().Split(','), dr["OPP_NAME"].ToString(), dr["DROPPERS_CUTOFF"].ToString(), dr["GROWERS_CUTOFF"].ToString(), dr["STOPPERS_CUTOFF"].ToString(), int.Parse(dr["OPPORTUNITY_ID"].ToString()), strTabName, iProjectid, dr["ELGBL_FORMULA"].ToString(), true);
clsTObj.fnGetBaseData(strTabName, dr["GROWERS_CUTOFF"].ToString(), iProjectid);
if (dr["PTNL_FORMULA"].ToString() != "")
{
clsTObj.fnSaveOPPPotential(dr["OPP_NAME"].ToString(), int.Parse(dr["OPPORTUNITY_ID"].ToString()), strTabName, dr["PTNL_FORMULA"].ToString());
}
clsTObj.fnInsertOppValues(int.Parse(dr["OPPORTUNITY_ID"].ToString()));
return(true);
}
catch (Exception ex)
{
((OraDBManager)Common.dbMgr).RollbackTrans();
throw ex;
}
}
