def search(id): cnx=DBconnection.connect() cur=cnx.cursor() query="select * from user where userid=%s" data=[] data.append(id) cur.execute(query,data) d=cur.fetchall() if cur.rowcount==0: cur.close() cnx.close() return None for i in d: u=User() u.setUserid(int(i[0])) u.setUsername(i[1]) u.setPassword(i[2]) u.setUsertype(i[3]) u.setUserstatus(bool(i[4])) u.setName(i[5]) u.setEmail(i[6]) u.setContact(i[7]) u.setAddress(i[8]) u.setGender(bool(i[9])) cur.close() cnx.close() return u
def btn_save_clicked(self):
usr=User()
usr.setUsertype(self.usertype.get())
usr.setUserstatus(int(self.userstatus.get()))
usr.setName(self.name.get())
usr.setEmail(self.email.get())
usr.setContact(self.contact.get())
usr.setAddress(self.address.get(1.0,"end"))
usr.setGender(int(self.gender.get()))
if self.add_edit_flag=="add":
usr.setUsername(self.username.get())
usr.setPassword("user")
if UMS.add(usr)==True:
messagebox.showinfo("Add User","User record added Succesfully, default password is 'user'")
else:
messagebox.showerror("Add User","User record already exists")
elif self.add_edit_flag=="edit":
self.userid.config(state="normal")
usr.setUserid(self.userid.get())
self.userid.config(state="disabled")
if UMS.updateUser(usr):
messagebox.showinfo("Edit user record","User record updated successfully")
else:
messagebox.showerror("Edit user record","Error")
self.btn_save.config(state="disabled")
self.btn_add.config(state="normal")
self.btn_edit.config(state="normal")
self.userlist=UMS.view()
if self.add_edit_flag=="add":
self.current_index=len(self.userlist)-1
self.add_edit_flag="view"
self.showrecord()
def view(): ulist=[] cnx=DBconnection.connect() cur=cnx.cursor() query="select * from user" cur.execute(query) d=cur.fetchall() for i in d: u=User() u.setUserid(int(i[0])) u.setUsername(i[1]) u.setPassword(i[2]) u.setUsertype(i[3]) u.setUserstatus(bool(i[4])) u.setName(i[5]) u.setEmail(i[6]) u.setContact(i[7]) u.setAddress(i[8]) u.setGender(bool(i[9])) ulist.append(u) cur.close() cnx.close() return ulist