private static string GetGraphExport(ChartFX.WebForms.Chart graph, ChartFX.WebForms.FileFormat format)
{
System.IO.Stream strm = new System.IO.MemoryStream(10000);
//sb.Append("pre-export" + strm.Length);
graph.Export(format, strm);
strm.Seek(0, System.IO.SeekOrigin.Begin);
int max = (int)strm.Length;
byte[] chrs = new byte[max];
strm.Read(chrs, 0, max);
return(Encoding.ASCII.GetString(chrs, 0, (int)strm.Length));
}
public override void DataBindGraph(ChartFX.WebForms.Chart graph, DataSet ds)
{
DataTable tbl = ds.Tables[0];
if (GlobalValues.HighSchoolCompletion.Key == HighSchoolCompletionKeys.All)
{//Stacked Bar Chart
List <String> myCols = new List <string>();
myCols.Add(barChart.LabelColumnName);
myCols.Add(v_HSCWWoDisSchoolDistStateEconELP.Regular_Diplomas);
myCols.Add(v_HSCWWoDisSchoolDistStateEconELP.HSEDs);
myCols.Add(v_HSCWWoDisSchoolDistStateEconELP.Certificates);
tbl = GraphBarChart.RemoveUnusedColumns(tbl, myCols);
//ds.Tables[0].Columns[v_HSCWWoDisSchoolDistStateEconELP.Regular_Diplomas].ColumnName = "Regular Diploma";
//ds.Tables[0].Columns[v_HSCWWoDisSchoolDistStateEconELP.HSEDs].ColumnName = "HSED";
//ds.Tables[0].Columns[v_HSCWWoDisSchoolDistStateEconELP.Certificates]
}
base.DataBindGraph(graph, tbl.DataSet);
}
/// <summary>
/// Assigns graph.DataSource and calls graph.DataBind()
/// </summary>
/// <param name="graph"></param>
/// <param name="ds"></param>
public virtual void DataBindGraph(ChartFX.WebForms.Chart graph, DataSet ds)
{
DataTable dt = new DataTable();
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
/*//trace To observe the raw Data Source
* if ((GlobalValues.TraceLevels & TraceStateUtils.TraceLevels.graph) == TraceStateUtils.TraceLevels.graph)
* {
* try
* {
* dt = ((DataView)ds.Tables[0].DefaultView).Table;
* }
* catch
* {
* dt = (DataTable)ds.Tables[0];
* }
* int i;
* int n;
* for (n = 0; n < dt.Columns.Count; n++)
* {
* Response.Write("N:" + dt.Columns[n].ColumnName + "|");
* Response.Write("T:" + dt.Rows[0].ItemArray[n].GetType().Name + "<br/>");
* }
* Response.Write("<br />");
* for (i = 0; i < dt.Rows.Count; i++)
* {
* for (n = 0; n < dt.Columns.Count; n++)
* {
* Response.Write(
* "V:" + dt.Rows[i].ItemArray[n] + "|"
* );
* }
* Response.Write("<br />");
* }
* }
* // end Trace*/
graph.DataSource = ds.Tables[0].DefaultView;
if ((GlobalValues.TraceLevels & TraceStateUtils.TraceLevels.graph) == TraceStateUtils.TraceLevels.graph && graph.DataSource != null)
{
Response.Write("<br />DataBindGraph(): graph.DataSource Assigned");
Response.Write("<br /> ds.Tables.[0].DefaultView.Count:" + ds.Tables[0].DefaultView.Count);
}
graph.DataBind();
if ((GlobalValues.TraceLevels & TraceStateUtils.TraceLevels.graph) == TraceStateUtils.TraceLevels.graph && graph.DataSource != null)
{
Response.Write("<br />DataBindGraph(): graph.DataBind() called;");
Response.Write("<br />graph.DataSource.GetType().Name:" + graph.DataSource.GetType().Name);
Response.Write("<br />");
try
{
dt = ((DataView)graph.DataSource).Table;
}
catch
{
dt = (DataTable)graph.DataSource;
}
int i;
int n;
for (n = 0; n < dt.Columns.Count; n++)
{
Response.Write("N:" + dt.Columns[n].ColumnName + "|");
if (dt.Rows.Count > 0)
{
Response.Write("T:" + dt.Rows[0].ItemArray[n].GetType().Name + "<br/>");
}
}
Response.Write("<br />");
if (dt.Rows.Count > 0)
{
for (i = 0; i < dt.Rows.Count; i++)
{
for (n = 0; n < dt.Columns.Count; n++)
{
Response.Write(
"V:" + dt.Rows[i].ItemArray[n] + "|"
);
}
Response.Write("<br />");
}
}
}
}
else
{
if ((GlobalValues.TraceLevels & TraceStateUtils.TraceLevels.graph) == TraceStateUtils.TraceLevels.graph)
{
Response.Write("<br />DataBindGraph: ds.Tables.Count NOT > 0");
}
}
}
