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