protected void bindChart(int advisorBranchId, int branchHeadId, int all)
{
AdvisorBranchBo advisorBranchBo = new AdvisorBranchBo();
CustomerVo customerVo = new CustomerVo();
CustomerBo customerBo = new CustomerBo();
Legend Branchlegend = null;
Branchlegend = new Legend("BranchAssetsLegends");
Branchlegend.Enabled = true;
string[] XValues = null;
decimal[] YValues = null;
DataRow drChAssets;
DataRow drChvalues;
Series seriesBranchAssets = null;
seriesBranchAssets = new Series("seriesBranchAssets");
double DAssetvalue = 0;
int j = 0;
if (branchAumDT.Rows.Count > 0)
{
lblChartBranchAUM.Visible = true;
ErrorMessage.Visible = false;
drChvalues = branchAumDT.Rows[0];
for (int i = 0; i < branchAumDT.Columns.Count - 1; i++)
{
drChAssets = branchAumDT.NewRow();
branchAumDT.Rows.Add(drChAssets);
if (DAssetvalue == 0)
{
j = j + 1;
}
}
if (j != branchAumDT.Columns.Count)
{
seriesBranchAssets.ChartType = SeriesChartType.Pie;
//seriesBranchAssets1.Palette = ChartColorPalette.Chocolate;
//seriesBranchAssets.Palette = ChartColorPalette.Chocolate;
XValues = new string[10];
YValues = new decimal[10];
ChartBranchAssets.Series.Clear();
ChartBranchAssets.DataSource = branchAumDT;
//branchAumDT.DefaultView.Sort = "CurrentValue";
ChartBranchAssets.Series.Clear();
ChartBranchAssets.Series.Add(seriesBranchAssets);
ChartBranchAssets.Series[0].XValueMember = "Asset";
ChartBranchAssets.Series[0].XValueType = ChartValueType.String;
ChartBranchAssets.Series[0].YValueMembers = "CurrentValue";
ChartBranchAssets.Series["seriesBranchAssets"].IsValueShownAsLabel = true;
ChartBranchAssets.ChartAreas[0].AxisX.Title = "Assets";
ChartBranchAssets.Series[0].XValueMember = "Asset";
ChartBranchAssets.DataManipulator.Sort(PointSortOrder.Descending, "Y", seriesBranchAssets);
ChartBranchAssets.Legends.Add(Branchlegend);
ChartBranchAssets.Legends["BranchAssetsLegends"].Title = "Assets";
ChartBranchAssets.Legends["BranchAssetsLegends"].TitleAlignment = StringAlignment.Center;
ChartBranchAssets.Legends["BranchAssetsLegends"].TitleSeparator = LegendSeparatorStyle.None;
ChartBranchAssets.Legends["BranchAssetsLegends"].Alignment = StringAlignment.Center;
ChartBranchAssets.Legends["BranchAssetsLegends"].TitleSeparator = LegendSeparatorStyle.GradientLine;
ChartBranchAssets.Legends["BranchAssetsLegends"].TitleSeparatorColor = Color.Black;
ChartBranchAssets.Series[0]["PieLabelStyle"] = "Outside";
ChartBranchAssets.Series[0]["PieStartAngle"] = "10";
ChartArea chartArea1 = ChartBranchAssets.ChartAreas[0];
chartArea1.Area3DStyle.IsClustered = true;
chartArea1.Area3DStyle.Enable3D = true;
chartArea1.Area3DStyle.Perspective = 10;
chartArea1.Area3DStyle.PointGapDepth = 900;
chartArea1.Area3DStyle.IsRightAngleAxes = false;
chartArea1.Area3DStyle.WallWidth = 25;
chartArea1.Area3DStyle.Rotation = 65;
chartArea1.Area3DStyle.Inclination = 35;
chartArea1.BackColor = System.Drawing.Color.Transparent;
chartArea1.BackSecondaryColor = System.Drawing.Color.Transparent;
chartArea1.Position.Auto = true;
LegendCellColumn colorColumn = new LegendCellColumn();
colorColumn.ColumnType = LegendCellColumnType.SeriesSymbol;
colorColumn.HeaderBackColor = Color.WhiteSmoke;
ChartBranchAssets.Legends["BranchAssetsLegends"].CellColumns.Add(colorColumn);
ChartBranchAssets.Legends["BranchAssetsLegends"].BackColor = Color.FloralWhite;
LegendCellColumn totalColumn = new LegendCellColumn();
totalColumn.Alignment = ContentAlignment.MiddleLeft;
totalColumn.Text = "#VALX: #PERCENT";
totalColumn.Name = "AssetsColumn";
totalColumn.HeaderBackColor = Color.WhiteSmoke;
ChartBranchAssets.Legends["BranchAssetsLegends"].CellColumns.Add(totalColumn);
ChartBranchAssets.Series[0]["PieLabelStyle"] = "Disabled";
ChartBranchAssets.Series[0].ToolTip = "#VALX: #PERCENT";
ChartBranchAssets.ChartAreas[0].AxisX.Interval = 1;
ChartBranchAssets.ChartAreas[0].AxisY.Title = "Total Assets";
ChartBranchAssets.ChartAreas[0].Area3DStyle.Enable3D = true;
ChartBranchAssets.DataBind();
}
}
else
{
lblChartBranchAUM.Visible = false;
ErrorMessage.Visible = true;
ChartBranchAssets.DataSource = null;
ChartBranchAssets.Visible = false;
}
/* For Chart 2 */
if (topFiveRMDT.Rows.Count > 0)
{
lblTop5Rms.Visible = true;
DataRow drRMCustomersNet;
DataRow drRMCustomersNetResults;
Series seriesRMCustNetworth = null;
seriesRMCustNetworth = new Series("seriesRMCustNetworth");
Series seriesRMCustNetworth1 = null;
seriesRMCustNetworth1 = new Series("seriesRMCustNetworth");
Legend RMCustNetLegend = null;
Branchlegend = new Legend("legendsTopfiveRM");
seriesRMCustNetworth = new Series("CustomerNetworth");
RMCustNetLegend = new Legend("CustomerNetworthLegends");
RMCustNetLegend.Enabled = true;
XValues = new string[10];
YValues = new decimal[10];
drRMCustomersNet = topFiveRMDT.Rows[0];
CharttopfiveRMCustNetworth.Series.Clear();
CharttopfiveRMCustNetworth.Series.Add(seriesRMCustNetworth);
CharttopfiveRMCustNetworth.DataSource = topFiveRMDT.DefaultView;
topFiveRMDT.Columns.Add("RM Name");
for (int i = 0; i < topFiveRMDT.Rows.Count; i++)
{
drRMCustomersNet = topFiveRMDT.NewRow();
drRMCustomersNetResults = topFiveRMDT.Rows[i];
j = j + 1;
}
if (j != topFiveRMDT.Rows.Count)
{
seriesRMCustNetworth.ChartType = SeriesChartType.Bar;
//CharttopfiveRMCustNetworth.Titles.Add("Top 5 RMs (Customer Base)");
CharttopfiveRMCustNetworth.Series.Clear();
CharttopfiveRMCustNetworth.Series.Add(seriesRMCustNetworth);
CharttopfiveRMCustNetworth.Series[0].XValueMember = "RmName";
CharttopfiveRMCustNetworth.Series[0].XValueType = ChartValueType.String;
CharttopfiveRMCustNetworth.Series[0].YValueMembers = "Customer_networth";
CharttopfiveRMCustNetworth.Series["CustomerNetworth"].IsValueShownAsLabel = true;
CharttopfiveRMCustNetworth.ChartAreas[0].AxisX.Title = "RM Name";
CharttopfiveRMCustNetworth.ChartAreas[0].AxisX.LabelAutoFitStyle = LabelAutoFitStyles.WordWrap;
CharttopfiveRMCustNetworth.ChartAreas[0].AxisY.LabelAutoFitStyle = LabelAutoFitStyles.LabelsAngleStep90;
CharttopfiveRMCustNetworth.ChartAreas[0].AxisX.Interval = 1;
CharttopfiveRMCustNetworth.ChartAreas[0].AxisY.Title = "Customer NetWorth";
CharttopfiveRMCustNetworth.ChartAreas[0].Area3DStyle.Enable3D = true;
//CharttopfiveRMCustNetworth.Legends.Add(Branchlegend);
//CharttopfiveRMCustNetworth.Legends["legendsTopfiveRM"].Title = "Assets";
//CharttopfiveRMCustNetworth.Legends["legendsTopfiveRM"].TitleAlignment = StringAlignment.Center;
//CharttopfiveRMCustNetworth.Legends["legendsTopfiveRM"].TitleSeparator = LegendSeparatorStyle.None;
//CharttopfiveRMCustNetworth.Legends["legendsTopfiveRM"].Alignment = StringAlignment.Center;
//CharttopfiveRMCustNetworth.Legends["legendsTopfiveRM"].TitleSeparatorColor = Color.Black;
ChartArea custArea = ChartBranchAssets.ChartAreas[0];
custArea.Area3DStyle.Perspective = 10;
custArea.Area3DStyle.PointGapDepth = 900;
custArea.Area3DStyle.IsRightAngleAxes = false;
custArea.Area3DStyle.WallWidth = 25;
custArea.Area3DStyle.Rotation = 85;
custArea.Area3DStyle.Inclination = 35;
seriesRMCustNetworth.Palette = ChartColorPalette.Chocolate;
//seriesRMCustNetworth1.Palette = ChartColorPalette.Fire;
//seriesRMCustNetworth.Palette = ChartColorPalette.Pastel;
//seriesRMCustNetworth1.Palette = ChartColorPalette.Fire;
CharttopfiveRMCustNetworth.DataBind();
}
}
else
{
lblTop5Rms.Visible = false;
CharttopfiveRMCustNetworth.DataSource = null;
CharttopfiveRMCustNetworth.Visible = false;
}
/* *********** */
/* For Chart 3 */
if (topFiveCustomerDT.Rows.Count > 0)
{
chartCustNetworth.Visible = true;
DataRow drNetworth;
DataRow drNetworthResult;
Series seriesCustNetworth = null;
seriesCustNetworth = new Series("seriesCustNetworth");
Series seriesCustNetworth1 = null;
seriesCustNetworth1 = new Series("seriesCustNetworth");
Legend CustNetLegend = null;
Branchlegend = new Legend("legendCustomeAsset");
seriesCustNetworth = new Series("CustomerNetworth");
CustNetLegend = new Legend("CustomerNetworthLegends");
CustNetLegend.Enabled = true;
XValues = new string[10];
YValues = new decimal[10];
drNetworth = topFiveCustomerDT.Rows[0];
ChartCustomerNetworth.Series.Clear();
ChartCustomerNetworth.Series.Add(seriesCustNetworth);
ChartCustomerNetworth.DataSource = topFiveCustomerDT.DefaultView;
topFiveCustomerDT.Columns.Add("Customer Name");
for (int i = 0; i < topFiveCustomerDT.Rows.Count; i++)
{
drNetworth = topFiveCustomerDT.NewRow();
drNetworthResult = topFiveCustomerDT.Rows[i];
j = j + 1;
}
if (j != topFiveCustomerDT.Rows.Count)
{
seriesCustNetworth.ChartType = SeriesChartType.Bar;
ChartCustomerNetworth.Series.Clear();
ChartCustomerNetworth.Series.Add(seriesCustNetworth);
ChartCustomerNetworth.Series[0].XValueMember = "Customer";
ChartCustomerNetworth.Series[0].XValueType = ChartValueType.String;
ChartCustomerNetworth.Series[0].YValueMembers = "Networth";
ChartCustomerNetworth.Series["CustomerNetworth"].IsValueShownAsLabel = true;
ChartCustomerNetworth.ChartAreas[0].AxisX.Title = "Customer Name";
ChartCustomerNetworth.ChartAreas[0].AxisY.LabelAutoFitStyle = LabelAutoFitStyles.LabelsAngleStep90;
ChartCustomerNetworth.ChartAreas[0].AxisX.Interval = 1;
ChartCustomerNetworth.ChartAreas[0].AxisX.LabelAutoFitStyle = LabelAutoFitStyles.WordWrap;
ChartCustomerNetworth.ChartAreas[0].AxisX.LabelAutoFitMaxFontSize = 5;
ChartCustomerNetworth.ChartAreas[0].AxisY.Title = "Customer NetWorth";
ChartCustomerNetworth.ChartAreas[0].Area3DStyle.Enable3D = true;
ChartArea custArea = ChartBranchAssets.ChartAreas[0];
custArea.Area3DStyle.Perspective = 10;
custArea.Area3DStyle.PointGapDepth = 900;
custArea.Area3DStyle.IsRightAngleAxes = false;
custArea.Area3DStyle.WallWidth = 25;
custArea.Area3DStyle.Rotation = 65;
custArea.Area3DStyle.Inclination = 35;
//seriesCustNetworth.Palette = ChartColorPalette.Pastel;
seriesCustNetworth.Palette = ChartColorPalette.Chocolate;
ChartCustomerNetworth.DataBind();
}
}
else
{
chartCustNetworth.Visible = false;
ChartCustomerNetworth.DataSource = null;
ChartCustomerNetworth.Visible = false;
}
/* *********** */
}
/**************************** For Customer FP Asstet Chart *************************************/
protected void bindChart(int CustomerId)
{
Legend Branchlegend = null;
Branchlegend = new Legend("BranchAssetsLegends");
Branchlegend.Enabled = true;
string[] XValues = null;
decimal[] YValues = null;
DataRow drChAssets;
DataRow drChvalues;
Series seriesBranchAssets = null;
seriesBranchAssets = new Series("seriesBranchAssets");
double DAssetvalue = 0;
int j = 0;
if (dsFPAssetsAndLiabilitesDetails.Tables[0].Rows.Count > 0)
{
lblChartBranchAUM.Visible = true;
hrCustAsset.Visible = true;
ErrorMessage.Visible = false;
drChvalues = branchAumDT.Rows[0];
for (int i = 0; i < branchAumDT.Columns.Count - 1; i++)
{
drChAssets = branchAumDT.NewRow();
branchAumDT.Rows.Add(drChAssets);
if (DAssetvalue == 0)
{
j = j + 1;
}
}
if (j != branchAumDT.Columns.Count)
{
seriesBranchAssets.ChartType = SeriesChartType.Pie;
XValues = new string[10];
YValues = new decimal[10];
ChartBranchAssets.Series.Clear();
ChartBranchAssets.DataSource = branchAumDT;
ChartBranchAssets.Series.Clear();
ChartBranchAssets.Series.Add(seriesBranchAssets);
ChartBranchAssets.Series[0].XValueMember = "Asset";
ChartBranchAssets.Series[0].XValueType = ChartValueType.String;
ChartBranchAssets.Series[0].YValueMembers = "CurrentValue";
ChartBranchAssets.Series["seriesBranchAssets"].IsValueShownAsLabel = true;
ChartBranchAssets.ChartAreas[0].AxisX.Title = "Assets";
ChartBranchAssets.Series[0].XValueMember = "Asset";
ChartBranchAssets.DataManipulator.Sort(PointSortOrder.Descending, "Y", seriesBranchAssets);
ChartBranchAssets.Palette = ChartColorPalette.Pastel;
ChartBranchAssets.PaletteCustomColors = new Color[] { Color.LimeGreen, Color.Yellow, Color.LightBlue, Color.Purple, Color.Goldenrod, Color.Blue, Color.BurlyWood,
Color.Chocolate, Color.DeepPink, Color.Plum, Color.Violet, Color.Gainsboro, Color.Tomato, Color.Teal };
ChartBranchAssets.Legends.Add(Branchlegend);
ChartBranchAssets.Legends["BranchAssetsLegends"].Title = "Assets";
ChartBranchAssets.Legends["BranchAssetsLegends"].TitleAlignment = StringAlignment.Center;
ChartBranchAssets.Legends["BranchAssetsLegends"].TitleSeparator = LegendSeparatorStyle.None;
ChartBranchAssets.Legends["BranchAssetsLegends"].Alignment = StringAlignment.Center;
ChartBranchAssets.Legends["BranchAssetsLegends"].TitleSeparator = LegendSeparatorStyle.GradientLine;
ChartBranchAssets.Legends["BranchAssetsLegends"].TitleSeparatorColor = Color.Black;
//ChartBranchAssets.Legends["BranchAssetsLegends"].AutoFitMinFontSize
ChartBranchAssets.Series[0]["PieLabelStyle"] = "Outside";
ChartBranchAssets.Series[0]["PieStartAngle"] = "10";
ChartArea chartArea1 = ChartBranchAssets.ChartAreas[0];
chartArea1.Area3DStyle.IsClustered = true;
chartArea1.Area3DStyle.Enable3D = true;
chartArea1.Area3DStyle.Perspective = 10;
chartArea1.Area3DStyle.PointGapDepth = 900;
chartArea1.Area3DStyle.IsRightAngleAxes = false;
chartArea1.Area3DStyle.WallWidth = 25;
chartArea1.Area3DStyle.Rotation = 65;
chartArea1.Area3DStyle.Inclination = 35;
chartArea1.BackColor = System.Drawing.Color.Transparent;
chartArea1.BackSecondaryColor = System.Drawing.Color.Transparent;
chartArea1.Position.Auto = true;
LegendCellColumn colorColumn = new LegendCellColumn();
colorColumn.ColumnType = LegendCellColumnType.SeriesSymbol;
colorColumn.HeaderBackColor = Color.WhiteSmoke;
ChartBranchAssets.Legends["BranchAssetsLegends"].CellColumns.Add(colorColumn);
ChartBranchAssets.Legends["BranchAssetsLegends"].BackColor = Color.FloralWhite;
LegendCellColumn totalColumn = new LegendCellColumn();
totalColumn.Alignment = ContentAlignment.MiddleLeft;
totalColumn.Text = "#VALX: #PERCENT";
totalColumn.Name = "AssetsColumn";
totalColumn.HeaderBackColor = Color.WhiteSmoke;
ChartBranchAssets.Legends["BranchAssetsLegends"].CellColumns.Add(totalColumn);
ChartBranchAssets.Series[0]["PieLabelStyle"] = "Disabled";
ChartBranchAssets.Series[0].ToolTip = "#VALX: #PERCENT";
ChartBranchAssets.ChartAreas[0].AxisX.Interval = 1;
ChartBranchAssets.ChartAreas[0].AxisY.Title = "Total Assets";
ChartBranchAssets.ChartAreas[0].Area3DStyle.Enable3D = true;
ChartBranchAssets.DataBind();
}
}
else
{
lblChartBranchAUM.Visible = false;
hrCustAsset.Visible = false;
ErrorMessage.Visible = true;
ChartBranchAssets.DataSource = null;
ChartBranchAssets.Visible = false;
}
}
