public static void getRosterTest() { string excelFileName = "C:\\Users\\briggs_mc\\Desktop\\Final\\databaseConnector\\CS142roosterTest.xlsx"; FillDatabase myFillDatabase = new FillDatabase(); myFillDatabase.getRoster(excelFileName); Assert.IsNotEmpty(myFillDatabase.course[2]); }
public static void rosterToDatabaseTablesTest() { string excelFileName = "C:\\Users\\briggs_mc\\Desktop\\Final\\databaseConnector\\CS142roosterTest.xlsx"; FillDatabase myFillDatabase = new FillDatabase(); myFillDatabase.getRoster(excelFileName); myFillDatabase.rosterToDatabaseTables(); OleDbConnection connection = DatabaseConnector.CommonFunctions.connectToDB(); string commandCourse = "SELECT Course from allCourses where Course = '" + myFillDatabase.course[2] + "';"; //returns list of courses that matches - should be either course name or nothing? List<string> coursesAlreadyInTable = DatabaseConnector.CommonFunctions.readData(connection, commandCourse); bool inTable = coursesAlreadyInTable.Any(); // Assert.IsTrue(inTable); }
/// <summary> /// When the professor wants to add a class roster to the database /// he puts the path and file name for the roster and clicks /// add class this will read the excel file and put the necessary info into /// the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void profAddClassButton_Click(object sender, EventArgs e) { string excelFileName = profFilePathTextBox.Text; FillDatabase myFillDatabase = new FillDatabase(); myFillDatabase.getRoster(excelFileName); myFillDatabase.rosterToDatabaseTables(); profFilePathTextBox.Clear(); profActionAccepted.Text = "Request Accepted"; }