admin.py

from tkinter import *
import backend

class admin:
        def __init__(self,window):
            self.window = window

            self.frame = Frame(self.window, bg = 'orange', width=800,height=450)

            self.frame.pack()

            self.label = Label(self.frame,text='Admin User',bg='Orange',font=('Georgia',30,'bold'))
            self.label.place(x=20,y=20,width=400,height=50)

            self.label_title = Label(self.frame, text='TITLE',bg='orange',font=('Georgia',14,'bold'))
            self.label_title.place(x=20,y=100,width=100,height=50)

            self.label_year = Label(self.frame, text='YEAR',bg='orange',font=('Georgia',14,'bold'))
            self.label_year.place(x=20,y=150,width=100,height=30)

            self.label_author = Label(self.frame, text='AUTHOR',bg='orange',font=('Georgia',14,'bold'))
            self.label_author.place(x=350,y=100,width=100,height=30)

            self.label_isbn = Label(self.frame, text='ISBN',bg='orange',font=('Georgia',14,'bold'))
            self.label_isbn.place(x=350,y=150,width=100,height=30)

            self.title_text=StringVar()
            self.entry_title = Entry(self.frame, fg='gray',textvariable=self.title_text,width=25,font=('Arial',12,'bold'))
            self.entry_title.place(x=120,y=100,width=150,height=30)

            self.year_text=StringVar()
            self.entry_year = Entry(self.frame, fg='gray',textvariable=self.year_text,width=25,font=('Arial',12,'bold'))
            self.entry_year.place(x=120,y=150,width=150,height=30)

            self.author_text=StringVar()
            self.entry_author = Entry(self.frame, fg='gray',textvariable=self.author_text,width=25,font=('Arial',12,'bold'))
            self.entry_author.place(x=470,y=100,width=150,height=30)

            self.isbn_text=StringVar()
            self.entry_isbn = Entry(self.frame, fg='gray',textvariable=self.isbn_text,width=25,font=('Arial',12,'bold'))
            self.entry_isbn.place(x=470,y=150,width=150,height=30)

            self.listbox = Listbox(self.frame)
            self.listbox.place(x=100,y=200,width=500,height=100)

            self.button_view = Button(self.frame,text='View All', command=self.view_command)
            self.button_view.place(x=100,y=320,width=100,height=40)

            self.button_search = Button(self.frame,text='Search ', command=self.search_command)
            self.button_search.place(x=200,y=320,width=100,height=40)

            self.button_add = Button(self.frame,text='Add entry', command=self.add_command)
            self.button_add.place(x=300,y=320,width=100,height=40)

            self.button_update = Button(self.frame, text='Update entry', command=self.update_command)
            self.button_update.place(x=400, y=320,width=100,height=40)

            self.button_delete = Button(self.frame, text='Delete entry', command=self.delete_command)
            self.button_delete.place(x=500, y=320,width=100,height=40)

            self.button_issue = Button(self.frame, text='Clear Fields', command=self.clear_command)
            self.button_issue.place(x=100, y=360,width=100,height=40)

            self.button_request = Button(self.frame, text='Requested Books', command=self.requestsearch_command)
            self.button_request.place(x=300, y=360,width=100,height=40)

            self.button_issue = Button(self.frame, text='Issued Books', command=self.issuesearch_command)
            self.button_issue.place(x=500, y=360,width=100,height=40)


        def destroy(self):
            self.button_issuedelete.destroy()
            self.button_requestdelete.destroy()

        def clear_command(self):
            self.entry_title.delete(0,END)
            self.entry_year.delete(0,END)
            self.entry_author.delete(0,END)
            self.entry_isbn.delete(0,END)

        def issuedelete_command(self):
            selected_tuple=self.listbox.curselection()
            value = self.listbox.get(selected_tuple)
            backend.issue_delete(value[0])
            self.entry_title.delete(0,END)
            #self.entry_title.insert(END,value[1])
            self.entry_year.delete(0,END)
            #self.entry_year.insert(END,value[3])
            self.entry_author.delete(0,END)
            #self.entry_author.insert(END,value[2])
            self.entry_isbn.delete(0,END)
            #self.entry_isbn.insert(END,value[4])

        def issuesearch_command(self):
            self.listbox.delete(0,END) # it will empty the list every time it is called
            for row in backend.issue_view(self.title_text.get(),self.author_text.get(),self.year_text.get(),self.isbn_text.get()):
                self.listbox.insert(END,row)

            self.button_issuedelete = Button(self.frame, text='Book Returned', command=self.issuedelete_command)
            self.button_issuedelete.place(x=400, y=360,width=100,height=40)

        def requestsearch_command(self):
            self.listbox.delete(0,END)
            for row in backend.request_view(self.title_text.get(),self.author_text.get(),self.year_text.get(),self.isbn_text.get()):
                self.listbox.insert(END,row)

            self.button_requestdelete = Button(self.frame, text='Request Listened', command=self.requestcomplete_command)
            self.button_requestdelete.place(x=200, y=360,width=100,height=40)

        def requestcomplete_command(self):
            selected_tuple=self.listbox.curselection()
            value = self.listbox.get(selected_tuple)
            backend.request_delete(value[0])
            self.entry_title.delete(0,END)
            #self.entry_title.insert(END,value[0])
            self.entry_year.delete(0,END)
            #self.entry_year.insert(END,value[2])
            self.entry_author.delete(0,END)
            #self.entry_author.insert(END,value[1])
            self.entry_isbn.delete(0,END)
            #self.entry_isbn.insert(END,value[3])

        def view_command(self):
            self.listbox.delete(0,END)
            for row in backend.view():
                self.listbox.insert(END,row) # END ensures that every new entry is stored at end of the all rows
            self.destroy()

        def search_command(self):
            self.listbox.delete(0,END)
            for row in backend.search(self.title_text.get(),self.author_text.get(),self.year_text.get(),self.isbn_text.get()):
                self.listbox.insert(END,row)
                self.destroy()

        def add_command(self):
            backend.insert(self.title_text.get(),self.author_text.get(),self.year_text.get(),self.isbn_text.get())
            self.listbox.delete(0,END)
            self.listbox.insert(END,(self.title_text.get(),self.author_text.get(),self.year_text.get(),self.isbn_text.get()))
            self.destroy()

        def delete_command(self):
            selected_tuple=self.listbox.curselection()
            value = self.listbox.get(selected_tuple)
            backend.delete(value[0])    # i have to use value[0] here or at backend use id[0]
            self.entry_title.delete(0,END)
            self.entry_title.insert(END,value[1])
            self.entry_year.delete(0,END)
            self.entry_year.insert(END,value[3])
            self.entry_author.delete(0,END)
            self.entry_author.insert(END,value[2])
            self.entry_isbn.delete(0,END)
            self.entry_isbn.insert(END,value[4])
            self.destroy()

        def update_command(self):
            selected_tuple=self.listbox.curselection()
            value = self.listbox.get(selected_tuple)
            self.entry_title.delete(0,END)
            self.entry_title.insert(END,value[0])
            self.entry_year.delete(0,END)
            self.entry_year.insert(END,value[2])
            self.entry_author.delete(0,END)
            self.entry_author.insert(END,value[1])
            self.entry_isbn.delete(0,END)
            self.entry_isbn.insert(END,value[3])
            backend.update(value[0],self.title_text.get(),self.author_text.get(),self.year_text.get(),self.isbn_text.get())

'''
window = Tk()
window.title('Admin_User')
window.geometry('700x450')
obj = admin(window)
window.mainloop()'''