public CurrentStatusCalculation GetAllCurrestStatus(int plannerId) { try { FinancialPlanner.Common.JSONSerialization jsonSerialization = new FinancialPlanner.Common.JSONSerialization(); string apiurl = Program.WebServiceUrl + "/" + string.Format(GET_ALL_CURRENT_STATUS_API, plannerId); RestAPIExecutor restApiExecutor = new RestAPIExecutor(); var restResult = restApiExecutor.Execute <IList <CurrentStatusCalculation> >(apiurl, null, "GET"); if (jsonSerialization.IsValidJson(restResult.ToString())) { csCal = jsonSerialization.DeserializeFromString <CurrentStatusCalculation>(restResult.ToString()); } return(csCal); } catch (Exception ex) { StackTrace st = new StackTrace(); StackFrame sf = st.GetFrame(0); MethodBase currentMethodName = sf.GetMethod(); LogDebug(currentMethodName.Name, ex); return(null); } }
public double GetFundFromCurrentStatus(int plannerId, int goalId = 0) { CurrentStatusCalculation csCal = GetCurrestStatusWithoutGoalMapped(plannerId, goalId); if (csCal != null) { double totalEquityAmount = csCal.ShresValue + csCal.EquityMFvalue + csCal.NpsEquityValue + csCal.OtherEquityValue; double totalDebtAmount = csCal.DebtMFValue + csCal.FdValue + csCal.RdValue + csCal.SaValue + csCal.NpsDebtValue + csCal.PPFValue + csCal.EPFValue + csCal.SSValue + csCal.SCSSValue + csCal.BondsValue + csCal.OtherDebtValue; double totalGoldAmount = csCal.GoldValue + csCal.OthersGoldValue; double totalCurrentStatusAmount = totalEquityAmount + totalDebtAmount + totalGoldAmount; return(totalCurrentStatusAmount); } return(0); }
public CurrentStatusCalculation GetAllCurrentStatusAmount(int plannerId) { CurrentStatusCalculation csCal = new CurrentStatusCalculation(); #region "Shares" //Shares double sharesValue = 0; string returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_SHARES_VALUE, plannerId)); double.TryParse(returnvalue, out sharesValue); csCal.ShresValue = sharesValue; #endregion #region "MF" //MF double equityMFValue = 0; double debtMFValue = 0; double goldMFValue = 0; DataTable dtMF = DataBase.DBService.ExecuteCommand(string.Format(GET_ALL_EQUITY_VALUE, plannerId)); if (dtMF != null && dtMF.Rows.Count > 0) { double.TryParse(dtMF.Rows[0]["EQUITYMFSHARES"].ToString(), out equityMFValue); double.TryParse(dtMF.Rows[0]["DEBTMFSHARES"].ToString(), out debtMFValue); double.TryParse(dtMF.Rows[0]["GOLDMFSHARES"].ToString(), out goldMFValue); } csCal.EquityMFvalue = equityMFValue; csCal.DebtMFValue = debtMFValue; csCal.OthersGoldValue = csCal.OthersGoldValue + goldMFValue; #endregion #region "NPS" //NPS double equityNPSValue = 0; double debtNPSValue = 0; double goldNPSValue = 0; DataTable dtNPS = DataBase.DBService.ExecuteCommand(string.Format(GET_ALL_EQUITY_NPS_VALUE, plannerId)); if (dtNPS != null && dtNPS.Rows.Count > 0) { double.TryParse(dtNPS.Rows[0]["EQUITYNPSSHARES"].ToString(), out equityNPSValue); double.TryParse(dtNPS.Rows[0]["DEBTNPSSHARES"].ToString(), out debtNPSValue); double.TryParse(dtNPS.Rows[0]["GOLDNPSSHARES"].ToString(), out goldNPSValue); } csCal.NpsEquityValue = equityNPSValue; csCal.NpsDebtValue = debtNPSValue; csCal.OthersGoldValue = csCal.OthersGoldValue + goldNPSValue; #endregion #region "Ulip" //NPS double equityUlipValue = 0; double debtUlipValue = 0; double goldUlipValue = 0; DataTable dtUlip = DataBase.DBService.ExecuteCommand(string.Format(GET_ALL_EQUITY_ULIP_VALUE, plannerId)); if (dtUlip != null && dtUlip.Rows.Count > 0) { double.TryParse(dtUlip.Rows[0]["EQUITYULIPSHARES"].ToString(), out equityUlipValue); double.TryParse(dtUlip.Rows[0]["DEBTULIPSHARES"].ToString(), out debtUlipValue); double.TryParse(dtUlip.Rows[0]["GOLDULIPSHARES"].ToString(), out goldUlipValue); } csCal.UlipEquityValue = equityUlipValue; csCal.UlipDebtValue = debtUlipValue; csCal.OthersGoldValue = csCal.OthersGoldValue + goldUlipValue; #endregion #region "Others Equity" double equityOtherValue = 0; DataTable dtOthersEquity = DataBase.DBService.ExecuteCommand(string.Format(GET_ALL_EQUITY_OTHERS_VALUE, plannerId)); if (dtOthersEquity != null && dtOthersEquity.Rows.Count > 0) { double.TryParse(dtOthersEquity.Rows[0]["EQUITYOTHERS"].ToString(), out equityOtherValue); //double.TryParse(dtOthersEquity.Rows[0]["DEBTNPSSHARES"].ToString(), out debtNPSValue); } csCal.OtherEquityValue = equityOtherValue; //csCal.NpsDebtValue = debtNPSValue; #endregion #region "DEBT" #region "RD" //RD double rdValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_RD_VALUE, plannerId)); double.TryParse(returnvalue, out rdValue); csCal.RdValue = rdValue; #endregion #region "FD" //FD double fdValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_FD_VALUE, plannerId)); double.TryParse(returnvalue, out fdValue); csCal.FdValue = fdValue; #endregion #region "Saving Account" //SA double saValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_SA_VALUE, plannerId)); double.TryParse(returnvalue, out saValue); csCal.SaValue = saValue; #endregion #region "PPF" //PPF double ppfValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_PPF_VALUE, plannerId)); double.TryParse(returnvalue, out ppfValue); csCal.PPFValue = ppfValue; #endregion #region "EPF" //EPF double epfValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_EPF_VALUE, plannerId)); double.TryParse(returnvalue, out epfValue); csCal.EPFValue = epfValue; #endregion #region "Others" //Others double othersValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_OTHERS_DEBT_VALUE, plannerId)); double.TryParse(returnvalue, out othersValue); csCal.OtherDebtValue = othersValue; #endregion #region "SS" //Sukanya Samrudhi double ssValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_SS_VALUE, plannerId)); double.TryParse(returnvalue, out ssValue); csCal.SSValue = ssValue; #endregion #region "SCSS" //SCSS double scssValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_SCSS_VALUE, plannerId)); double.TryParse(returnvalue, out scssValue); csCal.SCSSValue = scssValue; #endregion #region "NSC" //NSC double nscValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_NSC_VALUE, plannerId)); double.TryParse(returnvalue, out nscValue); csCal.NscValue = nscValue; #endregion #region "Bonds" double bondsValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_BONDS_VALUE, plannerId)); double.TryParse(returnvalue, out bondsValue); csCal.BondsValue = bondsValue; #endregion #region "Others Gold" double goldOthersValue = 0; returnvalue = DataBase.DBService.ExecuteCommandScalar(string.Format(GET_ALL_OTHERS_GOLD_VALUE, plannerId)); double.TryParse(returnvalue, out goldOthersValue); csCal.GoldValue = goldOthersValue; #endregion #endregion return(csCal); }
private void getCurrentStatus() { _csCal = _csInfo.GetAllCurrestStatus(_planeId); fillCurrentStatusData(); //fillCurrentStatusToGoalData(); }