def get_xlsheet(self, id, role, type): ac = AuthController() data = ac.get_all_students() if data: cas = Create_attendance_sheet() file_name = cas.load(id, role, type, data) if file_name: messagebox.showinfo('xlsx', f"{file_name}\nGenerated Successfully") else: messagebox.showinfo('Empty', "No records found")
def closeCamera(self): self.vid_cam.release() cv2.destroyAllWindows() self.window.destroy() if self.present_ids: ac = AuthController() result = ac.mark_attendance(self.present_ids) if result: messagebox.showinfo("attendance", "marked successfully") else: messagebox.showinfo("alert", " error")
def search_for_id(self, id): ac = AuthController() result = ac.searching_id(id) if result: self.txt_name.delete(0, END) self.txt_gmail.delete(0, END) self.txt_phno.delete(0, END) self.txt_name.insert(0, result[1]) self.txt_gmail.insert(0, result[2]) self.txt_phno.insert(0, result[3]) else: messagebox.showinfo("Alert", "User id not exists")
def login_control(self,av, id, password): ac = AuthController() message = ac.login(id, password) if message: self.set_pro_pic(id) data_row=message if data_row[5]=='student': st=Student() st.load(av,data_row[0],data_row[1],data_row[5]) if data_row[5]=='admin': ad=Admin() ad.load(av,data_row[0],data_row[1],data_row[5])
def update_student_data(self, id, name, gmail, phone): if True in map(lambda item: len(str(item)) == 0, [id, name, gmail, phone]): messagebox.showinfo("Empty Fields", 'Fields cannot be empty') else: ac = AuthController() result = ac.update_student(id, name, gmail, phone) if result: messagebox.showinfo('Updated', 'Users data updated') # self.root_update.destroy() else: messagebox.showinfo('some error in inserting') self.root_update.destroy()
def load_label(self,av,userid): if len(str(userid))==0: messagebox.showinfo('Empty Fields','Fields cannot be empty') else: ac=AuthController() #return is list [role in authentic_users,if id exist in users] data=ac.check_role(userid) if data[0]!=None: if data[1]==None: self.txt_role['text']=data[0][0] else: messagebox.showinfo('DB Error','user already exist') else: messagebox.showinfo('Authentication Error','not authorised users')
def delete_student(self, id): if len(str(id)) != 0: ac = AuthController() result = ac.searching_id(id) if result: result = ac.User_to_delete(id) if result != None: sub_dir = os.path.join('faceDataset/', id) if os.path.exists(sub_dir): shutil.rmtree(sub_dir) messagebox.showinfo( 'deleted', f'deleted all data of user with id {id} ') else: messagebox.showinfo("Alert", "userid doesnot exists") else: messagebox.showinfo('Alert', "userid cannot be empty")
def register_control(self,av,id,name,email,phone, password, conform_password,role): if True in map(lambda item: len(str(item)) == 0, [id,name,email,phone, password, conform_password,role]): messagebox.showinfo('Empty Feilds', 'fields cannot be empty') else: if role=='None': messagebox.showinfo('Empty Feilds', 'role cannot be None') else: ac = AuthController() id=int(id) phone=int(phone) message = ac.register(id,name, email, phone, password, conform_password, role) if message==True: messagebox.showinfo('Alert Registeration', 'Registered sucessfully') self.root_register.destroy() av.load()
def to_add(self, id, role): self.eadd_role.delete(0, END) self.eadd_id.delete(0, END) if len(id) != 0 and len(role) != 0: if role == 'student' or role == 'admin': ac = AuthController() result = ac.adding_members(id, role) if result: messagebox.showinfo( "Success", "id and role are inserted in the database") else: messagebox.showinfo( "Alert", "userid already exists or error in inserting record to the database" ) else: messagebox.showinfo('Alert', 'role must be "admin" or "student" only') else: messagebox.showinfo("Alert", 'Fields cannot be empty')