//function to populate the Asset Class wise Investments in the grid public void BindAssetInvestments() { DataTable dtAssetAggrCurrentValues = new DataTable(); double liabilityValue = 0; double networth = 0; try { dsAssetAggrCurrentValues = assetBo.GetPortfolioAssetAggregateCurrentValues(portfolioId); liabilityValue = assetBo.GetCustomerPortfolioLiability(portfolioId); if (dsAssetAggrCurrentValues.Tables[0].Rows.Count == 0 && liabilityValue == 0) { lblAssetDetailsMsg.Visible = true; } else { lblAssetDetailsMsg.Visible = false; dtAssetAggrCurrentValues.Columns.Add("Asset Class"); dtAssetAggrCurrentValues.Columns.Add("Current Value"); foreach (DataRow dr in dsAssetAggrCurrentValues.Tables[0].Rows) { if (double.Parse(dr["AggrCurrentValue"].ToString()) != 0) { drCurrentValues = dtAssetAggrCurrentValues.NewRow(); drCurrentValues[0] = dr["AssetType"].ToString(); drCurrentValues[1] = double.Parse(dr["AggrCurrentValue"].ToString()).ToString("n0", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN")); dtAssetAggrCurrentValues.Rows.Add(drCurrentValues); sum = sum + double.Parse(dr["AggrCurrentValue"].ToString()); } } //Adding Assets total to the data table to display in the gridview drCurrentValues = dtAssetAggrCurrentValues.NewRow(); drCurrentValues[0] = "Assets Total"; drCurrentValues[1] = double.Parse(sum.ToString()).ToString("n0", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));; dtAssetAggrCurrentValues.Rows.Add(drCurrentValues); //Adding Liabilities to the data table to display in the gridview drCurrentValues = dtAssetAggrCurrentValues.NewRow(); drCurrentValues[0] = "Liabilities"; drCurrentValues[1] = double.Parse(liabilityValue.ToString()).ToString("n0", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));; dtAssetAggrCurrentValues.Rows.Add(drCurrentValues); //Adding Net Worth to the data table to display in the gridview drCurrentValues = dtAssetAggrCurrentValues.NewRow(); drCurrentValues[0] = "Net Worth"; networth = sum - liabilityValue; drCurrentValues[1] = double.Parse(networth.ToString()).ToString("n0", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"));; dtAssetAggrCurrentValues.Rows.Add(drCurrentValues); gvAssetAggrCurrentValue.DataSource = dtAssetAggrCurrentValues; gvAssetAggrCurrentValue.DataBind(); gvAssetAggrCurrentValue.Visible = true; //networth = sum - liabilityValue; //lblAssets.Text = String.Format("{0:n2}", double.Parse(sum.ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); //lblLiabilityValue.Text = String.Format("{0:n2}", double.Parse(liabilityValue.ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); //lblNetWorth.Text = String.Format("{0:n2}", double.Parse(networth.ToString()).ToString("n2", System.Globalization.CultureInfo.CreateSpecificCulture("hi-IN"))); } } catch (BaseApplicationException Ex) { throw Ex; } catch (Exception Ex) { BaseApplicationException exBase = new BaseApplicationException(Ex.Message, Ex); NameValueCollection FunctionInfo = new NameValueCollection(); FunctionInfo.Add("Method", "AdvisorRMCustIndiDashboard.ascx:BindAssetInvestments()"); object[] objects = new object[2]; objects[0] = portfolioId; objects[1] = dsAssetAggrCurrentValues; FunctionInfo = exBase.AddObject(FunctionInfo, objects); exBase.AdditionalInformation = FunctionInfo; ExceptionManager.Publish(exBase); throw exBase; } }
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); BindMFChart(dsMFInv.Tables[1]); BindMFGrid(dsMFInv.Tables[0]); BindEQGrid(dsEquity.Tables[0]); //BindEQChart(); BindFIDashGrid(dsFI.Tables[0]); BindOtherAssetGrid(dsOtherAssets.Tables[0]); BindAssetChart(dsAssetChart); // 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"))); } }