public void CloseDescription() { float duration = Time.time - AppManager.startDescriptionTime; AppManager.startDescriptionTime = 0f; SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "CloseDescription_" + AppManager.currentDescription, duration.ToString()); }
//private SqliteDbManager sqliteManager; // Use this for initialization void Start() { if (ageContainer != null) { statsAge = ageContainer.GetComponentsInChildren <Toggle> (); } else { statsAge = new Toggle[0]; } if (sexContainer != null) { statsSex = sexContainer.GetComponentsInChildren <Toggle> (); } else { statsSex = new Toggle[0]; } //sqliteManager = this.GetComponent<SqliteDbManager> (); SqliteDbManager.Init(); if (testNum != -1) { StatTest(testNum); } }
public int Insert(params object[] values) { IDbManager dbMgr = new SqliteDbManager(); return(dbMgr.Execute("INSERT INTO localization (key, text, language_id) VALUES (@key, @text, @lang_id);", new SqliteParameter("@key", values[0]), new SqliteParameter("@text", values[1]), new SqliteParameter("@lang_id", values[2]))); }
public void FoundTarget(string name) { AppManager.foundTargetTime = Time.time; AppManager.nbTargetFound++; AppManager.currentTargetName = name; SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "FoundTarget", name); }
private void StartSession() { AppManager.sessionId = Random.Range(10000, 99999); ShowSessionId(); SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "StartSession", ""); AppManager.startSessionTime = Time.time; }
public void ValidateSex() { foreach (Toggle sex in statsSex) { if (sex.isOn) { SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "Sex", sex.gameObject.name); } } }
public void LostTarget() { if (AppManager.currentTargetName != "") { float duration = Time.time - AppManager.foundTargetTime; AppManager.foundTargetTime = 0f; SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "LostTarget_" + AppManager.currentTargetName, duration.ToString()); AppManager.currentTargetName = ""; } }
public void StopSession() { if (AppManager.startTestTime != 0f) { StopTest(); } float duration = Time.time - AppManager.startSessionTime; AppManager.startSessionTime = 0f; SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "StopSession", duration.ToString()); }
public void StatTest(int nb) { if (AppManager.startTestTime != 0f) { StopTest(); } AppManager.startTestTime = Time.time; AppManager.nbTargetFound = 0; AppManager.currentTest = nb; SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "StartTest_" + nb.ToString(), ""); }
public void ValidateAge() { StartSession(); foreach (Toggle age in statsAge) { if (age.isOn) { SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "Age", age.gameObject.name); } } }
public void StopTest() { if (AppManager.foundTargetTime != 0f) { LostTarget(); } float duration = Time.time - AppManager.startTestTime; AppManager.startTestTime = 0f; SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "NbTargetFound_" + AppManager.currentTest, AppManager.nbTargetFound.ToString()); SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "StopTest_" + AppManager.currentTest.ToString(), duration.ToString()); }
public List <Language> ReadAll() { List <Language> languages = new List <Language>(); IDbManager dbMgr = new SqliteDbManager(); List <object[]> values = dbMgr.Read("SELECT * FROM languages;"); foreach (object[] row in values) { languages.Add(new Language(int.Parse(row[0].ToString()), row[1].ToString())); } return(languages); }
public List <object[]> Read(params object[] values) { IDbManager dbMgr = new SqliteDbManager(); if (values.Length == 1) { return(dbMgr.Read("SELECT key, text FROM localization WHERE language_id = @lang_id;", new SqliteParameter("@lang_id", values[0]))); } else if (values.Length == 1) { return(dbMgr.Read("SELECT text FROM localization WHERE key = @key AND language_id = @lang_id;", new SqliteParameter("@key", values[0]), new SqliteParameter("@lang_id", values[1]))); } return(new List <object[]>()); }
public int Update(params object[] values) { IDbManager dbMgr = new SqliteDbManager(); return(dbMgr.Execute("UPDATE localization SET text = @text WHERE key = @key AND language_id = @lang_id;", new SqliteParameter("@text", values[0]), new SqliteParameter("@key", values[1]), new SqliteParameter("@lang_id", values[2]))); }
public List <object[]> ReadAll() { IDbManager dbMgr = new SqliteDbManager(); return(dbMgr.Read("SELECT * FROM localization;")); }
public void Like() { SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "Result_" + AppManager.currentTest, "like"); }
public int Delete(params object[] values) { IDbManager dbMgr = new SqliteDbManager(); return(dbMgr.Execute("DELETE FROM localization WHERE key = @key;", new SqliteParameter("@key", values[0]))); }
public int Update(Language value) { IDbManager dbMgr = new SqliteDbManager(); return(dbMgr.Execute("UPDATE languages SET name = @name WHERE language_id = @id;", new SqliteParameter("@id", value.ID), new SqliteParameter("@name", value.Name))); }
public int Insert(Language value) { IDbManager dbMgr = new SqliteDbManager(); return(dbMgr.Execute("INSERT INTO languages (language_id, name) VALUES (@id, @name);", new SqliteParameter("@id", value.ID), new SqliteParameter("@name", value.Name))); }
public int Delete(Language value) { IDbManager dbMgr = new SqliteDbManager(); return(dbMgr.Execute("DELETE FROM languages WHERE language_id = @id AND name = @name;", new SqliteParameter("@id", value.ID), new SqliteParameter("@name", value.Name))); }
public void OpenDescription(string content) { AppManager.startDescriptionTime = Time.time; AppManager.currentDescription = content; SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "OpenDescription", content); }
public void DontLikeDescription() { SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "Result_" + AppManager.currentDescription + AppManager.currentTest, "dont-like"); }
public void FoundVoucher(string target) { SqliteDbManager.insertStat("", AppManager.sessionId.ToString(), "FoundVoucher", target); }