Org Header DB 2
Demonstrates using an organizational chart with styled headers and custom attributes populated from an existing user table by adding instance and parent IDs to establish the org hierarchy.
<%@ Page Language="C#" Trace="false" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>
<script runat="server">
void Page_Load(Object sender, EventArgs e)
{
// Demonstrates using an organizational chart with styled headers and custom attributes populated from an existing user table by adding instance and parent IDs to establish the org hierarchy.
// Set global properties
Chart.Type = ChartType.Organizational;
Chart.TempDirectory = "temp";
Chart.Debug = true;
Chart.Size = "500x600";
// Controls the padding of the annotations within the chart area
Chart.ChartArea.Padding = 30;
//Chart.ChartArea.Background.ShadingEffectMode = ShadingEffectMode.Five;
Chart.ChartArea.Background.Color = Color.FromArgb(120, Color.FromArgb(180, 200, 224));
// TitleBox Customization
Chart.TitleBox.Label.Text = " Acme Company's Organizational Chart";
Chart.TitleBox.Label.Color = Color.White;
//Chart.TitleBox.Label.Shadow.Color = Color.FromArgb(105, 0, 0, 0);
Chart.TitleBox.Position = TitleBoxPosition.Full;
Chart.TitleBox.Label.Font = new Font("Tahoma", 10,FontStyle.Bold);
//Chart.TitleBox.Background.ShadingEffectMode = ShadingEffectMode.Two;
Chart.TitleBox.Background.Color = Color.SteelBlue;
// Set the org line style
Chart.DefaultSeries.Line.Width = 5;
Chart.DefaultSeries.Line.Color = Color.DarkGray;
// Set the org annotation visual appearance, shading and layout
Chart.DefaultElement.Annotation = new Annotation();
Chart.DefaultElement.Annotation.DynamicSize = false;
Chart.DefaultElement.Annotation.Label.Alignment = StringAlignment.Center;
Chart.DefaultElement.Annotation.Background.ShadingEffectMode = ShadingEffectMode.Seven;
Chart.DefaultElement.Annotation.Background.Color = Chart.Palette[2];
Chart.DefaultElement.Annotation.Padding = 5;
Chart.DefaultElement.Annotation.Label.Text = "<img:../../images/Org%picture><block halign='right'>%Department<br>%Email<br>%phone<br>Office #%office";
Chart.DefaultElement.Annotation.HeaderLabel = new dotnetCHARTING.Label("%name", new Font("Arial", 11, FontStyle.Bold), Color.White);
Chart.DefaultElement.Annotation.HeaderBackground.ShadingEffectMode = ShadingEffectMode.Two;
Chart.DefaultElement.Annotation.Shadow.Color = Color.Gray;
Chart.DefaultElement.Annotation.HeaderLabel.Shadow.Depth = 3;
Chart.DefaultElement.Annotation.HeaderBackground.Color = Color.FromArgb(183, 176, 39);
Chart.DefaultElement.Annotation.HeaderBackground.Color = Color.FromArgb(36, 168, 187);
// Default Annotation Header Styling
BoxHeaderOptions head = Chart.DefaultElement.Annotation.Header;
head.Label.Alignment = StringAlignment.Center;
head.StartCap = BoxCapStyle.CutUp;
head.EndCap = BoxCapStyle.Box;
head.StartAlignment = EdgeAlignment.Inside;
head.Offset = new Point(4, 5);
head.Shadow.Color = Color.FromArgb(100, Color.Gray);
head.Shadow.Soft = false;
// Obtain series data from the database. Note this was created by adding PID (parentid)
// to an existing table only, then populating the parentid based on the hiearchy in place.
DataEngine de = new DataEngine(ConfigurationManager.AppSettings["DNCConnectionString"]);
de.SqlStatement = @"SELECT * FROM Employees";
de.SqlStatement += " WHERE Name LIKE 'Aida' OR Name LIKE 'Ain' OR Name LIKE 'John' OR Name LIKE 'George' OR Name LIKE 'Lori' ";
de.DataFields = "InstanceID=ID,InstanceParentID=PID,Name=Name,office,Department,Email,Phone,Picture";
Chart.SeriesCollection.Add(de.GetSeries());
}
</script>
<html>
<head>
<title>Database Driven Organizational Chart</title>
</head>
<body>
<div style="text-align: center">
<dotnet:Chart ID="Chart" runat="server" />
</div>
</body>
</html>
<%@ Page Language="vb" Trace="false" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>
<script runat="server">
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' Demonstrates using an organizational chart with styled headers and custom attributes populated from an existing user table by adding instance and parent IDs to establish the org hierarchy.
' Set global properties
Chart.Type = ChartType.Organizational
Chart.TempDirectory = "temp"
Chart.Debug = True
Chart.Size = "500x600"
' Controls the padding of the annotations within the chart area
Chart.ChartArea.Padding = 30
'Chart.ChartArea.Background.ShadingEffectMode = ShadingEffectMode.Five;
Chart.ChartArea.Background.Color = Color.FromArgb(120, Color.FromArgb(180, 200, 224))
' TitleBox Customization
Chart.TitleBox.Label.Text = " Acme Company's Organizational Chart"
Chart.TitleBox.Label.Color = Color.White
'Chart.TitleBox.Label.Shadow.Color = Color.FromArgb(105, 0, 0, 0);
Chart.TitleBox.Position = TitleBoxPosition.Full
Chart.TitleBox.Label.Font = New Font("Tahoma", 10,FontStyle.Bold)
'Chart.TitleBox.Background.ShadingEffectMode = ShadingEffectMode.Two;
Chart.TitleBox.Background.Color = Color.SteelBlue
' Set the org line style
Chart.DefaultSeries.Line.Width = 5
Chart.DefaultSeries.Line.Color = Color.DarkGray
' Set the org annotation visual appearance, shading and layout
Chart.DefaultElement.Annotation = New Annotation()
Chart.DefaultElement.Annotation.DynamicSize = False
Chart.DefaultElement.Annotation.Label.Alignment = StringAlignment.Center
Chart.DefaultElement.Annotation.Background.ShadingEffectMode = ShadingEffectMode.Seven
Chart.DefaultElement.Annotation.Background.Color = Chart.Palette(2)
Chart.DefaultElement.Annotation.Padding = 5
Chart.DefaultElement.Annotation.Label.Text = "<img:../../images/Org%picture><block halign='right'>%Department<br>%Email<br>%phone<br>Office #%office"
Chart.DefaultElement.Annotation.HeaderLabel = New dotnetCHARTING.Label("%name", New Font("Arial", 11, FontStyle.Bold), Color.White)
Chart.DefaultElement.Annotation.HeaderBackground.ShadingEffectMode = ShadingEffectMode.Two
Chart.DefaultElement.Annotation.Shadow.Color = Color.Gray
Chart.DefaultElement.Annotation.HeaderLabel.Shadow.Depth = 3
Chart.DefaultElement.Annotation.HeaderBackground.Color = Color.FromArgb(183, 176, 39)
Chart.DefaultElement.Annotation.HeaderBackground.Color = Color.FromArgb(36, 168, 187)
' Default Annotation Header Styling
Dim head As BoxHeaderOptions = Chart.DefaultElement.Annotation.Header
head.Label.Alignment = StringAlignment.Center
head.StartCap = BoxCapStyle.CutUp
head.EndCap = BoxCapStyle.Box
head.StartAlignment = EdgeAlignment.Inside
head.Offset = New Point(4, 5)
head.Shadow.Color = Color.FromArgb(100, Color.Gray)
head.Shadow.Soft = False
' Obtain series data from the database. Note this was created by adding PID (parentid)
' to an existing table only, then populating the parentid based on the hiearchy in place.
Dim de As DataEngine = New DataEngine(ConfigurationManager.AppSettings("DNCConnectionString"))
de.SqlStatement = "SELECT * FROM Employees"
de.SqlStatement &= " WHERE Name LIKE 'Aida' OR Name LIKE 'Ain' OR Name LIKE 'John' OR Name LIKE 'George' OR Name LIKE 'Lori' "
de.DataFields = "InstanceID=ID,InstanceParentID=PID,Name=Name,office,Department,Email,Phone,Picture"
Chart.SeriesCollection.Add(de.GetSeries())
End Sub
</script>
<html>
<head>
<title>Database Driven Organizational Chart</title>
</head>
<body>
<div style="text-align: center">
<dotnet:Chart ID="Chart" runat="server" />
</div>
</body>
</html>
Previous