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