private void loadEmotionSurprisedGraph()
{
queryString = "select Surprised,Timestamp from alef.emotions where Student_id="
+ studentId + " and Timestamp BETWEEN" + start + " AND " + end + ";";
ConfigDAO configs = new ConfigDAO(queryString, "Surprised", "Emotion Variation - Surprise", "chart7", Color.RosyBrown);
generateGraph(configs, ltrChart7);
}
private void loadEmotionNeutralGraph()
{
queryString = "select Neutral,Timestamp from alef.emotions where Student_id="
+ studentId + " and Timestamp BETWEEN" + start + " AND " + end + ";";
ConfigDAO configs = new ConfigDAO(queryString, "Neutral", "Emotion Variation - Neutral", "chart6", Color.SpringGreen);
generateGraph(configs, ltrChart6);
}
private void loadEmotionSadGraph()
{
queryString = "select Sad,Timestamp from alef.emotions where Student_id="
+ studentId + " and Timestamp BETWEEN" + start + " AND " + end + ";";
ConfigDAO configs = new ConfigDAO(queryString, "Sad", "Emotion Variation - Sadness", "chart5", Color.BlueViolet);
generateGraph(configs, ltrChart5);
}
private void loadEmotionHappyGraph()
{
queryString = "select Happy,Timestamp from alef.emotions where Student_id="
+ studentId + " and Timestamp BETWEEN" + start + " AND " + end + ";";
ConfigDAO configs = new ConfigDAO(queryString, "Happy", "Emotion Variation - Happiness", "chart4", Color.Yellow);
generateGraph(configs, ltrChart4);
}
private void loadValenceGraph()
{
queryString = "select Valence,Timestamp from alef.emotions where Student_id="
+ studentId + " and Timestamp BETWEEN" + start + " AND " + end + ";";
ConfigDAO configs = new ConfigDAO(queryString, "Valence", "Valence Variation", "chart3", Color.Tomato);
generateGraph(configs, ltrChart3);
}
private void generateGraph(ConfigDAO configs, Literal literal)
{
DataTable data = loadDatafromDB(queryString);
Object[] intensities = new Object[data.Rows.Count];
string[] timestamps = new string[data.Rows.Count];
int index = 0;
foreach (DataRow dr in data.Rows)
{
intensities[index] = (dr[configs.emotion].ToString() != "") ? dr[configs.emotion] : null;
timestamps[index] = dr["Timestamp"].ToString();
index++;
}
Series[] serieses = new Series[1];
Series dataSeries = new Series {
Data = new Data(intensities)
};
dataSeries.Color = configs.color;
dataSeries.Name = configs.emotion;
serieses[0] = dataSeries;
Title title = new DotNet.Highcharts.Options.Title();
title.Text = configs.graphTitle;
XAxis xAxis = new XAxis();
xAxis.Categories = timestamps;
xAxis.TickInterval = 200;
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts(configs.chartName).SetXAxis(xAxis).SetSeries(serieses).SetTitle(title);
literal.Text = chart.ToHtmlString();
}
