private void ReportServices_DailyGrab_GenChargerData_ChargerHist(Chargers v, int WeekNumber, int YearNumber)
{
GetChartData gd = new GetChartData();
DataTable DtRange = gd.GetDateRangeFromWeekNumber(WeekNumber, YearNumber);
DataTable dataTable = gd.Dt_DailyGrab_GetChargerStatusHist(v.ChargingStationID, WeekNumber, YearNumber, Rounding);
string mainTitle = string.Format("Chrg Status - {0} - {1} ", Convert.ToDateTime(DtRange.Rows[0]["StartDate"]).ToString("d"), Convert.ToDateTime(DtRange.Rows[0]["EndDate"]).ToString("d"));
string subTitle = string.Format("{0} - {1}", v.CustomerName, v.ChargingStationID);
hcFrutas.Title = new Title(mainTitle);
hcFrutas.SubTitle = new SubTitle(subTitle);
hcFrutas.Width = 800;
hcFrutas.Theme = "grid";
hcFrutas.Legend = new Legend { align = Align.right, layout = Layout.vertical, verticalAlign = VerticalAlign.top, x = -10, y = 70, borderWidth = 0 };
hcFrutas.Appearance = new Appearance { renderTo = "container", animation = false };
hcFrutas.YAxis.Add(new YAxisItem { title = new Title("Chrg Status") });
//Get point collection
var pointCollectionChgStatusCnt = new PointCollection();
var pointCollectionChg_TotalDocking = new PointCollection();
var pointCollectionChg_Complete = new PointCollection();
var pointCollectionChg_Fail = new PointCollection();
var pointCollectionChg_OpErrors = new PointCollection();
var pointCollectionChg_OpAborts = new PointCollection();
var pointCollectionCat = new PointCollection();
//var pointCollectionSocMax = new PointCollection();
//var pointCollectionSocDas = new PointCollection();
List<string> buckets = new List<string>();
List<string> status = new List<string>();
// Add string using Add method
foreach (DataRow row in dataTable.Rows)
{
pointCollectionChg_TotalDocking.Add(new Point(Convert.ToDouble(row["TotalDocking"])));
pointCollectionChg_Complete.Add(new Point(row["Complete"]));
pointCollectionChg_Fail.Add(new Point(row["Fail"]));
pointCollectionChg_OpErrors.Add(new Point(row["OpErrors"]));
pointCollectionChg_OpAborts.Add(new Point(row["OpAborts"]));
buckets.Add(row["DateLabel"].ToString());
//status.Add(row["col"].ToString());
}
//Add data to serie
hcFrutas.XAxis.Add(new XAxisItem { type = AxisDataType.linear, tickColor = "#ccc", categories = buckets.ToArray(), tickLength = 1, title = new Title("Date") });
var series = new Collection<Serie> { new Serie { name = "TotalDocking", data = pointCollectionChg_TotalDocking.ToArray(), type = RenderType.column, showInLegend = true } ,
new Serie { name = "Complete", data = pointCollectionChg_Complete.ToArray(), type = RenderType.column, showInLegend = true } ,
new Serie { name = "Fail", data = pointCollectionChg_Fail.ToArray(), type = RenderType.column, showInLegend = true } ,
new Serie { name = "OpErrors", data = pointCollectionChg_OpErrors.ToArray(), type = RenderType.column, showInLegend = true } ,
new Serie { name = "OpAborts", data = pointCollectionChg_OpAborts.ToArray(), type = RenderType.column, showInLegend = true }
};
// var series = new Collection<Serie> { new Serie { name = "Charge Status", data = pointCollectionChgStatusCnt.ToArray(), type = RenderType.column, showInLegend = false }, new Serie { name = "Charge", data = pointCollectionCat.ToArray(), type = RenderType.column, showInLegend = false } };
// var series = new Collection<Serie> { new Serie { name = "SocMin", data = pointCollectionSocMin.ToArray() }, new Serie { name = "SocMax", data = pointCollectionSocMax.ToArray() }, new Serie { name = "SocDash", data = pointCollectionSocDas.ToArray() } };
//hcVendas.PlotOptions = new PlotOptionsLine { marker = new Marker { enabled = true }, dataLabels = new DataLabels { enabled = true } };
hcFrutas.PlotOptions = new PlotOptionsColumn
{
groupPadding = 0,
pointPadding = 0,
shadow = true,
borderWidth = 2,
borderColor = "#666",
// dataLabels = new DataLabels { enabled = true ,formatter="function() { if(this.y != 0) { return this.y;}}"}
dataLabels = new DataLabels { enabled = true }
};
//Bind the control
hcFrutas.DataSource = series;
hcFrutas.DataBind();
}