def __init__(self):
QtGui.QDialog.__init__(self)
self.admin = Ui_addAdminDialog()
self.admin.setupUi(self)
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.admin.teacherComboBox.addItem(self.name)
self.admin.ok_btn.clicked.connect(self.submit)
self.admin.cancel_btn.clicked.connect(self.close)
def __init__(self):
QtGui.QDialog.__init__(self)
self.admin = Ui_addAdminDialog()
self.admin.setupUi(self)
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.admin.teacherComboBox.addItem(self.name)
self.admin.ok_btn.clicked.connect(self.submit)
self.admin.cancel_btn.clicked.connect(self.close)
class addAdmin(QtGui.QDialog):
def __init__(self):
QtGui.QDialog.__init__(self)
self.admin = Ui_addAdminDialog()
self.admin.setupUi(self)
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.admin.teacherComboBox.addItem(self.name)
self.admin.ok_btn.clicked.connect(self.submit)
self.admin.cancel_btn.clicked.connect(self.close)
def submit(self):
self.selected = self.admin.teacherComboBox.currentIndex()
self.selected = self.idList[self.selected]
self.name = self.admin.teacherComboBox.currentText()
self.check_query = QSqlQuery()
self.check_query.exec_("Select Admin_name From Admin")
while self.check_query.next():
self.record = self.check_query.record()
if self.name == str(self.record.value(0)):
self.message = "%s is already an admin" % self.name
self.confirmReply = QtGui.QMessageBox.information(self, 'Error',
self.message)
return
self.confirmMessage = "Are you sure you want to make '%s' an admin" \
%(self.name)
self.confirmReply = QtGui.QMessageBox.question(self, 'Confirm',
self.confirmMessage, QtGui.QMessageBox.Yes, QtGui.QMessageBox.No)
if (self.confirmReply == QtGui.QMessageBox.Yes):
self.id_query =QSqlQuery()
self.id_query.exec_("SELECT Admin_id FROM Admin ORDER BY Admin_id DESC LIMIT 1")
while self.id_query.next():
self.record = self.id_query.record()
self.Admin_id = self.record.value(0)
self.Admin_id += 1
self.confirm_query = QSqlQuery()
self.confirm_query.exec_("SELECT * From Teacher Where Teacher_id = %d" % (int(self.selected)) )
if self.confirm_query.next():
self.record = self.confirm_query.record()
self.name = str(self.record.value(1))
self.home = str(self.record.value(2))
self.cell = str(self.record.value(3))
self.work = str(self.record.value(4))
self.address_id = str(self.record.value(5))
self.email = str(self.record.value(6))
self.gender = str(self.record.value(7))
self.number = str(self.record.value(8))
self.pay = str(self.record.value(9))
self.medical = str(self.record.value(10))
self.DOB = str(self.record.value(11))
self.confirm_query.exec_("Insert into Admin (Admin_id,Admin_name,\
Admin_home_phone, Admin_cell_phone, Admin_work_phone,\
Admin_address, Admin_email, Admin_sex, Admin_SSN, \
Admin_pay_rate, Admin_medical_information, Admin_date_of_birth)\
values(%d,'%s', '%s', '%s','%s',%d,'%s','%s', '%s', '%s', '%s','%s')"
%(int(self.Admin_id), self.name, self.home, self.cell, self.work,\
int(self.address_id), self.email, self.gender, self.number, self.pay,\
self.medical, self.DOB))
self.confirm_query.exec_("Update Account SET Admin_id = %d Where Teacher_id = %d" % (int(self.Admin_id), int(self.selected)) )
self.close()
class addAdmin(QtGui.QDialog):
def __init__(self):
QtGui.QDialog.__init__(self)
self.admin = Ui_addAdminDialog()
self.admin.setupUi(self)
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.admin.teacherComboBox.addItem(self.name)
self.admin.ok_btn.clicked.connect(self.submit)
self.admin.cancel_btn.clicked.connect(self.close)
def submit(self):
self.selected = self.admin.teacherComboBox.currentIndex()
self.selected = self.idList[self.selected]
self.name = self.admin.teacherComboBox.currentText()
self.check_query = QSqlQuery()
self.check_query.exec_("Select Admin_name From Admin")
while self.check_query.next():
self.record = self.check_query.record()
if self.name == str(self.record.value(0)):
self.message = "%s is already an admin" % self.name
self.confirmReply = QtGui.QMessageBox.information(
self, 'Error', self.message)
return
self.confirmMessage = "Are you sure you want to make '%s' an admin" \
%(self.name)
self.confirmReply = QtGui.QMessageBox.question(self, 'Confirm',
self.confirmMessage,
QtGui.QMessageBox.Yes,
QtGui.QMessageBox.No)
if (self.confirmReply == QtGui.QMessageBox.Yes):
self.id_query = QSqlQuery()
self.id_query.exec_(
"SELECT Admin_id FROM Admin ORDER BY Admin_id DESC LIMIT 1")
while self.id_query.next():
self.record = self.id_query.record()
self.Admin_id = self.record.value(0)
self.Admin_id += 1
self.confirm_query = QSqlQuery()
self.confirm_query.exec_(
"SELECT * From Teacher Where Teacher_id = %d" %
(int(self.selected)))
if self.confirm_query.next():
self.record = self.confirm_query.record()
self.name = str(self.record.value(1))
self.home = str(self.record.value(2))
self.cell = str(self.record.value(3))
self.work = str(self.record.value(4))
self.address_id = str(self.record.value(5))
self.email = str(self.record.value(6))
self.gender = str(self.record.value(7))
self.number = str(self.record.value(8))
self.pay = str(self.record.value(9))
self.medical = str(self.record.value(10))
self.DOB = str(self.record.value(11))
self.confirm_query.exec_("Insert into Admin (Admin_id,Admin_name,\
Admin_home_phone, Admin_cell_phone, Admin_work_phone,\
Admin_address, Admin_email, Admin_sex, Admin_SSN, \
Admin_pay_rate, Admin_medical_information, Admin_date_of_birth)\
values(%d,'%s', '%s', '%s','%s',%d,'%s','%s', '%s', '%s', '%s','%s')"
%(int(self.Admin_id), self.name, self.home, self.cell, self.work,\
int(self.address_id), self.email, self.gender, self.number, self.pay,\
self.medical, self.DOB))
self.confirm_query.exec_(
"Update Account SET Admin_id = %d Where Teacher_id = %d" %
(int(self.Admin_id), int(self.selected)))
self.close()
