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