def save():
cursor.execute('USE tabulationSystemKu')
for i in range(21):
if year1.get() and term.get() and crseNo[i].get():
cursor.execute(
"INSERT INTO coursetable (yearborsho,term,courseno,coursetitle,credit)"
"VALUES ('{}','{}','{}','{}',{})".format(
year1.get(), term.get(), crseNo[i].get().strip(),
crseTitle[i].get().strip(), creditHrs[i].get()))
conn.commit()
win.destroy()
main.showMainPage()
def save():
try:
cursor.execute("USE tabulationSystemKU")
cursor.execute("DELETE FROM courseConfiguration")
cursor.execute(
"INSERT INTO courseConfiguration (year,term,session,creditLimit,batch)"
"VALUES ('{}','{}','{}','{}','{}')".format(
year.get(), term.get(), session.get(),
creditLimit.get(), bathcVariable.get()))
conn.commit()
win.destroy()
main.showMainPage()
except pymysql.Error as err:
print(err)
def login_info_check(self, username, password):
try:
cursor.execute("USE tabulationSystemKU")
cursor.execute("SELECT * FROM login")
#print(cursor.fetchone())
except pymysql.Error as err:
print(err)
data = cursor.fetchone()
#print(data[1],data[2],username,password)
# print(data[1],username,data[2],password)
if (data[1] == username and data[2] == password):
Login.win.destroy()
main.showMainPage()
else:
messagebox.showerror('ERROR', "Username and password mismatched")
def save():
counter=0
if(not subject.get()):
messagebox.showerror("ERROR","PLEASE SELECT SUBJECT")
else:
for i in range(10):
if(prerequites_variable[i].get() and prerequites_variable[i].get() != subject.get()):
counter+=1
try:
cursor.execute("INSERT INTO prerequisite_table (course,prerequisite)"
"VALUES ('{}','{}')".format(subject.get().strip(),prerequites_variable[i].get().strip()))
except pymysql.Error as err:
print(err)
conn.commit()
messagebox.showinfo("SUCCESSFULL","YOU HAVE SUCCESSFULLY ADDED " +str(counter)+ " "
"SUBJECT(S) AS PREREQUISITE")
win.destroy()
main.showMainPage()
def save():
if(new_password_variable.get() != re_enter_new_password_variable.get()):
messagebox.showerror("ERROR","NEW PASSWORD MISMATCHED")
elif old_password != old_password_variable.get():
messagebox.showerror("ERROR","INCORRECT OLD PASSWORD")
elif len(new_password_variable.get())<3:
messagebox.showerror("ERROR","LENGTH OF THE PASSWORD SHOULD BE AT LEAST 3")
else:
try:
cursor.execute("UPDATE login SET password='******' where username='******'".format(
new_password_variable.get(),"admin"))
conn.commit()
messagebox.showinfo("SUCCESSFUL", "YOUR PASSWORD IS SUCCESSFULLY CHANGED")
win.destroy()
main.showMainPage()
except pymysql.Error as err:
print(err)
def withdraw():
withdraw_list = list()
counter = 0
for i in range(len(checkButton)):
if checkButton[i].get() == 1:
withdraw_list.append(course_no_list[i].get())
counter += 1
try:
for j in withdraw_list:
cursor.execute(
"DELETE FROM registration WHERE courseNo='{}'".format(
j))
except pymysql.Error as err:
print(err)
conn.commit()
messagebox.showinfo(
"SUCCESSFULL",
"SUCCESSFULLY WITHDRAWN " + str(counter) + " COURSES")
print(withdraw_list)
win.destroy()
main.showMainPage()
def save():
if len(btch.get()) > 2 or len(btch.get()) == 0:
messagebox.showinfo("INVALID INPUT",
"Please insert last two digits of batch")
else:
for i in range(200):
if name[i].get():
try:
cursor.execute('USE tabulationSystemKU')
cursor.execute(
"INSERT INTO students (rollNo,name,batch,tech,tecp)"
"VALUES('{}','{}','{}','{}','{}')".format(
(str(btch.get()) +
NewStudentForm.disciplineCode(None) +
str(rollNo[i].get()).strip()),
name[i].get(), btch.get(), 0.0, 0.0))
conn.commit()
except pymysql.Error as err:
print(err)
win.destroy()
main.showMainPage()
def doSomething():
win.destroy()
main.showMainPage()
def save():
counter = 0
taken = list()
for i in self.taken_courses:
taken.append(i)
print("retakeSuubjectList")
print(retakeSubjectList)
temp = list()
for i in retakeSubjectList:
if (i[4] == rollVariable.get()):
temp.append(i[0])
print(taken, temp)
prerequisite_dict = prerequisite(taken, temp)
if (prerequisite_dict):
print("PREREQUISITE")
print(prerequisite_dict)
text = " PREREQUISITE LIST\n"
for i in prerequisite_dict:
text += str(i) + " " + prerequisite_dict[i] + "\n"
messagebox.showerror("PREREQUISITE ERROR", text)
# prerequisite_dict.clear()
#taken.clear()
# prerequite_test.clear()
prerequisite_test_function()
else:
totalCredit = 0.0
try:
cursor.execute("USE tabulationSystemKU")
for i in range(22):
if (retakeVariable[i].get()):
self.retakeValue = 1
else:
self.retakeValue = 0
if coursenolist[i].get() and coursetititlelist[i].get(
):
counter += 1
cursor.execute(
"INSERT INTO registration (rollNo,courseNo,year,term,es,retake)"
"VALUES ('{}','{}','{}','{}','{}','{}')".
format(rollVariable.get(),
coursenolist[i].get(),
yearVariable.get(), termVariable.get(),
sessionVariable.get(),
self.retakeValue))
totalCredit += course_credit_list[i].get()
if totalCredit <= 25.00:
#print(retakeValue,retakeVariable[i].get())
print(totalCredit)
self.taken_courses.clear()
conn.commit()
if (counter):
messagebox.showinfo(
"SUCCESSFUL",
"COURSE REGISTRATION SUCCESSFULLY COMPLETED")
win.destroy()
main.showMainPage()
else:
messagebox.showerror(
"CREDIT LIMIT CROSSED",
"YOU CAN REGISTER FOR AT MOST 25.00 CREDITS HOURS")
print(totalCredit)
except pymysql.Error as err:
print(err)
def save():
try:
cursor.execute(
"SELECT DISTINCT courseNo,rollNo from registration WHERE retake = 1"
)
retakeTuple2 = cursor.fetchall()
print(retakeTuple2)
except pymysql.Error as err:
print(err)
try:
cursor.execute("USE tabulationSystemKU")
if self.flag == 1:
for i in range(100):
if attendance_variable[i].get() and class_test_variable[i].get() and sectionA_variable[i].get() and session.get() and year.get() and term.get()\
and courseVariable.get() and batch.get() and sectionB_variable[i].get():
total_marks = int(attendance_variable[i].get())+int(class_test_variable[i].get())+\
int(sectionA_variable[i].get())+int(sectionB_variable[i].get())
for j in retakeTuple2:
print(j[0], courseVariable.get())
if (j[0] == courseVariable.get()
and batch.get() + disciplineCode[0] +
roll_variable[i].get() == j[1]):
total_marks -= 5
if (total_marks < 40):
total_marks = 40
elif total_marks >= 80:
total_marks = 75
print(total_marks)
break
print(total_marks)
gpa_grade = calculateMarks.calculate(total_marks)
#print(gpa_grade[0],gpa_grade[1])
cursor.execute(
"INSERT INTO theory_result (session,year,term,courseNo,roll,attendance,ct,"
"seca,secb,gpa,grade)"
"VALUES ('{}','{}','{}','{}','{}','{}','{}','{}','{}','{}','{}')"
.format(
session.get(), year.get(), term.get(),
courseVariable.get(),
batch.get() + disciplineCode[0] +
roll_variable[i].get(),
attendance_variable[i].get(),
class_test_variable[i].get(),
sectionA_variable[i].get(),
sectionB_variable[i].get(), gpa_grade[0],
gpa_grade[1]))
conn.commit()
win.destroy()
main.showMainPage()
else:
for i in range(100):
if attendance_variable[i].get() and class_test_variable[i].get() and sectionA_variable[i].get() and session.get() and year.get() and term.get()\
and courseVariable.get() and batch.get():
total_marks = int(attendance_variable[i].get())+int(class_test_variable[i].get())+\
int(sectionA_variable[i].get())
for j in retakeTuple2:
print(j[0], courseVariable.get())
if (j[0] == courseVariable.get()
and batch.get() + disciplineCode[0] +
roll_variable[i].get() == j[1]):
total_marks -= 5
if (total_marks < 40):
total_marks = 40
elif total_marks >= 80:
total_marks = 75
print(total_marks)
break
print(total_marks)
gpa_grade = calculateMarks.calculate(total_marks)
#print(gpa_grade[0],gpa_grade[1])
cursor.execute(
"INSERT INTO sessional_result (session,year,term,courseNo,roll,attendance,"
"sa,viva,gpa,grade)"
"VALUES ('{}','{}','{}','{}','{}','{}','{}','{}','{}','{}')"
.format(
session.get(), year.get(), term.get(),
courseVariable.get(),
batch.get() + disciplineCode[0] +
roll_variable[i].get(),
attendance_variable[i].get(),
class_test_variable[i].get(),
sectionA_variable[i].get(), gpa_grade[0],
gpa_grade[1]))
conn.commit()
win.destroy()
main.showMainPage()
except pymysql.Error as err:
print(err)
def on_closing(self):
main.showMainPage()
