private void ReportServices_DailyGrab_GenVehicleData_TMaxByPacks(Vehicles v, DateTime dt)
{
GetChartData gd = new GetChartData();
DataTable dataTable = gd.Dt_DailyGrab_GetTMaxbyPacks(v.VinID, dt, Rounding);
string mainTitle = string.Format("Tmax Daily - {0}", dt.ToString("MM/dd/yy"));
string subTitle = string.Format("{0} - {1}", v.CustomerName, v.Vin);
hcVendas.Title = new Title(mainTitle);
hcVendas.SubTitle = new SubTitle(subTitle);
hcVendas.Theme = "grid";
hcVendas.Legend = new Legend { align = Align.right, layout = Layout.vertical, verticalAlign = VerticalAlign.top, x = -10, y = 70, borderWidth = 0 };
hcVendas.Appearance = new Appearance { renderTo = "container", animation = false };
hcVendas.YAxis.Add(new YAxisItem { title = new Title("Tmax C "), minorGridLineWidth = 0, gridLineWidth = 0 });
hcVendas.XAxis.Add(new XAxisItem { type = AxisDataType.datetime, dateTimeLabelFormats = new DateTimeLabelFormats { hour = "%H" }, title = new Title("Time in Hours") });
hcVendas.Tooltip = new ToolTip("Highcharts.dateFormat('%H:%M', this.x) +': '+ this.y");
//Get point collection
var pointCollectionTmax = new PointCollection();
var pointCollectionTmaxPack0 = new PointCollection();
var pointCollectionTmaxPack1 = new PointCollection();
var pointCollectionTmaxPack2 = new PointCollection();
var pointCollectionTmaxPack3 = new PointCollection();
var pointCollectionTmaxPack4 = new PointCollection();
var pointCollectionTmaxPack5 = new PointCollection();
var pointCollectionTmaxPack6 = new PointCollection();
var pointCollectionTmaxPack7 = new PointCollection();
foreach (DataRow row in dataTable.Rows)
{
// pointCollectionTmax.Add(new Point(Convert.ToInt64((DateTime.Parse(row["Time_Occur"].ToString()).Subtract(new DateTime(2015, 1, 1))).TotalMilliseconds), Convert.ToDouble(row["PCes_usi_Tmax_pct"])));
pointCollectionTmaxPack0.Add(new Point(Convert.ToInt64((DateTime.Parse(row["Time_Occur"].ToString()).Subtract(new DateTime(2015, 1, 1))).TotalMilliseconds), Convert.ToDouble(row["PCpm0_usi_Tmax_c"])));
pointCollectionTmaxPack1.Add(new Point(Convert.ToInt64((DateTime.Parse(row["Time_Occur"].ToString()).Subtract(new DateTime(2015, 1, 1))).TotalMilliseconds), Convert.ToDouble(row["PCpm1_usi_Tmax_c"])));
pointCollectionTmaxPack2.Add(new Point(Convert.ToInt64((DateTime.Parse(row["Time_Occur"].ToString()).Subtract(new DateTime(2015, 1, 1))).TotalMilliseconds), Convert.ToDouble(row["PCpm2_usi_Tmax_c"])));
pointCollectionTmaxPack3.Add(new Point(Convert.ToInt64((DateTime.Parse(row["Time_Occur"].ToString()).Subtract(new DateTime(2015, 1, 1))).TotalMilliseconds), Convert.ToDouble(row["PCpm3_usi_Tmax_c"])));
pointCollectionTmaxPack4.Add(new Point(Convert.ToInt64((DateTime.Parse(row["Time_Occur"].ToString()).Subtract(new DateTime(2015, 1, 1))).TotalMilliseconds), Convert.ToDouble(row["PCpm4_usi_Tmax_c"])));
pointCollectionTmaxPack5.Add(new Point(Convert.ToInt64((DateTime.Parse(row["Time_Occur"].ToString()).Subtract(new DateTime(2015, 1, 1))).TotalMilliseconds), Convert.ToDouble(row["PCpm5_usi_Tmax_c"])));
pointCollectionTmaxPack6.Add(new Point(Convert.ToInt64((DateTime.Parse(row["Time_Occur"].ToString()).Subtract(new DateTime(2015, 1, 1))).TotalMilliseconds), Convert.ToDouble(row["PCpm6_usi_Tmax_c"])));
pointCollectionTmaxPack7.Add(new Point(Convert.ToInt64((DateTime.Parse(row["Time_Occur"].ToString()).Subtract(new DateTime(2015, 1, 1))).TotalMilliseconds), Convert.ToDouble(row["PCpm7_usi_Tmax_c"])));
}
//Add data to serie
var series = new Collection<Serie> {
// new Serie { name = "Tmax", data = pointCollectionTmax.ToArray() },
new Serie { name = "P0", data = pointCollectionTmaxPack0.ToArray() },
new Serie { name = "P1", data = pointCollectionTmaxPack1.ToArray() },
new Serie { name = "P2", data = pointCollectionTmaxPack2.ToArray() },
new Serie { name = "P3", data = pointCollectionTmaxPack3.ToArray() },
new Serie { name = "P4", data = pointCollectionTmaxPack4.ToArray() },
new Serie { name = "P5", data = pointCollectionTmaxPack5.ToArray() },
new Serie { name = "P6", data = pointCollectionTmaxPack6.ToArray() },
new Serie { name = "P7", data = pointCollectionTmaxPack7.ToArray() }
};
hcVendas.DataSource = series;
hcVendas.PlotOptions = new PlotOptionsLine { marker = new Marker { enabled = false }, dataLabels = new DataLabels { enabled = false } };
//Bind the control
hcVendas.DataBind();
}