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