class EditStudentFrame:
def __init__(self, frame, table):
self.edit_frame = frame
self.display_table = table
self.stud_class = Student()
self.data = self.stud_class.data
self.filename = self.stud_class.filename
self.id_no = StringVar()
self.name = StringVar()
self.course = StringVar()
self.year = StringVar()
self.gender = StringVar()
self.rows = []
self.select = False
# Edit
self.edit_name_entry = Entry(self.edit_frame,
textvariable=self.name,
highlightthickness=2,
highlightbackground="#A51d23",
font=("Bebas Neue", 20))
self.edit_id_entry = Entry(self.edit_frame,
textvariable=self.id_no,
highlightthickness=2,
highlightbackground="#A51d23",
font=("Bebas Neue", 20))
self.edit_year_combo = ttk.Combobox(self.edit_frame,
textvariable=self.year,
font=("Bebas Neue", 20),
values=[
"1st Year", "2nd Year",
"3rd Year", "4th Year",
"5th Year"
])
self.edit_course_entry = Entry(self.edit_frame,
textvariable=self.course,
font=("Bebas Neue", 18),
highlightthickness=2,
highlightbackground="#A51d23")
self.edit_gender_combo = ttk.Combobox(
self.edit_frame,
textvariable=self.gender,
font=("Bebas Neue", 20),
values=["Male", "Female", "Other"])
self.edit_frame.place(x=20, y=120, width=400, height=410)
# GUI for selecting student to be updated
choose_label = Label(self.edit_frame,
text="Select Student to Edit",
anchor='w',
fg="#A51d23",
bg="white",
font=("Oswald", 14))
choose_label.place(x=20, y=28, width=220, height=30)
choose_stud_btn = Button(self.edit_frame,
command=self.select_stud,
text="Select",
bg="#A51d23",
fg="white",
font=("Bebas Neue", 20))
choose_stud_btn.place(x=280, y=28, width=90, height=30)
# attributes on edit student feature
name_format = Label(self.edit_frame,
text="Last Name, First Name, M.I",
font=("Oswald", 10),
fg="#A51d23",
bg="white")
name_format.place(x=115, y=121, height=20)
name_label = Label(self.edit_frame,
text="Name:",
font=("Bebas Neue", 20),
bg="#A51d23",
fg="white")
name_label.place(x=20, y=80, width=90, height=40)
self.edit_name_entry.place(x=110, y=80, width=270, height=40)
id_no_label = Label(self.edit_frame,
text="ID No.:",
font=("Bebas Neue", 20),
bg="#A51d23",
fg="white")
id_no_label.place(x=20, y=150, width=90, height=40)
self.edit_id_entry.place(x=110, y=150, width=270, height=40)
year_label = Label(self.edit_frame,
text="Year:",
font=("Bebas Neue", 20),
bg="#A51d23",
fg="white")
year_label.place(x=20, y=200, width=90, height=40)
self.edit_year_combo.place(x=110, y=200, width=270, height=40)
course_label = Label(self.edit_frame,
text="Course:",
font=("Bebas Neue", 20),
bg="#A51d23",
fg="white")
course_label.place(x=20, y=250, width=90, height=40)
self.edit_course_entry.place(x=110, y=250, width=270, height=40)
gender_label = Label(self.edit_frame,
text="Gender:",
font=("Bebas Neue", 20),
bg="#A51d23",
fg="white")
gender_label.place(x=20, y=300, width=90, height=40)
self.edit_gender_combo.place(x=110, y=300, width=270, height=40)
# buttons for add student feature
update_info_button = Button(self.edit_frame,
command=self.update_student,
text="Update",
bg="#A51d23",
fg="white",
font=("Bebas Neue", 20))
update_info_button.place(x=170, y=360, width=90, height=30)
clear_info_button = Button(self.edit_frame,
command=self.clear_data,
text="Clear",
bg="#A51d23",
fg="white",
font=("Bebas Neue", 20))
clear_info_button.place(x=280, y=360, width=90, height=30)
def clear_data(self):
self.edit_id_entry.delete(0, END)
self.edit_name_entry.delete(0, END)
self.edit_year_combo.delete(0, END)
self.edit_course_entry.delete(0, END)
self.edit_gender_combo.delete(0, END)
def update_student(self):
if not self.select:
messagebox.showerror("Error", "Select a student first")
return
else:
msg = messagebox.askquestion(
"Update Student",
"Are you sure you want to update the student's information?")
if msg == "yes":
if self.name.get() == "" or self.id_no.get() == "" or self.year == "" or self.course.get() == "" \
or self.gender.get() == "":
messagebox.showerror("Error", "Please fill out all fields")
elif self.stud_class.id_checker(self.id_no.get()):
if self.id_no.get(
) in self.data and self.id_no.get() != self.rows[0]:
overwrite = messagebox.askquestion(
'Overwrite Student',
'ID Number already in database, do you '
'wish to overwrite the student information?')
if overwrite == "no":
return
if self.rows[0] in self.data:
self.data[self.rows[0]] = {
'Name': self.name.get().upper(),
'Course': self.course.get().upper(),
'Year': self.year.get(),
'Gender': self.gender.get()
}
self.data[self.id_no.get()] = self.data.pop(
self.rows[0])
self.stud_class.data_to_csv()
messagebox.showinfo(
"Success!",
"Student information has been updated!")
self.stud_class.display_student_table(
self.display_table)
self.clear_data()
return
else:
return
def select_stud(self):
cursor_row = self.display_table.focus()
contents = self.display_table.item(cursor_row)
rows = contents['values']
self.clear_data()
if rows == "":
messagebox.showerror("Error", "Select a student first")
self.select = False
return
else:
self.edit_name_entry.insert(0, rows[1])
self.edit_id_entry.insert(0, rows[0])
self.edit_year_combo.insert(0, rows[3])
self.edit_course_entry.insert(0, rows[2])
self.edit_gender_combo.insert(0, rows[4])
self.rows = rows
self.select = True
return
class AddStudentFrame:
def __init__(self, frame, table):
self.add_frame = frame
self.display_table = table
self.studclass = Student()
self.data = self.studclass.data
self.filename = self.studclass.filename
self.id_no = StringVar()
self.name = StringVar()
self.course = StringVar()
self.year = StringVar()
self.gender = StringVar()
self.add_name_entry = Entry(self.add_frame, textvariable=self.name, highlightthickness=2,
highlightbackground="#A51d23", font=("Bebas Neue", 20))
self.add_id_entry = Entry(self.add_frame, textvariable=self.id_no, highlightthickness=2,
highlightbackground="#A51d23", font=("Bebas Neue", 20))
self.add_year_combo = ttk.Combobox(self.add_frame, textvariable=self.year, font=("Bebas Neue", 20),
values=[
"1st Year",
"2nd Year",
"3rd Year",
"4th Year",
"5th Year"])
self.add_course_entry = Entry(self.add_frame, textvariable=self.course, highlightthickness=2,
highlightbackground="#A51d23", font=("Bebas Neue", 18))
self.add_gender_combo = ttk.Combobox(self.add_frame, textvariable=self.gender, font=("Bebas Neue", 20),
values=["Male", "Female", "Other"])
# add_student_interface
self.add_frame.place(x=20, y=120, width=400, height=410)
# attributes of the add student feature
name_label = Label(self.add_frame, text="Name:", font=("Bebas Neue", 20), bg="#A51d23", fg="white")
name_label.place(x=20, y=50, width=90, height=40)
self.add_name_entry.place(x=110, y=50, width=270, height=40)
id_no_label = Label(self.add_frame, text="ID No.:", font=("Bebas Neue", 20), bg="#A51d23", fg="white")
id_no_label.place(x=20, y=120, width=90, height=40)
name_format = Label(self.add_frame, text="Last Name, First Name, M.I", font=("Oswald", 10), fg="#A51d23",
bg="white")
name_format.place(x=115, y=91, height=20)
self.add_id_entry.place(x=110, y=120, width=270, height=40)
year_label = Label(self.add_frame, text="Year:", font=("Bebas Neue", 20), bg="#A51d23", fg="white")
year_label.place(x=20, y=170, width=90, height=40)
self.add_year_combo.place(x=110, y=170, width=270, height=40)
course_label = Label(self.add_frame, text="Course:", font=("Bebas Neue", 20), bg="#A51d23", fg="white")
course_label.place(x=20, y=220, width=90, height=40)
self.add_course_entry.place(x=110, y=220, width=270, height=40)
gender_label = Label(self.add_frame, text="Gender:", font=("Bebas Neue", 20), bg="#A51d23", fg="white")
gender_label.place(x=20, y=270, width=90, height=40)
self.add_gender_combo.place(x=110, y=270, width=270, height=40)
# buttons on add student
add_info_button = Button(self.add_frame, command=self.add_student, text="Add", bg="#A51d23", fg="white",
font=("Bebas Neue", 20))
add_info_button.place(x=170, y=340, width=90, height=30)
clear_info_button = Button(self.add_frame, command=self.clear_data, text="Clear", bg="#A51d23", fg="white",
font=("Bebas Neue", 20))
clear_info_button.place(x=280, y=340, width=90, height=30)
def clear_data(self):
self.add_id_entry.delete(0, END)
self.add_name_entry.delete(0, END)
self.add_course_entry.delete(0, END)
self.add_year_combo.delete(0, END)
self.add_gender_combo.delete(0, END)
def add_student(self):
msg = messagebox.askquestion('Add Student', 'Are you sure you want to add the student?')
if msg == "yes":
if self.name.get() == "" or self.id_no.get() == "" or self.year == "" or self.course.get() == "" \
or self.gender.get() == "":
messagebox.showerror("Error", "Please fill out all fields")
elif self.studclass.id_checker(self.id_no.get()):
if self.id_no.get() in self.data:
overwrite = messagebox.askquestion('Overwrite Student', 'ID Number already in database, do you '
'wish to overwrite the student information?'
)
if overwrite == "no":
return
self.data[self.id_no.get()] = {'Name': self.name.get().upper(),
'Course': self.course.get().upper(),
'Year': self.year.get(), 'Gender': self.gender.get()}
self.studclass.data_to_csv()
messagebox.showinfo("Success!", "Student added to database!")
self.studclass.display_student_table(self.display_table)
self.clear_data()
return
else:
return
class DeleteStudentFrame:
def __init__(self, frame, table):
self.delete_frame = frame
self.display_table = table
self.stud_class = Student()
self.data = self.stud_class.data
self.id_no = StringVar()
self.name = StringVar()
self.course = StringVar()
self.year = StringVar()
self.gender = StringVar()
self.rows = []
self.select = False
# Delete Frame
self.del_stud_name = Label(self.delete_frame,
fg="black",
bg="white",
font=("Bebas Neue", 16),
anchor='w')
self.del_stud_id = Label(self.delete_frame,
fg="black",
bg="white",
font=("Bebas Neue", 16),
anchor='w')
self.del_stud_year = Label(self.delete_frame,
fg="black",
bg="white",
font=("Bebas Neue", 16),
anchor='w')
self.del_stud_course = Label(self.delete_frame,
fg="black",
bg="white",
font=("Bebas Neue", 16),
anchor='w')
self.del_stud_gender = Label(self.delete_frame,
fg="black",
bg="white",
font=("Bebas Neue", 16),
anchor='w')
self.delete_frame.place(x=20, y=120, width=400, height=410)
choose_lbl = Label(self.delete_frame,
text="Select Student to Delete",
anchor='w',
fg="#A51d23",
bg="white",
font=("Oswald", 14))
choose_lbl.place(x=20, y=30, width=220, height=30)
choose_stud_btn = Button(self.delete_frame,
command=self.select_stud,
text="Select",
bg="#A51d23",
fg="white",
font=("Bebas Neue", 20))
choose_stud_btn.place(x=280, y=30, width=90, height=30)
name_label = Label(self.delete_frame,
text="Name:",
font=("Bebas Neue", 20),
bg="#A51d23",
fg="white")
name_label.place(x=20, y=80, width=90, height=40)
id_no_label = Label(self.delete_frame,
text="ID No.:",
font=("Bebas Neue", 20),
bg="#A51d23",
fg="white")
id_no_label.place(x=20, y=130, width=90, height=40)
year_label = Label(self.delete_frame,
text="Year:",
font=("Bebas Neue", 20),
bg="#A51d23",
fg="white")
year_label.place(x=20, y=180, width=90, height=40)
course_label = Label(self.delete_frame,
text="Course:",
font=("Bebas Neue", 20),
bg="#A51d23",
fg="white")
course_label.place(x=20, y=230, width=90, height=40)
gender_label = Label(self.delete_frame,
text="Gender:",
font=("Bebas Neue", 20),
bg="#A51d23",
fg="white")
gender_label.place(x=20, y=280, width=90, height=40)
delete_button = Button(self.delete_frame,
command=self.delete_student,
text="Delete",
bg="#A51d23",
fg="white",
font=("Bebas Neue", 20))
delete_button.place(x=280, y=350, width=90, height=30)
self.del_stud_name.place(x=115, y=80, width=250, height=40)
self.del_stud_id.place(x=115, y=130, width=200, height=40)
self.del_stud_year.place(x=115, y=180, width=200, height=40)
self.del_stud_course.place(x=115, y=230, width=200, height=40)
self.del_stud_gender.place(x=115, y=280, width=200, height=40)
def clear_data(self):
self.del_stud_name.config(text="")
self.del_stud_id.config(text="")
self.del_stud_course.config(text="")
self.del_stud_year.config(text="")
self.del_stud_gender.config(text="")
def delete_student(self):
if not self.select:
messagebox.showerror("Error", "Select a student first")
return
else:
msg = messagebox.askquestion(
'Delete Student',
'Are you sure you want to delete the student?')
if msg == "yes":
self.data.pop(self.rows[0], None)
self.stud_class.data_to_csv()
messagebox.showinfo("Success!", "Student has been deleted!")
self.stud_class.display_student_table(self.display_table)
self.clear_data()
return
else:
return
def select_stud(self):
cursor_row = self.display_table.focus()
contents = self.display_table.item(cursor_row)
rows = contents['values']
if rows == "":
messagebox.showerror("Error", "Select a student first")
self.select = False
return
else:
self.del_stud_name.config(text=rows[1])
self.del_stud_id.config(text=rows[0])
self.del_stud_year.config(text=rows[3])
self.del_stud_course.config(text=rows[2])
self.del_stud_gender.config(text=rows[4])
self.rows = rows
self.select = True
return