from tkinter import *
from tokenize import String
#from PIL import Image, ImageTk
import mysql.connector as mc

cnx = mc.connect(host="localhost", user="alen", password="alen", database="school")
cur = cnx.cursor()
cnx.autocommit = True

def is_connected():
    global cnx
    if (cnx):
        print("Successfully Connected")
        return True
    else:
        print("Connection Unsuccessful")
        return False

def login():
    window = Tk()
    window.geometry("960x606")
    window.resizable(0,0)
    window.title("LOGIN TO ALEN'S SCHOOL")
    window.iconbitmap("./ico/school.ico")

    bg = PhotoImage(file="./img/login.png")

    l1 = Label(window, image=bg)
    l1.place(x=0,y=0)

    l2 = Label(window, text="WELCOME TO LOGIN", width=100)
    l2.pack(pady=50)

    btn1 = Button(window, text="STUDENT", width=20, command=lambda: stud_login())
    btn1.pack(pady=10)

    btn2 = Button(window, text="TEACHER", width=20, command=lambda: teacher_login())
    btn2.pack(pady=10)

    btn3 = Button(window, text="STAFF", width=20, command=lambda: staff_login())
    btn3.pack(pady=10)

    btn4 = Button(window, text="ADMIN", width=20, command=lambda: admn_login())
    btn4.pack(pady=10)

    btn4 = Button(window, text="EXIT", width=20, command=lambda: window.destroy())
    btn4.pack(pady=10)

    window.mainloop()

def stud_login():
    global cur
    window1 = Tk()
    window1.geometry('960x606')
    window1.resizable(0,0)
    window1.title("STUDENT LOGIN")
    window1.iconbitmap("./ico/student.ico")

    l1 = Label(window1)
    l1.place(x=0, y=0)

    l2 =Label(window1, text="WELCOME TO STUDENT LOGIN", width=100)
    l2.pack(pady=50)

    uname_label = Label(window1, text="USERNAME ")
    uname_label.place(x=450, y=140)

    uname_var = StringVar()
    uname_entry = Entry(window1, textvariable=uname_var)
    uname_entry.place(x=425, y=160)

    pswd_label = Label(window1, text="PASSWORD ")
    pswd_label.place(x=450, y=210)

    pswd_var = StringVar()
    pswd_entry = Entry(window1, show="*", textvariable=pswd_var)
    pswd_entry.place(x=425, y=230)

    uname = uname_var.get()
    passwd = pswd_var.get()

    lgn_btn = Button(window1, text="LOGIN", command=lambda: stud_lgn_btn(uname, passwd))
    lgn_btn.place(x=400, y=280)

    exit_btn = Button(window1, text="EXIT", command=lambda: window1.destroy())
    exit_btn.place(x=540, y=280)

def teacher_login():
    global cur
    window2 = Tk()
    window2.geometry('960x606')
    window2.resizable(0,0)
    window2.title("TEACHER LOGIN")
    window2.iconbitmap("./ico/teacher.ico")

    l1 = Label(window2)
    l1.place(x=0, y=0)

    l2 = Label(window2, text="WELCOME TO TEACHER LOGIN PAGE")
    l2.pack()

    uname_label = Label(window2, text="USERNAME ")
    uname_label.place(x=450, y=140)

    uname_entry = Entry(window2)
    uname_entry.place(x=425, y=160)

    pswd_label = Label(window2, text="PASSWORD ")
    pswd_label.place(x=450, y=210)

    pswd_entry = Entry(window2, show="*")
    pswd_entry.place(x=425, y=230)

    uname = uname_entry.get()
    passwd = pswd_entry.get()

    lgn_btn = Button(window2, text="LOGIN", command=lambda: teacher_lgn_btn(uname, passwd))
    lgn_btn.place(x=400, y=280)

    exit_btn = Button(window2, text="EXIT", command=lambda: window2.destroy())
    exit_btn.place(x=540, y=280)

def staff_login():
    global cur
    window3 = Tk()
    window3.geometry('960x606')
    window3.resizable(0,0)
    window3.title("STAFF LOGIN")
    window3.iconbitmap("./ico/staff.ico")

    l1 = Label(window3)
    l1.place(x=0, y=0)

    l2 = Label(window3, text="WELCOME TO STAFF LOGIN")
    l2.pack()

    uname_label = Label(window3, text="USERNAME ")
    uname_label.place(x=450, y=140)

    uname_entry = Entry(window3)
    uname_entry.place(x=425, y=160)

    pswd_label = Label(window3, text="PASSWORD ")
    pswd_label.place(x=450, y=210)

    pswd_entry = Entry(window3, show="*")
    pswd_entry.place(x=425, y=230)

    uname = uname_entry.get()
    passwd = pswd_entry.get()

    lgn_btn = Button(window3, text="LOGIN", command=lambda: staff_lgn_btn(uname, passwd))
    lgn_btn.place(x=400, y=280)

    exit_btn = Button(window3, text="EXIT", command=lambda: window3.destroy())
    exit_btn.place(x=540, y=280)

def admn_login():
    global cur
    window4 = Tk()
    window4.geometry('960x606')
    window4.resizable(0,0)
    window4.title("ADMIN LOGIN")
    window4.iconbitmap("./ico/admin.ico")

    l1 = Label(window4)
    l1.place(x=0, y=0)

    l2 = Label(window4, text="WELCOME TO ADMIN LOGIN")
    l2.pack()

    uname_label = Label(window4, text="USERNAME ")
    uname_label.place(x=450, y=140)

    uname_entry = Entry(window4)
    uname_entry.place(x=425, y=160)

    pswd_label = Label(window4, text="PASSWORD ")
    pswd_label.place(x=450, y=210)

    pswd_entry = Entry(window4, show="*")
    pswd_entry.place(x=425, y=230)

    uname = uname_entry.get()
    passwd = pswd_entry.get()

    lgn_btn = Button(window4, text="LOGIN", command=lambda: admn_lgn_btn(uname, passwd))
    lgn_btn.place(x=400, y=280)

    exit_btn = Button(window4, text="EXIT", command=lambda: window4.destroy())
    exit_btn.place(x=540, y=280)

def stud_lgn_btn(uname, passwd):
    global cur

    cur.execute("SELECT * FROM STUDENTS WHERE USERNAME=%s AND PASSWORD=%s", (uname, passwd))
    a = cur.fetchall()

    print(a)

def teacher_lgn_btn(uname, passwd):
    pass

def staff_lgn_btn(uname, passwd):
    pass

def admn_lgn_btn(uname, passwd):
    pass

def stud_home():
    pass

def teacher_home():
    pass

def staff_home():
    pass

def admn_home():
    pass

if __name__ == "__main__":
    if is_connected():
        login()