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);
        }
    }
Example #2
0
    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);
        }
    }
Example #5
0
    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);
        }
    }