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)); }