public ActionResult GetChartData()
{
List <test> data = new List <test>();
//Here MyDatabaseEntities is our dbContext
using (kappaEntities dc = new kappaEntities())
{
data = dc.test.ToList();
}
var dt = new VisualizationDataTable();
dt.AddColumn("Time", "string");
dt.AddColumn("Pressure", "number");
foreach (var item in data)
{
dt.NewRow(item.Time, item.Pressure);
}
var chart = new ChartViewModel
{
Title = "Events",
Subtitle = "per date",
DataTable = dt
};
return(Content(JsonConvert.SerializeObject(chart), "application/json"));
}
public ActionResult getMapData()
{
SqlConnection cn = new SqlConnection("data source = localhost; initial catalog = GraduateModule; integrated security = True; multipleactiveresultsets = True;");
SqlCommand cmd = new SqlCommand("SELECT A.WorkAreaName Alan, COUNT(G.StudentID) as CountRate FROM WorkArea A LEFT JOIN Graduates G ON A.WAID = G.WorkAreaID GROUP BY A.WorkAreaName ORDER BY COUNT(G.StudentID) desc", cn);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
DataTable firstTable = ds.Tables[0];
List <WorkAreaCountModel> Records = new List <WorkAreaCountModel>();
var dt = new VisualizationDataTable();
dt.AddColumn("Alan", "string");
dt.AddColumn("CountRate", "number");
for (int i = 0; i < firstTable.Rows.Count; i++)
{
dt.NewRow(firstTable.Rows[i]["Alan"].ToString(), Convert.ToInt32(firstTable.Rows[i]["CountRate"]));
}
var chart = new ChartViewModel
{
WorkAreaName = "Records",
Count = "Per Machine",
DataTable = dt
};
return(Content(JsonConvert.SerializeObject(chart), "application/json"));
}
public ActionResult SearchChartData(string Date, string Hours)
{
List <historypressure> data = new List <historypressure>();
var dt = new VisualizationDataTable();
var chart = new ChartViewModel
{
Title = "Events",
Subtitle = "per date",
DataTable = dt
};
var date = from d in db.historypressure
select d;
if (!string.IsNullOrEmpty(Date))
{
if (!string.IsNullOrEmpty(Hours))
{
string hr = Convert.ToString(Hours);
date = date.Where(c => c.Date.Contains(Date));
date = date.Where(c => c.Hours.Equals(Hours));
}
else
{
date = from d in db.historypressure
select d;;
}
}
else
{
date = from d in db.historypressure
select d;;
}
var sortbytime = date.OrderByDescending(x => x.Minutes).ToList();
dt.AddColumn("Date", "string");
dt.AddColumn("實際蒸汽壓力 (kgf/cm2G)", "number");
dt.AddColumn("預測蒸汽壓力 (kgf/cm2G)", "number");
int counter = 0;
foreach (var item in sortbytime)
{
dt.NewRow(item.Minutes, item.ActualPressure, item.EstimatePressure);
counter++;
if (counter >= 13)
{
break;
}
}
return(Content(JsonConvert.SerializeObject(chart), "application/json"));
}
public ActionResult GetChartData()
{
List <record_estimate> data = new List <record_estimate>();
var dt = new VisualizationDataTable();
var chart = new ChartViewModel
{
Title = "Events",
Subtitle = "per date",
DataTable = dt
};
//Here MyDatabaseEntities is our dbContext
using (projectEntities dc = new projectEntities())
{
data = dc.record_estimate.ToList();
}
var sortbytime = data.OrderByDescending(x => x.Time).ToList();
dt.AddColumn("Date", "string");
dt.AddColumn("實際蒸汽壓力(kgf/cm2G)", "number");
dt.AddColumn("預測蒸汽壓力(kgf/cm2G)", "number");
int counter = 0;
foreach (var item in sortbytime)
{
dt.NewRow(item.Time, item.ActualPressure, item.EstimatePressure);
counter++;
if (counter >= 12)
{
break;
}
}
return(Content(JsonConvert.SerializeObject(chart), "application/json"));
}
public ActionResult GetChartData()
{
var dt = new VisualizationDataTable();
dt.AddColumn("Date", "string");
dt.AddColumn("Events", "number");
dt
.NewRow("25-05-2016", 123)
.NewRow("26-05-2016", 111)
.NewRow("27-05-2016", 132)
.NewRow("28-05-2016", 121)
.NewRow("29-05-2016", 109)
.NewRow("30-05-2016", 126)
;
var chart = new ChartViewModel
{
Title = "Title",
Subtitle = "Subtitle",
DataTable = dt
};
return(Content(JsonConvert.SerializeObject(chart), "application/json"));
}
