public static DataSetMultiSeries DataTableToChartDataSet(System.Data.DataTable dt, int category_col,
IList <int> val_cols, bool exclude_dbnull_values)
{
var dt_cat_col = dt.Columns[category_col];
CheckCatCol(dt_cat_col);
foreach (int val_col in val_cols)
{
var dt_val_col = dt.Columns[val_col];
CheckValCol(dt_val_col);
}
var list_of_series = new List <SeriesDataPoints>();
foreach (int val_col in val_cols)
{
list_of_series.Add(new SeriesDataPoints());
}
var cats = new HashSet <string>();
foreach (System.Data.DataRow row in dt.Rows)
{
var items = row.ItemArray;
string cat = (string)items[category_col];
cats.Add(cat);
for (int i = 0; i < val_cols.Count; i++)
{
int val_col = val_cols[i];
var ser = list_of_series[i];
var dt_val_col = dt.Columns[val_col];
object o = items[val_col];
// exclude dbnull values
var ot = o.GetType();
if (exclude_dbnull_values && ot == typeof(System.DBNull))
{
continue;
}
double val = GetVal(dt_val_col, o);
var dp = new DataPoint(val);
ser.Add(dp);
}
}
var axislabels = new WebCharting.Data.AxisLabels(cats);
var cd = new DataSetMultiSeries(list_of_series, axislabels);
return(cd);
}
public static WebCharting.Data.DataSetSingleSeries WidgetsByMonth()
{
var values_raw = new double[] { 32, 25, 19, 31, 43, 36, 51, 38, 29, 59, 68, 29, 38, 40, 48 };
var values = DemoData.DoublesToDataPoints(values_raw);
var months = GetLastNMonths(values.Count).Select(i => i.ToString("M/y"));
var labels = new WebCharting.Data.AxisLabels(months);
var chartdata = new WebCharting.Data.DataSetSingleSeries(values, labels);
return(chartdata);
}
public static WebCharting.Data.DataSetSingleSeries GetSingleSeriesPalette()
{
var pal = PaletteBuilder.GetDefaultPalette();
var items = pal.Select( i=> new WebCharting.Data.DataPoint(1.0));
var values = new WebCharting.Data.SeriesDataPoints(items);
var axislabels = new
WebCharting.Data.AxisLabels(
pal.Select(i => i.Color.ToWebColorString()));
var chartdata = new WebCharting.Data.DataSetSingleSeries(values, axislabels);
return chartdata;
}
public static WebCharting.Data.DataSetSingleSeries GetSingleSeriesPalette()
{
var pal = PaletteBuilder.GetDefaultPalette();
var items = pal.Select(i => new WebCharting.Data.DataPoint(1.0));
var values = new WebCharting.Data.SeriesDataPoints(items);
var axislabels = new
WebCharting.Data.AxisLabels(
pal.Select(i => i.Color.ToWebColorString()));
var chartdata = new WebCharting.Data.DataSetSingleSeries(values, axislabels);
return(chartdata);
}
public static WebCharting.Data.DataSetSingleSeries GetSingleSeries3()
{
var values_raw = new double[] { 32, 25, 19, 31, 43, 36 };
var values = DemoData.DoublesToDataPoints(values_raw);
var today = System.DateTime.Now;
var start = today.AddDays(-values.Count);
var labels =
new WebCharting.Data.AxisLabels(
Enumerable.Range(0, values.Count).Select(i => start.AddDays(i).ToString("M/d")));
var chartdata = new WebCharting.Data.DataSetSingleSeries(values, labels);
return(chartdata);
}
public static WebCharting.Data.DataSetSingleSeries GetSingleSeries2()
{
var types = typeof(System.String).Assembly.GetExportedTypes()
.Where(t => t.IsClass)
.Where(t => t.IsPublic);
var data =
types.Select(
t =>
new
{
typename = t.Name,
typefullname = t.FullName,
nummethods = t.GetMethods().Length,
numprops = t.GetProperties().Length
});
int topn = 5;
var final_data = (from p in data
orderby p.nummethods descending
select p).Take(topn).ToList();
var datapoints = new WebCharting.Data.SeriesDataPoints();
var labels = new WebCharting.Data.AxisLabels();
for (int i = 0; i < final_data.Count; i++)
{
var datum = final_data[i];
string dp_hlink = string.Format("http://msdn.microsoft.com/en-us/library/{0}.aspx", datum.typefullname);
var dp_label = datum.nummethods.ToString();
var dp_value = datum.nummethods;
var dp = new WebCharting.Data.DataPoint(dp_value, dp_hlink, dp_label);
dp.Label = datum.nummethods.ToString();
datapoints.Add(dp);
labels.Add(datum.typename);
}
var chartdata = new WebCharting.Data.DataSetSingleSeries(datapoints, labels);
return(chartdata);
}
protected void AddNewSeriesHorizLine(MSCHART.Chart chart, WebCharting.Data.SeriesDataPoints datapoints, WebCharting.Data.AxisLabels labels)
{
var ser = new MSCHART.Series();
ser.Points.DataBindXY(labels.ToArray(), datapoints.GetDoubleArray());
if (datapoints.Name != null)
{
ser.LegendText = datapoints.Name;
}
for (int i = 0; i < datapoints.Count; i++)
{
var chart_datapoint = ser.Points[i];
var v = datapoints[i];
}
chart.Series.Add(ser);
}
protected void AddNewSeries(MSCHART.Chart chart, WebCharting.Data.SeriesDataPoints datapoints, WebCharting.Data.AxisLabels labels)
{
var ser = new MSCHART.Series();
ser.Points.DataBindXY(labels.ToArray(), datapoints.GetDoubleArray());
if (datapoints.Name != null)
{
ser.LegendText = datapoints.Name;
}
for (int i = 0; i < datapoints.Count; i++)
{
var chart_datapoint = ser.Points[i];
var v = datapoints[i];
if (v.ToolTip != null && v.ToolTip.Text != null)
{
chart_datapoint.ToolTip = v.ToolTip.Text;
}
if (v.Hyperlink != null)
{
chart_datapoint.Url = v.Hyperlink;
}
}
if (datapoints.Hyperlink != null)
{
ser.Url = datapoints.Hyperlink;
}
if (datapoints.ToolTip != null && datapoints.ToolTip.Text != null)
{
ser.ToolTip = datapoints.ToolTip.Text;
}
chart.Series.Add(ser);
}
public static DataSetMultiSeries DataTableToChartDataSet(System.Data.DataTable dt, int category_col,
IList<int> val_cols, bool exclude_dbnull_values)
{
var dt_cat_col = dt.Columns[category_col];
CheckCatCol(dt_cat_col);
foreach (int val_col in val_cols)
{
var dt_val_col = dt.Columns[val_col];
CheckValCol(dt_val_col);
}
var list_of_series = new List<SeriesDataPoints>();
foreach (int val_col in val_cols)
{
list_of_series.Add( new SeriesDataPoints());
}
var cats = new HashSet<string>();
foreach (System.Data.DataRow row in dt.Rows)
{
var items = row.ItemArray;
string cat = (string)items[category_col];
cats.Add(cat);
for (int i = 0; i < val_cols.Count;i++ )
{
int val_col = val_cols[i];
var ser = list_of_series[i];
var dt_val_col = dt.Columns[val_col];
object o = items[val_col];
// exclude dbnull values
var ot = o.GetType();
if (exclude_dbnull_values && ot == typeof(System.DBNull))
{
continue;
}
double val = GetVal(dt_val_col, o);
var dp = new DataPoint(val);
ser.Add(dp);
}
}
var axislabels = new WebCharting.Data.AxisLabels(cats);
var cd = new DataSetMultiSeries( list_of_series, axislabels);
return cd;
}
public static DataSetMultiSeries DataTableToChartDataSet(System.Data.DataTable dt, int category_col, int val_col,
int series_col, bool exclude_dbnull_values)
{
var dt_cat_col = dt.Columns[category_col];
var dt_val_col = dt.Columns[val_col];
var dt_ser_col = dt.Columns[series_col];
CheckCatCol(dt_cat_col);
CheckValCol(dt_val_col);
CheckSerCol(dt_ser_col);
var ser_to_values = new Dictionary<string, Dictionary<string,double>>();
var cats = new HashSet<string>();
foreach (System.Data.DataRow row in dt.Rows)
{
var items = row.ItemArray;
string cat = (string)items[category_col];
object o = items[val_col];
// exclude dbnull values
var ot = o.GetType();
if (exclude_dbnull_values && ot == typeof(System.DBNull))
{
continue;
}
cats.Add(cat);
}
foreach (System.Data.DataRow row in dt.Rows)
{
var items = row.ItemArray;
string cat = (string) items[category_col];
string ser = (string) items[series_col];
object o = items[val_col];
// exclude dbnull values
var ot = o.GetType();
if (exclude_dbnull_values && ot == typeof(System.DBNull))
{
continue;
}
double val = GetVal(dt_val_col, o);
if (!ser_to_values.ContainsKey(ser))
{
ser_to_values[ser] = new Dictionary<string, double>(cats.Count);
}
var ser_list = ser_to_values[ser];
ser_list[cat]=val;
}
var list_of_series = new List<SeriesDataPoints>();
foreach (var ser_list in ser_to_values.Values)
{
var sdp = new SeriesDataPoints();
foreach (string cat in cats)
{
// Try to find a value for each category
if (ser_list.ContainsKey(cat))
{
double v = ser_list[cat];
var dp = new DataPoint(v);
sdp.Add(dp);
}
else
{
double v = 0.0;
var dp = new DataPoint(v);
sdp.Add(dp);
}
}
}
var axislabels = new WebCharting.Data.AxisLabels(cats);
var cd = new DataSetMultiSeries(list_of_series, axislabels);
return cd;
}
public static WebCharting.Data.DataSetSingleSeries WidgetsByMonth()
{
var values_raw = new double[] { 32, 25, 19, 31, 43, 36, 51, 38, 29, 59, 68, 29, 38, 40, 48 };
var values = DemoData.DoublesToDataPoints(values_raw);
var months = GetLastNMonths(values.Count).Select(i => i.ToString("M/y"));
var labels = new WebCharting.Data.AxisLabels(months);
var chartdata = new WebCharting.Data.DataSetSingleSeries(values, labels);
return chartdata;
}
public static WebCharting.Data.DataSetMultiSeries GetMultiSeries1()
{
var datapoints0 = new WebCharting.Data.SeriesDataPoints(new double[]
{
32,
25,
19,
31,
43,
36,
51,
38,
29,
31,
57,
29,
38,
40,
48
});
datapoints0.Hyperlink = "http://google.com";
datapoints0.ToolTip = new ToolTip("Google");
datapoints0.Name = "Google";
var datapoints1 = new WebCharting.Data.SeriesDataPoints(new double[]
{
56,
45,
70,
75,
65,
59,
55,
51,
40,
34,
45,
39,
33,
31,
19
});
datapoints1.Hyperlink = "http://yahoo.com";
datapoints1.ToolTip = new ToolTip("Yahoo");
datapoints1.Name = "Yahoo";
var values = new List<WebCharting.Data.SeriesDataPoints> { datapoints0, datapoints1 };
var today = System.DateTime.Now;
var start = today.AddDays(-datapoints0.Count);
var labels =
new WebCharting.Data.AxisLabels(
Enumerable.Range(0, datapoints0.Count).Select(i => start.AddDays(i).ToString("M/d")));
var chartdata = new WebCharting.Data.DataSetMultiSeries(values, labels);
return chartdata;
}
public static WebCharting.Data.DataSetSingleSeries GetSingleSeries2()
{
var types = typeof (System.String).Assembly.GetExportedTypes()
.Where(t => t.IsClass)
.Where(t => t.IsPublic);
var data =
types.Select(
t =>
new
{
typename = t.Name,
typefullname = t.FullName,
nummethods = t.GetMethods().Length,
numprops = t.GetProperties().Length
});
int topn = 5;
var final_data = (from p in data
orderby p.nummethods descending
select p).Take(topn).ToList();
var datapoints = new WebCharting.Data.SeriesDataPoints();
var labels = new WebCharting.Data.AxisLabels();
for (int i = 0; i < final_data.Count; i++)
{
var datum = final_data[i];
string dp_hlink = string.Format("http://msdn.microsoft.com/en-us/library/{0}.aspx", datum.typefullname);
var dp_label = datum.nummethods.ToString();
var dp_value = datum.nummethods;
var dp = new WebCharting.Data.DataPoint(dp_value, dp_hlink, dp_label);
dp.Label = datum.nummethods.ToString();
datapoints.Add(dp);
labels.Add(datum.typename);
}
var chartdata = new WebCharting.Data.DataSetSingleSeries(datapoints, labels);
return chartdata;
}
public static WebCharting.Data.DataSetSingleSeries GetSingleSeries3()
{
var values_raw = new double[] { 32, 25, 19, 31, 43, 36};
var values = DemoData.DoublesToDataPoints(values_raw);
var today = System.DateTime.Now;
var start = today.AddDays(-values.Count);
var labels =
new WebCharting.Data.AxisLabels(
Enumerable.Range(0, values.Count).Select(i => start.AddDays(i).ToString("M/d")));
var chartdata = new WebCharting.Data.DataSetSingleSeries(values, labels);
return chartdata;
}
public static DataSetMultiSeries DataTableToChartDataSet(System.Data.DataTable dt, int category_col, int val_col,
int series_col, bool exclude_dbnull_values)
{
var dt_cat_col = dt.Columns[category_col];
var dt_val_col = dt.Columns[val_col];
var dt_ser_col = dt.Columns[series_col];
CheckCatCol(dt_cat_col);
CheckValCol(dt_val_col);
CheckSerCol(dt_ser_col);
var ser_to_values = new Dictionary <string, Dictionary <string, double> >();
var cats = new HashSet <string>();
foreach (System.Data.DataRow row in dt.Rows)
{
var items = row.ItemArray;
string cat = (string)items[category_col];
object o = items[val_col];
// exclude dbnull values
var ot = o.GetType();
if (exclude_dbnull_values && ot == typeof(System.DBNull))
{
continue;
}
cats.Add(cat);
}
foreach (System.Data.DataRow row in dt.Rows)
{
var items = row.ItemArray;
string cat = (string)items[category_col];
string ser = (string)items[series_col];
object o = items[val_col];
// exclude dbnull values
var ot = o.GetType();
if (exclude_dbnull_values && ot == typeof(System.DBNull))
{
continue;
}
double val = GetVal(dt_val_col, o);
if (!ser_to_values.ContainsKey(ser))
{
ser_to_values[ser] = new Dictionary <string, double>(cats.Count);
}
var ser_list = ser_to_values[ser];
ser_list[cat] = val;
}
var list_of_series = new List <SeriesDataPoints>();
foreach (var ser_list in ser_to_values.Values)
{
var sdp = new SeriesDataPoints();
foreach (string cat in cats)
{
// Try to find a value for each category
if (ser_list.ContainsKey(cat))
{
double v = ser_list[cat];
var dp = new DataPoint(v);
sdp.Add(dp);
}
else
{
double v = 0.0;
var dp = new DataPoint(v);
sdp.Add(dp);
}
}
}
var axislabels = new WebCharting.Data.AxisLabels(cats);
var cd = new DataSetMultiSeries(list_of_series, axislabels);
return(cd);
}
public static WebCharting.Data.DataSetMultiSeries GetMultiSeries1()
{
var datapoints0 = new WebCharting.Data.SeriesDataPoints(new double[]
{
32,
25,
19,
31,
43,
36,
51,
38,
29,
31,
57,
29,
38,
40,
48
});
datapoints0.Hyperlink = "http://google.com";
datapoints0.ToolTip = new ToolTip("Google");
datapoints0.Name = "Google";
var datapoints1 = new WebCharting.Data.SeriesDataPoints(new double[]
{
56,
45,
70,
75,
65,
59,
55,
51,
40,
34,
45,
39,
33,
31,
19
});
datapoints1.Hyperlink = "http://yahoo.com";
datapoints1.ToolTip = new ToolTip("Yahoo");
datapoints1.Name = "Yahoo";
var values = new List <WebCharting.Data.SeriesDataPoints> {
datapoints0, datapoints1
};
var today = System.DateTime.Now;
var start = today.AddDays(-datapoints0.Count);
var labels =
new WebCharting.Data.AxisLabels(
Enumerable.Range(0, datapoints0.Count).Select(i => start.AddDays(i).ToString("M/d")));
var chartdata = new WebCharting.Data.DataSetMultiSeries(values, labels);
return(chartdata);
}
