// Start is called before the first frame update void Start() { StartCoroutine(Utils.SetVRDevice("OpenVR", true)); MC1 = M1.GetComponent <MasterController>(); MC2 = M2.GetComponent <MasterController>(); MC3 = M3.GetComponent <MasterController>(); MC4 = M4.GetComponent <MasterController>(); MC5 = M5.GetComponent <MasterController>(); MC6 = M6.GetComponent <MasterController>(); MC7 = M7.GetComponent <MasterController>(); MC8 = M8.GetComponent <MasterController>(); loadLevel(); currentPoseIndex = 0; }
// Reads the input files // Fills the TABLES with DATA from the files private void Fill_tables(MySqlConnection connection) { // Add data to RoomTable Console.WriteLine("We now add records to RoomTable\n"); using (StreamReader SR = new StreamReader("Room.txt")) { String S = SR.ReadLine(); // Loop through the file reading lines while (S != null) { String[] SArray = S.Split(','); // Room.txt contains tab-delimited fields. int M = Convert.ToInt32(SArray[1]); int Rm = Convert.ToInt32(SArray[0]); String SqlString = "Insert Into RoomTable (Room, Capacity, Smart) Values(" + "'" + Rm.ToString() + "', " + M.ToString() + ", '" + SArray[2] + "')"; //Console.WriteLine(SqlString); // Run the command MySqlCommand Command2 = new MySqlCommand(SqlString, connection); Command2.ExecuteNonQuery(); S = SR.ReadLine(); } // end of while } // end of using for StreamReader // Add data to OfficeTable Console.WriteLine("We now add records to OfficeTable\n"); using (StreamReader SR = new StreamReader("Office.txt")) { String S = SR.ReadLine(); // Loop through the file reading lines while (S != null) { String[] SArray = S.Split(','); // Room.txt contains tab-delimited fields. int M = Convert.ToInt32(SArray[1]); String SqlString = "Insert Into OfficeTable (Teacher , Office) Values(" + "'" + SArray[0] + "', " + M.ToString() + ")"; //Console.WriteLine(SqlString); // Run the command MySqlCommand Command2 = new MySqlCommand(SqlString, connection); Command2.ExecuteNonQuery(); S = SR.ReadLine(); } // end of while } // end of using for StreamReader // Add data to ClassTable Console.WriteLine("We now add records to ClassTable\n"); using (StreamReader SR = new StreamReader("Class.txt")) { // Ints to Convert strings to ints int M0; int M1; int M3; int M6; String S = SR.ReadLine(); while (S != null) { // Show the string in the console //Console.WriteLine(S); // THIS WAS FOR THE ORIGINAL INPUT FILE FOR CLASSES // If the line does not have Section 1 - ADD IT //if ( (S.IndexOf('-')) == -1 ) //{ // S = S.Insert((S.IndexOf(',')), "-1"); //} // This split was also for the original input, but still works // Split the String and Commas AND Dashes String[] SArray = S.Split(new Char[] { ',', '-' }, StringSplitOptions.RemoveEmptyEntries); // Room.txt contains tab-delimited fields. // Convert some stings to ints // Check if any of the INTS are passed in as NULL { if (SArray[0] != "null") { M0 = Convert.ToInt32(SArray[0]); } else { M0 = -1; } if (SArray[1] != "null") { M1 = Convert.ToInt32(SArray[1]); } else { M1 = -1; } if (SArray[3] != "null") { M3 = Convert.ToInt32(SArray[3]); } else { M3 = -1; } if (SArray[6] != "null") { M6 = Convert.ToInt32(SArray[6]); } else { M6 = -1; } } // If the file has NULL for primary keys - it will display a message box // Except for the "Section"... because the new input file has "section" as null // despite the fact that it MUST be part of the primary key // because there are classes with the same Number // Create the command String String SqlString = "Insert Into ClassTable (Class, Section, Teacher, Room, Time, Days, Enrollment) Values(" + (M0 == -1 ? "NULL" : M0.ToString()) + ", " + (M1 == -1 ? "1" : M1.ToString()) + ", " + (SArray[2] == "null" ? "NULL" : "'" + SArray[2] + "'") + ", " + (M3 == -1 ? "NULL" : M3.ToString()) + ", " + (SArray[4] == "null" ? "NULL" : "'" + SArray[4] + "'") + ", " + (SArray[5] == "null" ? "NULL" : "'" + SArray[5] + "'") + ", " + (M6 == -1 ? "NULL" : M6.ToString()) + ")"; // Output the command to console //Console.WriteLine(SqlString); // Make the command and RUN IT MySqlCommand Command2 = new MySqlCommand(SqlString, connection); Command2.ExecuteNonQuery(); // Get a new Line S = SR.ReadLine(); } // end of while } // end of using for StreamReader }
public void Do <T, U, V, W, X>(M6 <T, U, V, W, X> m) { DoAny(m); }
public void Do <T, U, V, W, X, Y, Z>(M6 <T, U, V, W, X, Y, Z> m) { DoAny(m); }
public void Do <T, U, V>(M6 <T, U, V> m) { DoAny(m); }