category.py

from cgitb import text
from multiprocessing import connection
import cx_Oracle
from tkinter import *
from PIL import Image,ImageTk #pip install pillow 
from tkinter import ttk,messagebox
class categoryClass:
 def __init__(self,root):
    self.root=root
    self.root.geometry('1100x500+200+130')
    self.root.title("inventory management system ||  developed By Sumit")
    self.root.config(bg="Cyan")
    self.root.focus_force()
    #============== variable =====================================
    self.var_cat_id=StringVar()
    self.var_name=StringVar()
    #=========== title ========================================
    lbl_title=Label(self.root,text="Manage Product Category",font=("time new roman",30),bg="#184a45",bd=3,relief=RIDGE,fg="white").pack(side=TOP,fill=X,padx=10,pady=10)

    lbl_name=Label(self.root,text="Enter Category Name",font=("time new roman",20,"bold"),bg="blue",fg="orange",bd=10).place(x=50,y=100)
    txt_name=Entry(self.root,textvariable=self.var_name,font=("time new roman",18),bg="lightyellow").place(x=50,y=170,width=300)
    
    btn_add=Button(self.root,text="ADD",command=self.add,font=("time new roman",15),bg="#4caf50",fg="white",cursor="hand2").place(x=360,y=170,width=150,height=30)

    btn_delete=Button(self.root,text="Delete",command=self.delete,font=("time new roman",15),bg="red",fg="white",cursor="hand2").place(x=520,y=170,width=150,height=30)

     #=========== category Detail ==============================================
    cat_frame=Frame(self.root,bd=3,relief=RIDGE)
    cat_frame.place(x=700,y=100,width=380,height=100)

    scrolly=Scrollbar(cat_frame,orient=VERTICAL)
    scrollx=Scrollbar(cat_frame,orient=HORIZONTAL)

    self.category_table=ttk.Treeview(cat_frame,columns=("cid","name"),yscrollcommand=scrolly.set,xscrollcommand=scrollx.set)
    scrollx.pack(side=BOTTOM,fill=X)
    scrolly.pack(side=RIGHT,fill=Y)
    scrollx.config(command=self.category_table.xview)
    scrolly.config(command=self.category_table.yview)
    self.category_table.heading("cid",text="C id")
    self.category_table.heading("name",text="Name")
    self.category_table["show"]="headings"

    self.category_table.column("cid",width=90)
    self.category_table.column("name",width=100)
    self.category_table.pack(fill=BOTH,expand=1)
    #self.category_table.bind("<ButtonRelease-1>",self.get_data)

    #============ Images ==============================
    self.im1=Image.open("images/cat.jpg")
    self.im1=self.im1.resize((500,250),Image.ANTIALIAS)
    self.im1=ImageTk.PhotoImage(self.im1)

    self.lbl_im1=Label(self.root,image=self.im1,bd=2,relief=RAISED)
    self.lbl_im1.place(x=50,y=220)

    self.im2=Image.open("images/category.jpg")
    self.im2=self.im2.resize((500,250),Image.ANTIALIAS)
    self.im2=ImageTk.PhotoImage(self.im2)

    self.lbl_im2=Label(self.root,image=self.im2,bd=2,relief=RAISED)
    self.lbl_im2.place(x=580,y=220)
    
    #self.show()

#=================== Backend ===================================
#===================add function ===============================
 def add(self):
      connection=cx_Oracle.connect('sumit/abhinav')
      cur=connection.Cursor()
      try:
         if self.var_name.get()=="":
               messagebox.showerror("Error","Category name should be required",parent=self.root)
                
         else:
               cur.execute("select *from category where name=?",(self.var_name.get(),))
               row=cur.fetchone()
               if row!=None:
                     messagebox.showerror("Error","Category already present,try different",parent=self.root)
               else:
                  cur.execute("Insert into category (name) values(?)",(self.var_name.get(),))
                  connection.Commit()
                  messagebox.showinfo("success","Category Added Successfully",parent=self.root)
                  self.show()

      except Exception as ex:
         messagebox.showerror("Error",f"Error due to : {str(ex)}",parent=self.root)
 def show(self):
      connection=cx_Oracle.connect('sumit/abhinav')
      cur=connection.Cursor()
      try:
         cur.execute("select *from category")
         rows=cur.fetchall()
         self.category_table.delete(*self.category_table.get_children())
         for row in rows:
               self.category_table.insert('',END,values=row)
      except Exception as ex:
         messagebox.showerror("Error",f"Error due to : {str(ex)}",parent=self.root)
         
 def get_data(self,ev):
      f=self.category_table.focus()
      content=(self.category_table.item(f))
      row=content['values']
      print(row)
      
      self.var_cat_id.set(row[0])
      self.var_name.set(row[1])
      
 def delete(self):
      connection=cx_Oracle.connect('sumit/abhinav')
      cur=connection.Cursor()
      try:
         if self.var_cat_id.get()=="":
               messagebox.showerror("Error","please select category from the list",parent=self.root)
                
         else:
               cur.execute("select *from category where cid=?",(self.var_cat_id.get(),))
               row=cur.fetchone()
               if row==None:
                     messagebox.showerror("Error","Error,please try again",parent=self.root)
               else:
                  op=messagebox.askyesno("confirm","Do you really want to delete?",parent=self.root)
                  if op==True:
                     cur.execute("delete from category where cid=?",(self.var_cat_id.get(),))
                     connection.commit()
                     messagebox.showinfo("Delete","category Deleted Successfully",parent=self.root)
                     self.show()
                     self.var_cat_id.set("")
                     self.var_name.set("")
      except Exception as ex:
         messagebox.showerror("Error",f"Error due to : {str(ex)}",parent=self.root)
 


if __name__=="__main__":
     root=Tk()
     obj=categoryClass(root)
     root.mainloop()