def __init__(self, parent=None):
QtGui.QWidget.__init__(self, parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
icon = QtGui.QIcon()
b = QtGui.QPixmap("./pics/logo.png")
icon.addPixmap(b)
self.setWindowIcon(icon)
palette2 = QtGui.QPalette()
palette2.setBrush(self.backgroundRole(), QBrush(QImage("./pics/genback.png")))
self.setPalette(palette2)
self.setStyleSheet('color: rgb(85, 0, 0);')
self.grade = (self.ui.grade1, self.ui.grade2, self.ui.grade3, self.ui.grade4, self.ui.grade5, self.ui.grade6, self.ui.grade7, self.ui.grade8, )
self.num = (self.ui.num1, self.ui.num2, self.ui.num3, self.ui.num4, self.ui.num5, self.ui.num6, self.ui.num7, self.ui.num8, )
self.setall()
QtCore.QObject.connect(self.ui.done, QtCore.SIGNAL("clicked()"), self.doned)
class Startgrade(QtGui.QDialog):
grade = ()
num = ()
def __init__(self, parent=None):
QtGui.QWidget.__init__(self, parent)
self.ui = Ui_Dialog()
self.ui.setupUi(self)
icon = QtGui.QIcon()
b = QtGui.QPixmap("./pics/logo.png")
icon.addPixmap(b)
self.setWindowIcon(icon)
palette2 = QtGui.QPalette()
palette2.setBrush(self.backgroundRole(), QBrush(QImage("./pics/genback.png")))
self.setPalette(palette2)
self.setStyleSheet('color: rgb(85, 0, 0);')
self.grade = (self.ui.grade1, self.ui.grade2, self.ui.grade3, self.ui.grade4, self.ui.grade5, self.ui.grade6, self.ui.grade7, self.ui.grade8, )
self.num = (self.ui.num1, self.ui.num2, self.ui.num3, self.ui.num4, self.ui.num5, self.ui.num6, self.ui.num7, self.ui.num8, )
self.setall()
QtCore.QObject.connect(self.ui.done, QtCore.SIGNAL("clicked()"), self.doned)
# Saving the new grade format.
def doned(self):
cur.execute("update acads set grade = ?", (None, ))
con.commit()
cur.execute("delete from grades")
con.commit()
self.close()
i = 0
while(i<8):
if self.grade[i].text()!='':
t = (str(self.grade[i].text()), self.num[i].value(), )
cur.execute("insert into grades values(?, ?)", t)
con.commit()
i = i+1
cur.execute("select * from grades")
a = cur.fetchone()
# Showing the grade scheme already in the database.
def setall(self):
i=0
while(i<8):
self.grade[i].clear()
self.num[i].setValue(0)
i = i+1
cur.execute("select * from grades")
a = cur.fetchall()
i=0
cur.execute("select * from grades")
for row in cur:
self.grade[i].setText(row[0])
self.num[i].setValue(row[1])
i = i+1
