/// <summary> /// Load the LinkedList of Room for a Building /// </summary> /// <param name="building">The Building the Rooms are in</param> /// <returns>Linked List of rooms</returns> public LinkedList loadRoomList(Building building) { LinkedList roomList = new LinkedList(); Room tempRoom; string sqlStatment = "SELECT * FROM Room WHERE BuildingID LIKE " + building.getID(); try { OpenConection(); cmd = new OleDbCommand(sqlStatment, conn); reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader["Deleted"].ToString().Equals("False")) { tempRoom = new Room(); tempRoom.setID(reader["ID"].ToString()); tempRoom.setRoomNumber(reader["Number"].ToString()); tempRoom.setCapacity(Convert.ToInt32(reader["Capacity"])); tempRoom.setRoomType(reader["RoomType"].ToString()); tempRoom.setSlotsOff(reader["SlotsOff"].ToString()); roomList.addAtTail(tempRoom); } } CloseConnection(); } catch { // MessageBox.Show("Failed to get data from source"); } return roomList; }