Student-Result-Management-System/result.py at main · AamirHussainoo7/Student-Result-Management-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
from tkinter import*
from PIL import Image,ImageTk
from tkinter import ttk,messagebox
import sqlite3
class ResultClass:
    def __init__(self,home):
        self.home=home
        self.home.title("Student Result Management System")
        self.home.geometry("1200x500+80+170")
        self.home.config(bg="white")
        self.home.focus_force()

    #Title of result
        title=Label(self.home,text="Manage Student Results",font=("times new roman",20,"bold"),bg="#CC3366",fg="white").place(x=0,y=0,relwidth=1,height=50)


    #Variables
        self.var_roll=StringVar()
        self.var_name=StringVar()
        self.var_course=StringVar()
        self.var_marks=StringVar()
        self.var_full_marks=StringVar()
        self.roll_list=[]
    # Function calling from fetch
        self.fetch_roll()

    #Sections
        lbl_select = Label(self.home,text="Select Student",font=("times new roman",20,"bold"),bg="white").place(x=50,y=100)
        lbl_name = Label(self.home,text="Name",font=("times new roman",20,"bold"),bg="white").place(x=50,y=160)
        lbl_course = Label(self.home,text="Course",font=("times new roman",20,"bold"),bg="white").place(x=50,y=220)
        lbl_marks = Label(self.home,text="Marks Obtained",font=("times new roman",20,"bold"),bg="white").place(x=50,y=280)
        lbl_full_marks = Label(self.home,text="Full Marks",font=("times new roman",20,"bold"),bg="white").place(x=50,y=340)

        self.student1 = ttk.Combobox(self.home,textvariable=self.var_roll,values=self.roll_list,font=("times new roman",15,"bold"),state="readonly",justify=CENTER)
        self.student1.place(x=280,y=100,width=200)
        self.student1.set("Select")

        btn_search=Button(self.home,text="Search",font=("times new roman",15,"bold"),bg="blue",fg="white",cursor="hand2",command=self.search).place(x=500,y=100,width=100,height=28)

        txt_name = Entry(self.home,textvariable=self.var_name,font=("times new roman",20,"bold"),bg="lightyellow",state="readonly").place(x=280,y=160,width=320,height=30)
        txt_course = Entry(self.home,textvariable=self.var_course,font=("times new roman",20,"bold"),bg="lightyellow",state="readonly").place(x=280,y=220,width=320,height=30)
        txt_marks = Entry(self.home,textvariable=self.var_marks,font=("times new roman",20,"bold"),bg="lightyellow").place(x=280,y=280,width=320,height=30)
        txt_full_marks = Entry(self.home,textvariable=self.var_full_marks,font=("times new roman",20,"bold"),bg="lightyellow").place(x=280,y=340,width=320,height=30)

    #Buttons
        self.add=Button(self.home,text="Submit",font=("times new roman",15,"bold"),bg="lightblue",activebackground="lightblue",cursor="hand2",command=self.add)
        self.add.place(x=300,y=420,width=120,height=35)
        self.clear=Button(self.home,text="Clear",font=("times new roman",15,"bold"),bg="lightgreen",activebackground="lightgreen",cursor="hand2",command=self.clear).place(x=430,y=420,width=120,height=35)

    #Image
        self.bgImage=Image.open("Images/Result.png")
        self.bgImage=self.bgImage.resize((530,300),Image.ANTIALIAS)
        self.bgImage=ImageTk.PhotoImage(self.bgImage)

        self.lbl_bg=Label(self.home,image=self.bgImage).place(x=640,y=100)

# Fetch to show roll no. in select student tab
    def fetch_roll(self):
        conn=sqlite3.connect(database="ResultManagementSystem.db")
        cur=conn.cursor()
        try:
            cur.execute("Select roll no from student")
            rows=cur.fetchall()
            if len(rows)>0:
                for row in rows:
                    self.roll_list.append(row[0])

        except Exception as ex:
            messagebox.showerror("Error",f"Error due to {str(ex)}")

#For Search tab functioning
    def search(self):
        conn=sqlite3.connect(database="ResultManagementSystem.db")
        cur=conn.cursor()
        try:
            cur.execute("Select name,course from student where roll=?",(self.var_roll.get(),))
            row=cur.fetchone()
            if row !=None:
                self.var_name.set(row[0])
                self.var_course.set(row[1])
            else:
                messagebox.showerror("Error","No record Found",parent=self.home)
        except Exception as ex:
            messagebox.showerror("Error",f"Error due to {str(ex)}")


    def add(self):
        conn=sqlite3.connect(database="ResultManagementSystem.db")
        cur=conn.cursor()
        try:
            if self.var_name.get()=="":
                messagebox.showerror("Error","Please First Search Student Record",parent=self.home)
            else:
                cur.execute("Select * from result where roll=? and course=?",(self.var_roll.get(),self.var_course.get())) #Due to tupple we added , at last
                row=cur.fetchone()
                if row!=None:
                    messagebox.showerror("Error, Result already Present",parent=self.home)
                else:
                    percentage=(int(self.var_marks.get())*100)/int(self.var_full_marks.get())
                    cur.execute("Insert into result(roll,name,course,marks_obtain,full_marks,percentage) values(?,?,?,?,?,?)",(
                        self.var_roll.get(),
                        self.var_name.get(),
                        self.var_course.get(),
                        self.var_marks.get(),
                        self.var_full_marks.get(),
                        str(percentage)

                    ) )
                    conn.commit()
                    messagebox.showinfo("Great","Result Added Successfully",parent=self.home)

        except Exception as ex:
            messagebox.showerror("Error",f"Error due to {str(ex)}")

    def clear(self):
        self.var_roll.set("Select"),
        self.var_name.set(""),
        self.var_course.set(""),
        self.var_marks.set(""),
        self.var_full_marks.set("")


if __name__=="__main__":
    home=Tk()
    obj=ResultClass(home)
    home.mainloop()