public void bindRadGrid1()
{
DataTable dtVariant = new DataTable();
DataSet dsVariantDetails = new DataSet();
DataTable dtModel = new DataTable();
ModelPortfolioBo modelPortfolioBo = new ModelPortfolioBo();
dsVariantDetails = modelPortfolioBo.GetVariantAssetPortfolioDetails(advisorVo.advisorId);
dtVariant.Columns.Add("XAMP_ModelPortfolioCode");
dtVariant.Columns.Add("XAMP_ModelPortfolioName");
dtVariant.Columns.Add("XAMP_ROR");
dtVariant.Columns.Add("XAMP_RiskPercentage");
DataRow drVariant;
foreach (DataRow dr in dsVariantDetails.Tables[0].Rows)
{
drVariant = dtVariant.NewRow();
drVariant["XAMP_ModelPortfolioCode"] = dr["XAMP_ModelPortfolioCode"].ToString();
drVariant["XAMP_ModelPortfolioName"] = dr["XAMP_ModelPortfolioName"].ToString();
drVariant["XAMP_ROR"] = dr["XAMP_ROR"].ToString();
drVariant["XAMP_RiskPercentage"] = dr["XAMP_RiskPercentage"].ToString();
dtVariant.Rows.Add(drVariant);
}
RadGrid1.DataSource = dtVariant;
RadGrid1.DataSourceID = String.Empty;
RadGrid1.DataBind();
}
public void bindRadGrid1()
{
DataTable dtRiskClass = new DataTable();
ModelPortfolioBo modelPortfolioBo = new ModelPortfolioBo();
//dtRiskClass = modelPortfolioBo.GetRiskGoalClassData(advisorVo.advisorId, Convert.ToInt16(ddlClassType.SelectedValue));
/***********Here ! is hard coded for riskClasses
* you can change it by binding the dropdown in future & make executable above commented line....Date(16/01/2012)
***************/
dtRiskClass = modelPortfolioBo.GetRiskGoalClassData(advisorVo.advisorId, 1);
DataTable dtClass = new DataTable();
dtClass.Columns.Add("XRC_RiskClass");
dtClass.Columns.Add("XRC_RiskClassCode");
dtClass.Columns.Add("ARC_RiskText");
DataRow drRiskClass;
foreach (DataRow dr in dtRiskClass.Rows)
{
drRiskClass = dtClass.NewRow();
drRiskClass["XRC_RiskClass"] = dr["XRC_RiskClass"].ToString();
drRiskClass["XRC_RiskClassCode"] = dr["XRC_RiskClassCode"].ToString();
drRiskClass["ARC_RiskText"] = dr["ARC_RiskText"].ToString();
dtClass.Rows.Add(drRiskClass);
}
RadGrid1.DataSource = dtClass;
RadGrid1.DataSourceID = String.Empty;
RadGrid1.DataBind();
}
public void bindRadGrid1()
{
DataTable dtVariant = new DataTable();
DataSet dsVariantDetails = new DataSet();
DataTable dtModel = new DataTable();
ModelPortfolioBo modelPortfolioBo = new ModelPortfolioBo();
DataRow[] drArrayAllocation;
dsVariantDetails = modelPortfolioBo.GetVariantAssetPortfolioDetails(advisorVo.advisorId);
dtVariant.Columns.Add("XAMP_ModelPortfolioCode");
dtVariant.Columns.Add("XAMP_ModelPortfolioName");
dtVariant.Columns.Add("XRC_RiskClass");
dtVariant.Columns.Add("XRC_RiskClassCode");
dtVariant.Columns.Add("XAMP_MinAUM");
dtVariant.Columns.Add("XAMP_MaxAUM");
dtVariant.Columns.Add("XAMP_MinAge");
dtVariant.Columns.Add("XAMP_MaxAge");
dtVariant.Columns.Add("XAMP_MinTimeHorizon");
dtVariant.Columns.Add("XAMP_MaxTimeHorizon");
dtVariant.Columns.Add("XAMP_Description");
dtVariant.Columns.Add("XAMP_CreatedOn");
dtVariant.Columns.Add("Allocation");
dtVariant.Columns.Add("Cash");
dtVariant.Columns.Add("Debt");
dtVariant.Columns.Add("Equity");
dtVariant.Columns.Add("Alternate");
dtVariant.Columns.Add("MinYear");
dtVariant.Columns.Add("MinMonth");
dtVariant.Columns.Add("MaxYear");
dtVariant.Columns.Add("MaxMonth");
dtVariant.Columns.Add("MinAUM");
dtVariant.Columns.Add("MaxAUM");
dtVariant.Columns.Add("XAMP_ROR");
dtVariant.Columns.Add("XAMP_RiskPercentage");
dtVariant.Columns.Add("XAMP_IsRiskModel");
//dtVariant.Columns.Add("Risk");
DataRow drVariant;
foreach (DataRow dr in dsVariantDetails.Tables[0].Rows)
{
drVariant = dtVariant.NewRow();
drVariant["XAMP_ModelPortfolioCode"] = dr["XAMP_ModelPortfolioCode"].ToString();
drVariant["XAMP_ModelPortfolioName"] = dr["XAMP_ModelPortfolioName"].ToString();
drVariant["XRC_RiskClass"] = dr["XRC_RiskClass"].ToString();
drVariant["XRC_RiskClassCode"] = dr["XRC_RiskClassCode"].ToString();
//dr["XAMP_MaxAUM"].ToString();
drVariant["XAMP_MinAge"] = dr["XAMP_MinAge"].ToString();
drVariant["XAMP_MaxAge"] = dr["XAMP_MaxAge"].ToString();
drVariant["XAMP_Description"] = dr["XAMP_Description"].ToString();
drVariant["XAMP_CreatedOn"] = DateTime.Parse(dr["XAMP_CreatedOn"].ToString()).ToShortDateString();
drVariant["Allocation"] = dr["Allocation"].ToString();
//drVariant["MinYear"] = Convert.ToInt32(dr["XAMP_MinTimeHorizon"].ToString()) / 12;
//drVariant["MinMonth"] = Convert.ToInt32(dr["XAMP_MinTimeHorizon"].ToString()) % 12;
//drVariant["MaxYear"] = Convert.ToInt32(dr["XAMP_MaxTimeHorizon"].ToString()) / 12;
//drVariant["MaxMonth"] = Convert.ToInt32(dr["XAMP_MaxTimeHorizon"].ToString()) % 12;
drArrayAllocation = new DataRow[dsVariantDetails.Tables[2].Rows.Count];
drArrayAllocation = dsVariantDetails.Tables[1].Select("XAMP_ModelPortfolioCode=" + dr["XAMP_ModelPortfolioCode"].ToString());
drVariant["Equity"] = drArrayAllocation[0][4];
drVariant["Debt"] = drArrayAllocation[1][4];
drVariant["Cash"] = drArrayAllocation[2][4];
drVariant["Alternate"] = drArrayAllocation[3][4];
drVariant["XAMP_ROR"] = dr["XAMP_ROR"].ToString();
drVariant["XAMP_RiskPercentage"] = dr["XAMP_RiskPercentage"].ToString();
if (dr["XAMP_IsRiskModel"].ToString() == "1")
{
drVariant["XAMP_IsRiskModel"] = "Risk Profile";
drVariant["XAMP_MinTimeHorizon"] = "N/A";
drVariant["XAMP_MaxTimeHorizon"] = "N/A";
drVariant["MinYear"] = "0";
drVariant["MinMonth"] = "0";
drVariant["MaxYear"] = "0";
drVariant["MaxMonth"] = "0";
drVariant["XAMP_MinAUM"] = "N/A";
drVariant["XAMP_MaxAUM"] = "N/A";
drVariant["MinAUM"] = "0";
drVariant["MaxAUM"] = "0";
}
else if (dr["XAMP_IsRiskModel"].ToString() == "0")
{
drVariant["XAMP_IsRiskModel"] = "Goal Profile";
drVariant["XAMP_MinTimeHorizon"] = dr["XAMP_MinTimeHorizon"].ToString();
drVariant["XAMP_MaxTimeHorizon"] = dr["XAMP_MaxTimeHorizon"].ToString();
drVariant["MinYear"] = Convert.ToInt32(dr["XAMP_MinTimeHorizon"].ToString()) / 12;
drVariant["MinMonth"] = Convert.ToInt32(dr["XAMP_MinTimeHorizon"].ToString());
drVariant["MaxYear"] = Convert.ToInt32(dr["XAMP_MaxTimeHorizon"].ToString()) / 12;
drVariant["MaxMonth"] = Convert.ToInt32(dr["XAMP_MaxTimeHorizon"].ToString());
drVariant["XAMP_MinAUM"] = Math.Round(Decimal.Parse(dr["XAMP_MinAUM"].ToString()), 0).ToString();
drVariant["XAMP_MaxAUM"] = Math.Round(Decimal.Parse(dr["XAMP_MaxAUM"].ToString()), 0).ToString();
drVariant["MinAUM"] = Math.Round(Decimal.Parse(dr["XAMP_MinAUM"].ToString()), 0).ToString();
drVariant["MaxAUM"] = Math.Round(Decimal.Parse(dr["XAMP_MaxAUM"].ToString()), 0).ToString();
}
dtVariant.Rows.Add(drVariant);
}
RadGrid1.DataSource = dtVariant;
RadGrid1.DataSourceID = String.Empty;
RadGrid1.DataBind();
}
