private void WriteDataToFile()
{
Debug.Log("Writing to data file");
//JSON object creation
JsonData data = new JsonData();
data.UserID = TestSubjectID;
data.StartDate = ExperimentDate.ToString(); //StartDate and time as string
data.EndDate = ExperimentEndDate.ToString(); //End time of the trial
data.Maze = MazeID;
//this is the number of question types we will write to the json file
data.Responses = new JsonRS[InitActiveKeys.Keys.Count];
int counter = 0;
foreach (var key in InitActiveKeys.Keys)
{
JsonRS temp = new JsonRS();
temp.QuestionType = key.ToString();
int index = InitActiveKeys[key];
temp.RSS = new ResponseTimes[RSList[index].Count];
for (int j = 0; j < RSList[index].Count; j++)
{
temp.RSS[j] = new ResponseTimes();
temp.RSS[j].PRS = RSList[index][j].PRS;
temp.RSS[j].QRS = RSList[index][j].QRS;
temp.RSS[j].DRS = RSList[index][j].DRS;
temp.RSS[j].PopUpStartTime = RSList[index][j].PopUpStartTime;
temp.RSS[j].QuestionStartTime = RSList[index][j].QuestionStartTime;
temp.RSS[j].QuestionEndTime = RSList[index][j].QuestionEndTime;
temp.RSS[j].StartDrivingTime = RSList[index][j].StartDrivingTime;
}
data.Responses[counter] = temp;
counter++;
}
string json = JsonUtility.ToJson(data, true);
//Appending in the write position in the file
//Read the existing contents of the file
string ExistingFile = File.ReadAllText(DataLogFilePath);
//Find the position of the $ which shows the position where we will append the new object
int AppendPosition = ExistingFile.IndexOf("$");
ExistingFile = ExistingFile.Insert(AppendPosition, json + ", \r\n");
//Write the new string in the file
File.WriteAllText(DataLogFilePath, ExistingFile);
}
public JsonResult GetData()
{
return(GetDbData());
/* creo l'oggetto radice */
JsonRS json_ret = new JsonRS();
/* aggiungo i vari headers */
Th Header = new Th();
Header.nome = "Colonna1";
Header.caption = "Col 1";
Header.tipo = "string";
Header.width = "250px";
Header.align = "left";
Header.format = "";
json_ret.head.Add(Header);
Header = new Th();
Header.nome = "Colonna2";
Header.caption = "Col 2";
Header.tipo = "string";
Header.width = "";
Header.align = "left";
Header.format = "";
json_ret.head.Add(Header);
Header = new Th();
Header.nome = "Colonna3";
Header.caption = "Col 3";
Header.tipo = "string";
Header.width = "";
Header.align = "left";
Header.format = "";
json_ret.head.Add(Header);
Header = new Th();
Header.nome = "Colonna4";
Header.caption = "Col 4";
Header.tipo = "number";
Header.width = "100px";
Header.align = "right";
Header.format = "";
json_ret.head.Add(Header);
Header = new Th();
Header.nome = "Colonna5";
Header.caption = "Col 5";
Header.tipo = "datetime";
Header.width = "100px";
Header.align = "center";
Header.format = "";
json_ret.head.Add(Header);
/* aggiungo le varie righe */
Tr Riga = new Tr();
dynamic expObj = new ExpandoObject();
AddProperty(expObj, "Colonna1", "uallabalooza");
AddProperty(expObj, "Colonna2", "in the");
AddProperty(expObj, "Colonna3", "sky");
AddProperty(expObj, "Colonna4", 245.1);
AddProperty(expObj, "Colonna5", "01/01/9999");
//json_ret.body.Add(new { Colonna1 = "uallabalooza", Colonna2 = "in the", Colonna3 = "sky", Colonna4 = 245.1, Colonna5 = "01/01/9999" });
json_ret.body.Add(expObj);
expObj = new ExpandoObject();
AddProperty(expObj, "Colonna1", "rasti");
AddProperty(expObj, "Colonna2", "blasti");
AddProperty(expObj, "Colonna3", "lasagne");
AddProperty(expObj, "Colonna4", -14000);
AddProperty(expObj, "Colonna5", "01/01/9999");
//json_ret.body.Add(new { Colonna1 = "rasti", Colonna2 = "blasti", Colonna3 = "lasagne", Colonna4 = -14000, Colonna5 = "01/01/9999" });
json_ret.body.Add(expObj);
expObj = new ExpandoObject();
AddProperty(expObj, "Colonna1", "similili");
AddProperty(expObj, "Colonna2", "la formica");
AddProperty(expObj, "Colonna3", "brombagliumbal");
AddProperty(expObj, "Colonna4", 15);
AddProperty(expObj, "Colonna5", "01/01/9999");
//json_ret.body.Add(new { Colonna1 = "similili", Colonna2 = "la formica", Colonna3 = "brombagliumbal", Colonna4 = 245.1, Colonna5 = "01/01/9999" });
json_ret.body.Add(expObj);
/* restituisco l'output come JSON serializzato */
JsonConvert.SerializeObject(json_ret);
return(Json(json_ret));
}
public JsonResult GetDbData()
{
/* Linq to SQL: effettuo la query */
/*DataContext Db = new DataContext("Data Source=idea-dev\\IDEA;Initial Catalog=ZZZDEV001;Integrated Security=False;User Id=sa;Password=master2k5*;");
* Table<WWWStatistiche> stat = Db.GetTable<WWWStatistiche>();
* IQueryable<object> query = from c in stat
* where 1 == 1
* select c;
* foreach(object record in query)
* {
* record.
* }
* Db.Dispose();*/
AngularDEVContainer context = new AngularDEVContainer();
List <WWWStatistiche> stat = (from c in context.WWWStatistiche
where 1 == 1
select c).ToList <WWWStatistiche>();
/* creo gli oggetti JSON */
JsonRS json_ret = new JsonRS();
Th Header = new Th();
Tr Riga = new Tr();
PropertyInfo[] fields;
dynamic expObj = new ExpandoObject();
for (var i = 0; i < stat.Count; i++)
{
fields = stat[i].GetType().GetProperties();
if (i == 0) /* definizione intestazioni */
{
for (var j = 0; j < fields.Length; j++)
{
Header = new Th();
Header.nome = fields[j].Name;
Header.caption = fields[j].Name;
Header.tipo = fields[j].GetType().ToString();
Header.width = "";
switch (fields[j].GetType().ToString().ToLower())
{
case "string": Header.align = "left"; break;
default: Header.align = "left"; break;
}
Header.format = "";
json_ret.head.Add(Header);
}
}
/* aggiungo le varie righe */
Riga = new Tr();
expObj = new ExpandoObject();
for (var j = 0; j < fields.Length; j++)
{
AddProperty(expObj, fields[j].Name, stat[i].GetType().GetProperty(fields[j].Name).GetValue(stat[i]).ToString());
}
json_ret.body.Add(expObj);
}
/* restituisco l'output come JSON serializzato */
JsonConvert.SerializeObject(json_ret);
return(Json(json_ret));
/* creo l'oggetto radice */
JsonRS json_retz = new JsonRS();
/* aggiungo i vari headers */
Th Headerz = new Th();
Header.nome = "Colonna1";
Header.caption = "Col 1";
Header.tipo = "string";
Header.width = "250px";
Header.align = "left";
Header.format = "";
json_ret.head.Add(Header);
Header = new Th();
Header.nome = "Colonna2";
Header.caption = "Col 2";
Header.tipo = "string";
Header.width = "";
Header.align = "left";
Header.format = "";
json_ret.head.Add(Header);
Header = new Th();
Header.nome = "Colonna3";
Header.caption = "Col 3";
Header.tipo = "string";
Header.width = "";
Header.align = "left";
Header.format = "";
json_ret.head.Add(Header);
Header = new Th();
Header.nome = "Colonna4";
Header.caption = "Col 4";
Header.tipo = "number";
Header.width = "100px";
Header.align = "right";
Header.format = "";
json_ret.head.Add(Header);
Header = new Th();
Header.nome = "Colonna5";
Header.caption = "Col 5";
Header.tipo = "datetime";
Header.width = "100px";
Header.align = "center";
Header.format = "";
json_ret.head.Add(Header);
/* aggiungo le varie righe */
Tr Rigaz = new Tr();
dynamic expObjz = new ExpandoObject();
AddProperty(expObj, "Colonna1", "uallabalooza");
AddProperty(expObj, "Colonna2", "in the");
AddProperty(expObj, "Colonna3", "sky");
AddProperty(expObj, "Colonna4", 245.1);
AddProperty(expObj, "Colonna5", "01/01/9999");
//json_ret.body.Add(new { Colonna1 = "uallabalooza", Colonna2 = "in the", Colonna3 = "sky", Colonna4 = 245.1, Colonna5 = "01/01/9999" });
json_ret.body.Add(expObj);
expObj = new ExpandoObject();
AddProperty(expObj, "Colonna1", "rasti");
AddProperty(expObj, "Colonna2", "blasti");
AddProperty(expObj, "Colonna3", "lasagne");
AddProperty(expObj, "Colonna4", -14000);
AddProperty(expObj, "Colonna5", "01/01/9999");
//json_ret.body.Add(new { Colonna1 = "rasti", Colonna2 = "blasti", Colonna3 = "lasagne", Colonna4 = -14000, Colonna5 = "01/01/9999" });
json_ret.body.Add(expObj);
expObj = new ExpandoObject();
AddProperty(expObj, "Colonna1", "similili");
AddProperty(expObj, "Colonna2", "la formica");
AddProperty(expObj, "Colonna3", "brombagliumbal");
AddProperty(expObj, "Colonna4", 15);
AddProperty(expObj, "Colonna5", "01/01/9999");
//json_ret.body.Add(new { Colonna1 = "similili", Colonna2 = "la formica", Colonna3 = "brombagliumbal", Colonna4 = 245.1, Colonna5 = "01/01/9999" });
json_ret.body.Add(expObj);
/* restituisco l'output come JSON serializzato */
JsonConvert.SerializeObject(json_ret);
return(Json(json_ret));
}
