private void LoadChartsAndGrids() { DataSet dsAssetChart = new DataSet(); DataSet dsMFInv = new DataSet(); DataSet dsEquity = new DataSet(); DataSet dsFI = new DataSet(); DataSet dsOtherAssets = new DataSet(); DataSet dsMFInvestments = new DataSet(); DataSet dsEquityDirect = new DataSet(); DataSet dsNetIncomeSummary = new DataSet(); AssetBo assetsBo = new AssetBo(); double TotalAssetValue = 0.0F; double mfRealizedPL = 0; double mfDivIncome = 0; double mfSubTotal = 0; double eqSpecPL = 0; double eqDelivPL = 0; double eqDivIncome = 0; double eqSubTotal = 0; double assetTotal = 0; double divIncomeTotal = 0; // Bind Total Asset DataSet //dsAssetChart = assetsBo.GetPortfolioAssetAggregateCurrentValues(customerPortfolioVo.PortfolioId); dsAssetChart = assetsBo.GetPortfolioAssetAggregateCurrentValues(portfolioId); // Bind MF Investments DataSet dsMFInv = assetsBo.GetMFInvAggrCurrentValues(portfolioId, adviserId); // Bind Equity DataSet dsEquity = assetsBo.GetEQAggrCurrentValues(portfolioId, adviserId); // Bind FI Dashboard DataSet dsFI = assetsBo.GetFIGovtInsDashboardCurrentValues(portfolioId); // Bind Other Asset Dashboard DataSet dsOtherAssets = assetsBo.GetOtherAssetsDashboardCurrentValues(portfolioId); // Bind Net Income Summary dsNetIncomeSummary = assetsBo.GetNetIncomeSummary(portfolioId); //Bind Absolute Return DataSet DataSet dsAbsoluteReturn = assetsBo.GetAbsoluteReturnForAllAssetType(customerId, portfolioId); BindMFChart(dsMFInv.Tables[1]); BindMFGrid(dsMFInv.Tables[0]); BindEQGrid(dsEquity.Tables[0]); //BindEQChart(); BindFIDashGrid(dsFI.Tables[0]); BindOtherAssetGrid(dsOtherAssets.Tables[0]); BindAssetChart(dsAssetChart); BindAbsoluteReturn(dsAbsoluteReturn); // Bind Total Asset Labels if (dsAssetChart.Tables[0].Rows.Count > 0) { for (int i = 0; i < dsAssetChart.Tables[0].Rows.Count; i++) { TotalAssetValue += double.Parse(dsAssetChart.Tables[0].Rows[i]["AggrCurrentValue"].ToString()); } lblTotalAssetsValue.Text = String.Format("{0:n2}", decimal.Parse(TotalAssetValue.ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); } else { lblTotalAssetsValue.Text = String.Format("{0:n2}", decimal.Parse(TotalAssetValue.ToString())); } lblNetWorthValue.Text = String.Format("{0:n2}", decimal.Parse((TotalAssetValue - 0).ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); if (dsNetIncomeSummary.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsNetIncomeSummary.Tables[0].Rows) { if (dr["NetIncome"].ToString() == "MFRealizedPL") { mfRealizedPL = double.Parse(dr["AggrValue"].ToString()); } else if (dr["NetIncome"].ToString() == "Realised G/L - Deliv") { eqDelivPL = double.Parse(dr["AggrValue"].ToString()); } else if (dr["NetIncome"].ToString() == "Realised G/L - Spec") { eqSpecPL = double.Parse(dr["AggrValue"].ToString()); } else if (dr["NetIncome"].ToString() == "Dividend Income") { mfDivIncome = double.Parse(dr["AggrValue"].ToString()); } } mfSubTotal = mfRealizedPL; eqSubTotal = eqSpecPL + eqDelivPL; assetTotal = mfSubTotal + eqSubTotal; eqDivIncome = 0; divIncomeTotal = mfDivIncome + eqDivIncome; lblDividend.Text = String.Format("{0:n2}", mfDivIncome.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); lblMFRPLValue.Text = String.Format("{0:n2}", mfRealizedPL.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); lblMFSubTotalValue.Text = String.Format("{0:n2}", mfSubTotal.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); lblRealisedDeliv.Text = String.Format("{0:n2}", eqDelivPL.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); lblRealisedSpec.Text = String.Format("{0:n2}", eqSpecPL.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); lblEQSubTotalValue.Text = String.Format("{0:n2}", eqSubTotal.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); lblTotalValue.Text = String.Format("{0:n2}", assetTotal.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); lblEQDidvidend.Text = String.Format("{0:n2}", eqDivIncome.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); lblDivIncomeTotal.Text = String.Format("{0:n2}", divIncomeTotal.ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); } }