from sqlite3 import *

from tkinter import *

from tkinter.ttk import *

from tkinter.messagebox import * 



con = connect("DETAILS.db")

cur = con.cursor()



w = Tk()

w.title("Register")

w.geometry("700x400")

w.resizable(False,False)

#Style

s = Style()
s.configure('Header.TFrame', background = 'blue')

header_frame = Frame(w,style = "Header.TFrame")
header_frame.pack(fill = X)

s.configure('TLabel', background = 'Blue', foreground = "White",font = ("Arial", 25))
header_label = Label(header_frame, text = "Register")
header_label.pack(pady = 10)

s.configure("Content.TFrame", background = 'white')
content_frame  = Frame(w,style = 'Content.TFrame')
content_frame.pack(fill = BOTH,expand = TRUE)

login_frame = Frame(content_frame ,style = 'Content.TFrame')
login_frame.place(relx = .5,rely  = .5,anchor = CENTER)

s.configure('Login.TLabel', background = 'white',foreground = "Black",font = ("arial",15))

#personal name entry


Name_label = Label(login_frame,text = "Enter Your Name: ",style = 'Login.TLabel')
Name_label.grid(row  = 0,column = 0)

Name_Entry = Entry(login_frame,width = 25)
Name_Entry.grid(row = 0, column = 1,pady = 5,padx = 5)

#DOB


DOB_label = Label(login_frame,text = 'DOB(dd/mm/yyyy): ',style = 'Login.TLabel')
DOB_label.grid(row = 1,column = 0)

DOB_entry = Entry(login_frame,width = 25)
DOB_entry.grid(row = 1,column = 1,pady = 5,padx = 5)


#Father Name entry

FN_label = Label(login_frame,text = "Enter Your Father Name: ",style = 'Login.TLabel')
FN_label.grid(row  = 2,column = 0)

FN_Entry = Entry(login_frame,width = 25)
FN_Entry.grid(row = 2, column = 1,pady = 5,padx = 5)

#Mother Name entry

MN_label = Label(login_frame,text = "Enter Your Mother Name: ",style = 'Login.TLabel')
MN_label.grid(row  = 3,column = 0)

MN_Entry = Entry(login_frame,width = 25)
MN_Entry.grid(row = 3, column = 1,pady = 5,padx = 5)

#Gender

gender_label = Label(login_frame,text = "Choose your gender: ",style = 'Login.TLabel')
gender_label.grid(row = 4, column = 0)

gender = IntVar()
boy_gender = Radiobutton(login_frame,text = "Boy",value = 1,variable = gender)
boy_gender.grid(row = 4,column = 1)

girl_gender = Radiobutton(login_frame,text = "Girl",value = 2,variable = gender)
girl_gender.grid(row = 4,column = 2)

#class

Class_label = Label(login_frame,text = "Select your class: ",style = 'Login.TLabel')
Class_label.grid(row = 5,column = 0)

Classes = ("I","II","III","IV","V","VI","VII","VIII","IX","X","XI","XII")
class_combo = Combobox(login_frame,state = "readonly",values = Classes)
class_combo.grid(row = 5,column = 1,pady = 5,padx = 5)
class_combo.set("Your Class")

#submit
G = ""
def submit():
    if gender.get() == 1:
        global G
        G = "Boy"
    elif gender.get() == 2:
        G = "Girl"

    cur.execute("insert into Student( Name,DOB,Father,Mother,Gender,C) values(?,?,?,?,?,?)",(str(Name_Entry.get()),str(DOB_entry.get()),str(FN_Entry.get()),str(MN_Entry.get()),str(G),str(class_combo.get())))
    con.commit()
    print("Data is successfully added")
    showinfo("Message","Name: " +str(Name_Entry.get())+"\n DOB: "+str(DOB_entry.get())+"\n Father's Name: "+str(FN_Entry.get())+"\n Mother's Name: "+str(MN_Entry.get())+"\n Gender: "+str(G)+"\n Class: "+str(class_combo.get()))
sub_button = Button(login_frame,text = "Save",command = submit)
sub_button.grid(row = 6,column =1)


w.mainloop()