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()