//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")));
}
}