public static void PrintOutput(string testAbbrev, string itemID) { if (InternetAvailable.internetAvailableStatic) { string values = string.Format("('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')", Camera.main.GetComponent <TestHandler>().testNumber, Settings.studentID, Settings.testID, itemID, correct ? 1 : 0, (timer.ElapsedMilliseconds / 1000f - delayTime), System.DateTime.Parse(Settings.DateTimeM).ToString("yyyy/M/d HH:mm:ss")); print(values); string command = ""; if (testAbbrev.Equals("CSC")) { command = "insert into CARE1.UNIVERSAL (exam_type, id, test_id, item_id, correctness, reaction_time, dot) values " + values; } else if (testAbbrev.Equals("CSS")) { command = "insert into CARE1.UNIVERSAL (exam_type, id, test_id, item_id, correctness, reaction_time, dot) values " + values; } else { command = "insert into CARE1.UNIVERSAL (exam_type, id, test_id, item_id, correctness, reaction_time, dot) values " + values; } print(command); ScoreReports.SaveToCSVLocalData(testAbbrev, values); SQLHandler.RunCommand(command); } }
public static void PrintOutput(string itemID) { if (InternetAvailable.internetAvailableStatic) { string values = string.Format("('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}')", Camera.main.GetComponent <TestHandler>().testNumber, Settings.studentID, Settings.testID, itemID, correctness ? 1 : 0, (timer.ElapsedMilliseconds / 1000f - delayTime), position, content, System.DateTime.Parse(Settings.DateTimeM).ToString("yyyy-MM-dd")); string command = "insert into university.exam_results (exam_type, student_id, test_id, item_id, correctness, reaction_time, content, select_name, dot) values " + values; ScoreReports.SaveToCSVLocalData("VIS", values); SQLHandler.RunCommand(command); } }
public static void PrintOutput(string testAbbrev, int itemNum, bool correct, bool perseveration, float timer, string currRule, string prevRule, string sortRule) { if (InternetAvailable.internetAvailableStatic) { string values = string.Format("('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}','{10}')", 17, Settings.studentID, Settings.testID, "WCST" + System.Convert.ToString(itemNum), correct ? 1 : 0, perseveration ? "P" : "NP", timer, currRule, prevRule, sortRule, System.DateTime.Parse(Settings.DateTimeM).ToString("yyyy/M/d HH:mm:ss")); string command = "insert into CARE1.UNIVERSAL (exam_type, id, test_id, item_id, correctness, perseveration, reaction_time, current_rule, previous_rule, sort_rule, dot) values " + values; ScoreReports.SaveToCSVLocalData(testAbbrev, values); SQLHandler.RunCommand(command); } }
public static void PrintOutput(string itemID) { if (InternetAvailable.internetAvailableStatic) { string[] data = dataToArray(); string values = string.Format("('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}')", Camera.main.GetComponent <TestHandler>().testNumber, Settings.studentID, Settings.testID, itemID, points, reactionTime, correctSeq, userSeq, correctOrder, userOrder, System.DateTime.Parse(Settings.DateTimeM).ToString("yyyy-MM-dd")); string command = "insert into university.exam_results (exam_type, student_id, test_id, item_id, correctness, reaction_time, correct_seq, user_seq, correct_order, user_order, dot) values " + values; ScoreReports.SaveToCSVLocalData("SLC", values); SQLHandler.RunCommand(command); } }
public static void PrintOutput(string itemID) { if (InternetAvailable.internetAvailableStatic) { print(responseName); string values = string.Format("('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}')", Camera.main.GetComponent <TestHandler>().testNumber, Settings.studentID, Settings.testID, itemID, correct ? 1 : 0, (timer.ElapsedMilliseconds / 1000f - delayTime), responsePosition, responseName, System.DateTime.Parse(Settings.DateTimeM).ToString("yyyy-MM-dd"), FindObjectOfType <ClickCardGNG>().hitTimes); string command = "insert into CARE1.CPT (exam_type, id, test_id, item_id, correctness, reaction_time, select_pos, select_name, dot, hit_num) values " + values; ScoreReports.SaveToCSVLocalData("CPT", values); SQLHandler.RunCommand(command); } }