public Chart IOs_Monthly(long endPointID, string year)
{
Endpoint ep = repoEndpoints.Find(endPointID);
Chart hc = new Chart("HC_" + "EndPoint" + endPointID + "Inputs");
hc.title.Text = "Monthly Average";
hc.subTitle.Text = ep.Title;
hc.xAxis.GenerateMonthsList();
hc.legend.layout = Layout.vertical.ToString();
List <Rpt_EndPoint_IOs_Months_Result> rpt = db.Rpt_EndPoint_IOs_Months(endPointID, year).ToList();
#region GetMin
Serie s1 = new Serie();
s1.Name = "Min";
Rpt_EndPoint_IOs_Months_Result rpt1 = rpt[0];
List <int> resultMin = new List <int>();
resultMin.Add(rpt1.C1.GetValueOrDefault());
resultMin.Add(rpt1.C2.GetValueOrDefault());
resultMin.Add(rpt1.C3.GetValueOrDefault());
resultMin.Add(rpt1.C4.GetValueOrDefault());
resultMin.Add(rpt1.C5.GetValueOrDefault());
resultMin.Add(rpt1.C6.GetValueOrDefault());
resultMin.Add(rpt1.C7.GetValueOrDefault());
resultMin.Add(rpt1.C8.GetValueOrDefault());
resultMin.Add(rpt1.C9.GetValueOrDefault());
resultMin.Add(rpt1.C10.GetValueOrDefault());
resultMin.Add(rpt1.C11.GetValueOrDefault());
resultMin.Add(rpt1.C12.GetValueOrDefault());
s1.Data = resultMin;
hc.series.Add(s1);
#endregion
#region GetMax
Serie s2 = new Serie();
s2.Name = "Max";
Rpt_EndPoint_IOs_Months_Result rpt2 = rpt[1];
List <int> resultMax = new List <int>();
resultMax.Add(rpt2.C1.GetValueOrDefault());
resultMax.Add(rpt2.C2.GetValueOrDefault());
resultMax.Add(rpt2.C3.GetValueOrDefault());
resultMax.Add(rpt2.C4.GetValueOrDefault());
resultMax.Add(rpt2.C5.GetValueOrDefault());
resultMax.Add(rpt2.C6.GetValueOrDefault());
resultMax.Add(rpt2.C7.GetValueOrDefault());
resultMax.Add(rpt2.C8.GetValueOrDefault());
resultMax.Add(rpt2.C9.GetValueOrDefault());
resultMax.Add(rpt2.C10.GetValueOrDefault());
resultMax.Add(rpt2.C11.GetValueOrDefault());
resultMax.Add(rpt2.C12.GetValueOrDefault());
s2.Data = resultMax;
hc.series.Add(s2);
#endregion
#region GetAvg
Serie s3 = new Serie();
s3.Name = "Avg";
Rpt_EndPoint_IOs_Months_Result rpt3 = rpt[2];
List <int> resultAvg = new List <int>();
resultAvg.Add(rpt3.C1.GetValueOrDefault());
resultAvg.Add(rpt3.C2.GetValueOrDefault());
resultAvg.Add(rpt3.C3.GetValueOrDefault());
resultAvg.Add(rpt3.C4.GetValueOrDefault());
resultAvg.Add(rpt3.C5.GetValueOrDefault());
resultAvg.Add(rpt3.C6.GetValueOrDefault());
resultAvg.Add(rpt3.C7.GetValueOrDefault());
resultAvg.Add(rpt3.C8.GetValueOrDefault());
resultAvg.Add(rpt3.C9.GetValueOrDefault());
resultAvg.Add(rpt3.C10.GetValueOrDefault());
resultAvg.Add(rpt3.C11.GetValueOrDefault());
resultAvg.Add(rpt3.C12.GetValueOrDefault());
s3.Data = resultAvg;
hc.series.Add(s3);
#endregion
return(hc);
}