def importRooms(self): rooms = ioHandler.getCSVFile('rooms') if rooms: rooms.pop(0) rooms.pop(0) blankSchedule = json.dumps(Timetable.generateRawTable()) for room in rooms: Room.Room.insertRoom([room[0], blankSchedule, room[1]]) self.tabListener(1)
def importInstructors(self): instructors = ioHandler.getCSVFile('enseignants') if instructors: instructors.pop(0) instructors.pop(0) blankSchedule = json.dumps(Timetable.generateRawTable()) for instructor in instructors: Instructor.Instructor.insertInstructor([instructor[0], float(instructor[1]), blankSchedule]) self.tabListener(0)
def fillForm(self): conn = db.getConnection() cursor = conn.cursor() cursor.execute('SELECT name, hours, schedule FROM instructors WHERE id = ?', [self.id]) result = cursor.fetchone() conn.close() self.parent.lineEditName.setText(str(result[0])) self.parent.lineEditHours.setText(str(result[1])) # Generate timetable from custom schedule self.table = Timetable.Timetable(self.parent.tableSchedule, json.loads(result[2]))
def fillForm(self): conn = db.getConnection() cursor = conn.cursor() cursor.execute('SELECT name, schedule, type FROM rooms WHERE id = ?', [self.id]) result = cursor.fetchone() conn.close() self.parent.lineEditName.setText(str(result[0])) self.table = Timetable.Timetable(self.parent.tableSchedule, json.loads(result[1])) if result[2] == 'lec': self.parent.radioLec.setChecked(True) else: self.parent.radioLab.setChecked(True)
def fillForm(self): conn = db.getConnection() cursor = conn.cursor() cursor.execute( 'SELECT name, schedule, stay FROM sections WHERE id = ?', [self.id]) result = cursor.fetchone() conn.close() self.parent.lineEditName.setText(str(result[0])) self.parent.checkStay.setChecked(result[2]) self.table = Timetable.Timetable(self.parent.tableSchedule, json.loads(result[1]))
def __init__(self, id): self.id = id self.dialog = dialog = QtWidgets.QDialog() # From the qt_ui generated UI self.parent = parent = Parent.Ui_Dialog() parent.setupUi(dialog) if id: self.fillForm() else: # Create a new instance of timetable self.table = Timetable.Timetable(parent.tableSchedule) parent.btnFinish.clicked.connect(self.finish) parent.btnCancel.clicked.connect(self.dialog.close) dialog.exec_()
def __init__(self, id): self.id = id # New instance of dialog self.dialog = dialog = QtWidgets.QDialog() # Initialize custom dialog self.parent = parent = Parent.Ui_Dialog() # Add parent to custom dialog parent.setupUi(dialog) # Connect timetable widget with custom timetable model if id: self.fillForm() else: self.table = Timetable.Timetable(parent.tableSchedule) parent.btnFinish.clicked.connect(self.finish) parent.btnCancel.clicked.connect(self.dialog.close) dialog.exec_()
def __init__(self, id): self.id = id # Array of share IDs to be finalized self.shareId = [] # Array of share IDs to be removed self.removeShareId = [] self.dialog = dialog = QtWidgets.QDialog() # From the qt_ui generated UI self.parent = parent = Parent.Ui_Dialog() parent.setupUi(dialog) if id: self.fillForm() else: # Create new instance of timetable self.table = Timetable.Timetable(parent.tableSchedule) self.setupSubjects() parent.btnFinish.clicked.connect(self.finish) parent.btnCancel.clicked.connect(self.dialog.close) dialog.exec_()