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')