def __init__(self):
QtGui.QDialog.__init__(self)
self.removeTeach = Ui_removeTeacherDialog()
self.removeTeach.setupUi(self)
self.conn()
self.removeTeach.sel_teach = QSqlRelationalTableModel(db=self.db)
self.removeTeach.sel_teach.setTable("Teacher")
if not self.conn():
QtGui.QMessageBox.warning(self, 'Error',
'database contecting error')
self.idList = []
self.teach_query = QSqlQuery()
self.teach_query.exec_("Select Teacher_name, Teacher_id FROM Teacher")
while self.teach_query.next():
record = self.teach_query.record()
self.name = str(record.value(0))
self.id = str(record.value(1))
self.idList.append(self.id)
self.removeTeach.teacherComboBox.addItem(self.name)
self.removeTeach.ok_btn.clicked.connect(self.submit)
self.removeTeach.cancel_btn.clicked.connect(self.close)
def __init__(self):
QtGui.QDialog.__init__(self)
self.removeTeach = Ui_removeTeacherDialog()
self.removeTeach.setupUi(self)
self.conn()
self.removeTeach.sel_teach = QSqlRelationalTableModel(db = self.db)
self.removeTeach.sel_teach.setTable("Teacher")
if not self.conn():
QtGui.QMessageBox.warning(
self, 'Error', 'database contecting error')
self.idList = []
self.teach_query = QSqlQuery()
self.teach_query.exec_("Select Teacher_name, Teacher_id FROM Teacher")
while self.teach_query.next():
record = self.teach_query.record()
self.name = str(record.value(0))
self.id = str(record.value(1))
self.idList.append(self.id)
self.removeTeach.teacherComboBox.addItem(self.name)
self.removeTeach.ok_btn.clicked.connect(self.submit)
self.removeTeach.cancel_btn.clicked.connect(self.close)
class removeTeacher(QtGui.QDialog):
def __init__(self):
QtGui.QDialog.__init__(self)
self.removeTeach = Ui_removeTeacherDialog()
self.removeTeach.setupUi(self)
self.conn()
self.removeTeach.sel_teach = QSqlRelationalTableModel(db=self.db)
self.removeTeach.sel_teach.setTable("Teacher")
if not self.conn():
QtGui.QMessageBox.warning(self, 'Error',
'database contecting error')
self.idList = []
self.teach_query = QSqlQuery()
self.teach_query.exec_("Select Teacher_name, Teacher_id FROM Teacher")
while self.teach_query.next():
record = self.teach_query.record()
self.name = str(record.value(0))
self.id = str(record.value(1))
self.idList.append(self.id)
self.removeTeach.teacherComboBox.addItem(self.name)
self.removeTeach.ok_btn.clicked.connect(self.submit)
self.removeTeach.cancel_btn.clicked.connect(self.close)
def submit(self):
self.addressCounter = 0
self.selectedTeacher = self.removeTeach.teacherComboBox.currentIndex()
self.selectedTeacherId = self.idList[self.selectedTeacher]
self.getAddress = QSqlQuery()
self.getAddress.exec_("Select Teacher_address from Teacher WHERE \
Teacher_address = (Select Teacher_address from Teacher WHERE\
Teacher_id = '%s')" % self.selectedTeacherId)
while self.getAddress.next():
record = self.getAddress.record()
self.addressId = int(record.value(0))
self.addressCounter += 1
self.confirmMessage = "Are you sure you want to remove '%s' from the system? This will remove all relevant information and can not be reversed." \
%(self.removeTeach.teacherComboBox.currentText())
self.confirmReply = QtGui.QMessageBox.question(self, 'Confirm',
self.confirmMessage,
QtGui.QMessageBox.Yes,
QtGui.QMessageBox.No)
if (self.confirmReply == QtGui.QMessageBox.Yes):
self.confirm_query = QSqlQuery()
self.teach_query.exec_(
"DELETE from Teacher WHERE Teacher_id = '%s'" %
self.selectedTeacherId)
self.teach_query.exec_("Delete From Admin WHERE Admin_id = \
(select Admin_id from Account where Teacher_id = '%s')"
% self.selectedTeacherId)
self.teach_query.exec_(
"DELETE from Account WHERE Teacher_id = '%s'" %
self.selectedTeacherId)
self.teach_query.exec_(
"DELETE from Teacher_Payrate WHERE Teacher_id = '%s'" %
self.selectedTeacherId)
self.teach_query.exec_(
"UPDATE Teacher_Class SET Teacher_id = 0 WHERE Teacher_id = '%s'"
% self.selectedTeacherId)
if (self.addressCounter == 1):
self.teach_query.exec_(
"DELETE from Address WHERE Address_id = %d" %
self.addressId)
self.message = "Teacher removed, classes taught by this teacher will need to be reasigned"
self.confirmReply = QtGui.QMessageBox.information(
self, 'Message', self.message)
def conn(self):
self.db = QSqlDatabase.addDatabase("QMYSQL")
self.db.setHostName("services1.mcs.sdsmt.edu")
self.db.setDatabaseName("db_dancesoft_f15")
self.db.setUserName("dancesoft_f15")
self.db.setPassword("DanceSoft")
return self.db.open()
class removeTeacher(QtGui.QDialog):
def __init__(self):
QtGui.QDialog.__init__(self)
self.removeTeach = Ui_removeTeacherDialog()
self.removeTeach.setupUi(self)
self.conn()
self.removeTeach.sel_teach = QSqlRelationalTableModel(db = self.db)
self.removeTeach.sel_teach.setTable("Teacher")
if not self.conn():
QtGui.QMessageBox.warning(
self, 'Error', 'database contecting error')
self.idList = []
self.teach_query = QSqlQuery()
self.teach_query.exec_("Select Teacher_name, Teacher_id FROM Teacher")
while self.teach_query.next():
record = self.teach_query.record()
self.name = str(record.value(0))
self.id = str(record.value(1))
self.idList.append(self.id)
self.removeTeach.teacherComboBox.addItem(self.name)
self.removeTeach.ok_btn.clicked.connect(self.submit)
self.removeTeach.cancel_btn.clicked.connect(self.close)
def submit(self):
self.addressCounter = 0
self.selectedTeacher = self.removeTeach.teacherComboBox.currentIndex()
self.selectedTeacherId = self.idList[self.selectedTeacher]
self.getAddress = QSqlQuery()
self.getAddress.exec_("Select Teacher_address from Teacher WHERE \
Teacher_address = (Select Teacher_address from Teacher WHERE\
Teacher_id = '%s')" % self.selectedTeacherId)
while self.getAddress.next():
record = self.getAddress.record()
self.addressId = int(record.value(0))
self.addressCounter += 1
self.confirmMessage = "Are you sure you want to remove '%s' from the system? This will remove all relevant information and can not be reversed." \
%(self.removeTeach.teacherComboBox.currentText())
self.confirmReply = QtGui.QMessageBox.question(self, 'Confirm',
self.confirmMessage, QtGui.QMessageBox.Yes, QtGui.QMessageBox.No)
if (self.confirmReply == QtGui.QMessageBox.Yes):
self.confirm_query = QSqlQuery()
self.teach_query.exec_("DELETE from Teacher WHERE Teacher_id = '%s'" % self.selectedTeacherId)
self.teach_query.exec_("Delete From Admin WHERE Admin_id = \
(select Admin_id from Account where Teacher_id = '%s')" % self.selectedTeacherId)
self.teach_query.exec_("DELETE from Account WHERE Teacher_id = '%s'" % self.selectedTeacherId)
self.teach_query.exec_("DELETE from Teacher_Payrate WHERE Teacher_id = '%s'" % self.selectedTeacherId)
self.teach_query.exec_("UPDATE Teacher_Class SET Teacher_id = 0 WHERE Teacher_id = '%s'" % self.selectedTeacherId)
if (self.addressCounter == 1):
self.teach_query.exec_("DELETE from Address WHERE Address_id = %d" % self.addressId)
self.message = "Teacher removed, classes taught by this teacher will need to be reasigned"
self.confirmReply = QtGui.QMessageBox.information(self, 'Message',
self.message)
def conn(self):
self.db = QSqlDatabase.addDatabase("QMYSQL")
self.db.setHostName("services1.mcs.sdsmt.edu")
self.db.setDatabaseName("db_dancesoft_f15")
self.db.setUserName("dancesoft_f15")
self.db.setPassword("DanceSoft")
return self.db.open()
