Student.py

import tkinter as tk
from tkinter import *
from tkinter import ttk
from tkinter import messagebox as mBox
import pymysql
import Dbcon as Db


class StdupApp(tk.Tk):
    def __init__(self):
        super().__init__()
        self.title("STUDENT SIGNUP.")
        self.geometry("418x450+10+60")
        self.configure(bg="gray")
        self.resizable(0, 0)
        # ====================Variables========================#
        admno = tk.StringVar
        fname = tk.StringVar
        sname = tk.StringVar
        gender = tk.StringVar
        phoneno = tk.StringVar
        course = tk.StringVar
        upass = tk.StringVar
        cupass = tk.StringVar
        # ============================================================Frames============================================

        self.MFrame = LabelFrame(self, width=400, height=450, font=('arial', 15, 'bold'), \
                                     bg='lightblue', bd=15, relief='ridge')
        self.MFrame.grid(row=0, column=0, padx=10, pady=20)

        self.CFrame = LabelFrame(self.MFrame, width=300, height=300, font=('arial', 12, 'bold'), \
                                  relief='ridge', bd=10, bg='lightblue', text='SIGN UP')
        self.CFrame.grid(row=1, column=0, padx=10)

        self.EFrame = LabelFrame(self,width=200, height=100, font=('arial', 10, 'bold'), \
                                  bg='lightblue', relief='ridge', bd=13)
        self.EFrame.grid(row=2, column=0, pady=10)

        # ========================================================Labels of CFrame======================================
        self.Ladmno = Label(self.CFrame, text='STUDENT number:', font=('arial', 10, 'bold'), bg='lightblue')
        self.Ladmno.grid(row=0, column=0, sticky=W, padx=20, pady=10)
        self.Lfname = Label(self.CFrame, text='F Name:', font=('arial', 10, 'bold'), bg='lightblue')
        self.Lfname.grid(row=1, column=0, sticky=W, padx=20)
        self.Lsname = Label(self.CFrame, text='Sur Name:', font=('arial', 10, 'bold'), bg='lightblue')
        self.Lsname.grid(row=2, column=0, sticky=W, padx=20)
        self.Lgender = Label(self.CFrame, text='Gender:', font=('arial', 10, 'bold'), bg='lightblue')
        self.Lgender.grid(row=3, column=0, sticky=W, padx=20)
        self.Lphoneno = Label(self.CFrame, text='Phone No:', font=('arial', 10, 'bold'), bg='lightblue')
        self.Lphoneno.grid(row=4, column=0, sticky=W, padx=20)
        self.Lcourse = Label(self.CFrame, text='Course:', font=('arial', 10, 'bold'), bg='lightblue')
        self.Lcourse.grid(row=5, column=0, sticky=W, padx=20)
        self.Lupass = Label(self.CFrame, text='Password:', font=('arial', 10, 'bold'), bg='lightblue')
        self.Lupass.grid(row=6, column=0, sticky=W, padx=20)
        self.Lcupass = Label(self.CFrame, text='Confirm Password:', font=('arial', 10, 'bold'), bg='lightblue')
        self.Lcupass.grid(row=7, column=0, sticky=W, padx=20)

        # ========================================================Entries of CFrame=====================================
        self.Txtadmno = Entry(self.CFrame, font=('arial', 10, 'bold'), textvariable=admno)
        self.Txtadmno.grid(row=0, column=1, padx=10, pady=5)
        self.Txtfname = Entry(self.CFrame, font=('arial', 10, 'bold'), textvariable=fname)
        self.Txtfname.grid(row=1, column=1, padx=10, pady=5)
        self.Txtsname = Entry(self.CFrame, font=('arial', 10, 'bold'), textvariable=sname)
        self.Txtsname.grid(row=2, column=1, padx=10, pady=5)
        self.genderChosen = ttk.Combobox(self.CFrame, font=('arial', 10, 'bold'), width=17, textvariable=gender, state='readonly')
        self.genderChosen['values'] = ("MALE", "FEMALE")
        self.genderChosen.grid(row=3, column=1, padx=10, pady=5)
        self.genderChosen.current(0)
        self.Txtphoneno = Entry(self.CFrame, font=('arial', 10, 'bold'), textvariable=phoneno)
        self.Txtphoneno.grid(row=4, column=1, padx=10, pady=5)
        self.Txtcourse = Entry(self.CFrame, font=('arial', 10, 'bold'), textvariable=course)
        self.Txtcourse.grid(row=5, column=1, padx=10, pady=5)
        self.Txtupass = Entry(self.CFrame, font=('arial', 10, 'bold'), show = "*", textvariable=upass)
        self.Txtupass.grid(row=6, column=1, padx=10, pady=5)
        self.Txtcupass = Entry(self.CFrame, font=('arial', 10, 'bold'), show = "*", textvariable=cupass)
        self.Txtcupass.grid(row=7, column=1, padx=10, pady=5)

        # ========================================================Buttons of EFrame=====================================
        self.btnSave = Button(self.EFrame, text='SIGN UP', font=('arial', 10, 'bold'), width=8, command=self.savst)
        self.btnSave.grid(row=0, column=0, padx=10, pady=10)
        self.btnReset = Button(self.EFrame, text='RESET', font=('arial', 10, 'bold'), width=8, command=self.allclear)
        self.btnReset.grid(row=0, column=1, padx=10, pady=10)
        self.btnExit = Button(self.EFrame, text='EXIT', font=('arial', 10, 'bold'), width=8, command=self.exitt)
        self.btnExit.grid(row=0, column=2, padx=10, pady=10)

    # ==========Exit Function==========
    def exitt(self):
        result = mBox.askquestion(self, 'Are you sure you want to exit?', icon="warning")
        if result == 'yes':
            self.destroy()

    # ==========Clear Function==========
    def allclear(self):
        self.Txtadmno.delete(0, END)
        self.Txtfname.delete(0, END)
        self.Txtsname.delete(0, END)
        self.Txtphoneno.delete(0, END)
        self.Txtcourse.delete(0, END)
        self.Txtupass.delete(0, END)
        self.Txtcupass.delete(0, END)

    # ==========Register student Function==========
    def savst(self):
        admno = self.Txtadmno.get()
        fname = self.Txtfname.get()
        sname = self.Txtsname.get()
        gender = self.genderChosen.get()
        phoneno = self.Txtphoneno.get()
        course = self.Txtcourse.get()
        upass = self.Txtupass.get()
        cupass = self.Txtcupass.get()

        if admno == "" or fname == "" or sname == "" or gender == "" or phoneno == "" or course == ""or upass == "" or cupass == "":
            mBox.showerror(self, 'Error No Blanks allowed')
        elif upass != cupass:
            mBox.showerror(self, 'Passwords do not match')
        else:
            try:
                conn = pymysql.connect(**Db.dbConfig)
                cursor = conn.cursor()
                cursor.execute("select * from student where admno=%s", admno)
                rowcount = cursor.rowcount
                if cursor.rowcount == 1:
                    mBox.showinfo('Information', "student. already registered")
                else:
                    cursor.execute("select * from admissionnumber where admno=%s", admno)
                    rowcount1 = cursor.rowcount
                if cursor.rowcount != 1:
                    mBox.showinfo('Information', "Not valid Student number.")
                else:
                    cursor.execute("Insert into student( admno, fname, sname, gender, phoneno, course, upass, cupass)"
                                   "values(%s,%s,%s,%s,%s,%s,%s,%s)", (admno, fname, sname, gender, phoneno, course, upass, cupass))
                    conn.commit()
                    if cursor:
                        mBox.showinfo("Done", "Successfully Registered,Login")
                        self.destroy()
                    else:
                        mBox.showerror("Error", "Unable to Register")
                    cursor.close()
                    conn.close()
            except Exception as es:
                print('Error', f"due to :{str(es)}")


if __name__ == "__main__":
    stupapp = StdupApp()
    stupapp.mainloop()