def __init__(self):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need cathch exeption
Addstu_query = QSqlQuery()
Addstu_query.exec_("Select Class_name from Class")
model = QSqlQueryModel()
model.setQuery(Addstu_query)
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_listView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
def __init__(self, name=None):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need catch exeption
Addstu_query = QSqlQuery()
#get list of class
Addstu_query.exec_("Select Class_name from Class ORDER BY Class_name")
model = QSqlQueryModel()
model.setQuery(Addstu_query)
#populate classes to listview
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_tableView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
def __init__(self, name=None):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need catch exeption
Addstu_query = QSqlQuery()
Addstu_query.exec_(
"Select Class_name from Class as C, Teacher_Class as\
TC, Teacher as T where T.Teacher_id = TC.Teacher_id and \
T.Teacher_id = (select Teacher_id from Account where User_name = \
'%s') and TC.Class_id = C.Class_id ORDER BY Class_name"
% name)
model = QSqlQueryModel()
model.setQuery(Addstu_query)
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_tableView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
def __init__(self, name = None):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need catch exeption
Addstu_query = QSqlQuery()
#get list of class
Addstu_query.exec_("Select Class_name from Class ORDER BY Class_name")
model = QSqlQueryModel()
model.setQuery(Addstu_query)
#populate classes to listview
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_tableView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
def __init__(self, name = None):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need catch exeption
Addstu_query = QSqlQuery()
Addstu_query.exec_("Select Class_name from Class as C, Teacher_Class as\
TC, Teacher as T where T.Teacher_id = TC.Teacher_id and \
T.Teacher_id = (select Teacher_id from Account where User_name = \
'%s') and TC.Class_id = C.Class_id ORDER BY Class_name" % name)
model = QSqlQueryModel()
model.setQuery(Addstu_query)
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_tableView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
class Addstu_window(QtGui.QMainWindow):
def __init__(self, name = None):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need catch exeption
Addstu_query = QSqlQuery()
#get list of class
Addstu_query.exec_("Select Class_name from Class ORDER BY Class_name")
model = QSqlQueryModel()
model.setQuery(Addstu_query)
#populate classes to listview
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_tableView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
#get new window to select student
def add_student(self):
self.ui.detail = Addstu_detail_dialog(self.class_name)
self.ui.detail.show()
#revome student from the class
def remove_student(self):
Remove_query = QSqlQuery()
if Remove_query.exec_("Update Student_Class Set Class_approval = -1 Where\
Student_id = (Select Student_id from Student Where Student_name = \
'%s') and Class_id = (Select Class_id from Class where \
Class_name = '%s')" % (self.stu_name, self.class_name)):
#get corresponding refund
refund(self.class_name, self.stu_name)
QtGui.QMessageBox.information(
self, 'Success', 'Remove student from class successfully')
def select_student(self, index):
status = -1
status_query = QSqlQuery()
status_query.exec_("Select SC.Class_approval from Student_Class as SC,Student as S where\
SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
and SC.Student_id = S.Student_id and SC.Class_finished <> 1 \
and S.Student_name = '%s' ORDER BY S.Student_name" \
% (self.selectedClass, index.data()))
if(status_query.next()):
record = status_query.record()
status = int(record.value(0));
if (status != -1):
self.ui.Remove_stu_btn.setEnabled(True)
else:
self.ui.Remove_stu_btn.setEnabled(False)
self.stu_name = index.data()
def show_student(self, index):
self.selectedClass = index.data();
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(True)
Student_query = QSqlQuery()
Student_query.exec_("Select S.Student_name, SC.Class_approval from Student_Class as SC,Student as S where\
SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
and SC.Student_id = S.Student_id and SC.Class_finished <> 1 \
ORDER BY S.Student_name" % index.data())
self.class_name = index.data()
model = QSqlQueryModel()
model.setQuery(Student_query)
self.ui.Stu_tableView.setModel(model)
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 Addstu_window(QtGui.QMainWindow):
def __init__(self, name=None):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need catch exeption
Addstu_query = QSqlQuery()
Addstu_query.exec_(
"Select Class_name from Class as C, Teacher_Class as\
TC, Teacher as T where T.Teacher_id = TC.Teacher_id and \
T.Teacher_id = (select Teacher_id from Account where User_name = \
'%s') and TC.Class_id = C.Class_id ORDER BY Class_name"
% name)
model = QSqlQueryModel()
model.setQuery(Addstu_query)
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_tableView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
def add_student(self):
self.ui.detail = Addstu_detail_dialog(self.class_name)
self.ui.detail.show()
def remove_student(self):
Remove_query = QSqlQuery()
if Remove_query.exec_(
"Update Student_Class Set Class_approval = -1 Where\
Student_id = (Select Student_id from Student Where Student_name = \
'%s') and Class_id = (Select Class_id from Class where \
Class_name = '%s')" %
(self.stu_name, self.class_name)):
refund(self.class_name, self.stu_name)
QtGui.QMessageBox.information(
self, 'Success', 'Remove student from class successfully')
def select_student(self, index):
status = -1
status_query = QSqlQuery()
status_query.exec_("Select SC.Class_approval from Student_Class as SC,Student as S where\
SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
and SC.Student_id = S.Student_id and SC.Class_finished <> 1 \
and S.Student_name = '%s' ORDER BY S.Student_name" \
% (self.selectedClass, index.data()))
if (status_query.next()):
record = status_query.record()
status = int(record.value(0))
if (status != -1):
self.ui.Remove_stu_btn.setEnabled(True)
else:
self.ui.Remove_stu_btn.setEnabled(False)
self.stu_name = index.data()
def show_student(self, index):
self.selectedClass = index.data()
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(True)
Student_query = QSqlQuery()
Student_query.exec_(
"Select S.Student_name, SC.Class_approval from Student_Class as SC,Student as S where\
SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
and SC.Student_id = S.Student_id and SC.Class_finished <> 1 \
ORDER BY S.Student_name" % index.data())
self.class_name = index.data()
model = QSqlQueryModel()
model.setQuery(Student_query)
self.ui.Stu_tableView.setModel(model)
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 Addstu_window(QtGui.QMainWindow):
def __init__(self):
QtGui.QMainWindow.__init__(self)
self.ui = Ui_Addstu_window()
self.ui.setupUi(self)
self.conn() #need cathch exeption
Addstu_query = QSqlQuery()
Addstu_query.exec_("Select Class_name from Class")
model = QSqlQueryModel()
model.setQuery(Addstu_query)
self.ui.Class_listView.setModel(model)
self.ui.Class_listView.clicked.connect(self.show_student)
self.ui.Stu_listView.clicked.connect(self.select_student)
self.ui.Remove_stu_btn.clicked.connect(self.remove_student)
self.ui.Add_stu_btn.clicked.connect(self.add_student)
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(False)
def add_student(self):
self.ui.detail = Addstu_detail_dialog(self.class_name)
self.ui.detail.show()
def remove_student(self):
Remove_query = QSqlQuery()
if Remove_query.exec_(
"Update Student_Class Set Class_approval = -1 Where\
Student_id = (Select Student_id from Student Where Student_name = \
'%s') and Class_id = (Select Class_id from Class where \
Class_name = '%s')" %
(self.stu_name, self.class_name)):
QtGui.QMessageBox.information(
self, 'Success', 'Remove student from class successfully')
def select_student(self, index):
self.ui.Remove_stu_btn.setEnabled(True)
self.stu_name = index.data()
def show_student(self, index):
self.ui.Remove_stu_btn.setEnabled(False)
self.ui.Add_stu_btn.setEnabled(True)
Student_query = QSqlQuery()
Student_query.exec_(
"Select S.Student_name from Student_Class as SC,Student as S where\
SC.Class_id = (Select Class_id from Class where Class_name = '%s') \
and SC.Student_id = S.Student_id and SC.Class_finished <> 1 and \
SC.Class_approval <> -1" % index.data())
self.class_name = index.data()
model = QSqlQueryModel()
model.setQuery(Student_query)
self.ui.Stu_listView.setModel(model)
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()
