def remove_from_DB(self):
# try/except
DBconnection = connection.SQLConnect()
DBconnection.delete_user(self.template_number)
DBconnection = connection.SQLConnect()
DBconnection.log_entry_fire_employee(self.dni)
def employee_to_DB(self):
if self.template_number != -1:
try:
if self.former_employee:
DBconnection = connection.SQLConnect()
self.employee.fingerprint = self.template_number
DBconnection.update_user(self.employee)
else:
DBconnection = connection.SQLConnect()
self.employee.fingerprint = self.template_number
DBconnection.new_user(self.employee)
except Exception as e:
self.create_error_frame('Database Error/n' + str(e))
finally:
time.sleep(2)
self.init_view = iv.InitialFrame(self.parent)
self.view.destroy()
self.init_view.pack()
else:
self.create_error_frame("Can't create Employee")
def delete_employee(self, delete_view):
self.delete_view = delete_view
self.dni = delete_view.dni_TF.get()
# try/except
DBconnection = connection.SQLConnect()
template = DBconnection.template_from_dni(self.dni)
if template == -1:
self.create_error_frame("The employee doesn't exist")
else:
self.template_number = template
FPDeletethread = threading.Thread(target=self.finger_print_delete_init)
FPDeletethread.start()
def inser_time_in_DB(self, dni):
DBConnection = connection.SQLConnect()
DBConnection.new_clocking_reg(dni)
def check_finger_in_DB(self, template_position):
DBConnection = connection.SQLConnect()
return DBConnection.dni_from_template(template_position)
def create_employee(self, user_form):
dni = user_form.dni_TF.get()
name = user_form.name_TF.get()
passwd = user_form.passwd_TF.get()
bossmail = user_form.bossmail_TF.get()
contract = user_form.contract_combo.get()
rol = user_form.rol_combo.get()
if dni == '' or name == '' or passwd == '' or bossmail == '':
self.create_error_frame('Empty field')
elif not self.validateDNI(dni):
self.create_error_frame('Invalid DNI')
elif not self.validateEmail(bossmail):
self.create_error_frame('Invalid Email')
else:
try:
DBconnection = connection.SQLConnect()
check_result = DBconnection.user_exist(dni)
if check_result == 1:
self.create_error_frame('User already exists')
elif check_result == 0:
self.former_employee = True
DBconnection = connection.SQLConnect()
self.employee = DBconnection.get_employee(dni)
rol_num = 0
if rol == "Admin":
rol_num = 1
self.employee.name = name
self.employee.password = passwd
self.employee.bossmail = bossmail
self.employee.contract = contract
self.employee.rol = rol_num
DBconnection = connection.SQLConnect()
DBconnection.update_user(self.employee)
elif check_result == -1:
rol_num = 0
if rol == "Admin":
rol_num = 1
self.employee = emp.Employee(name, dni, passwd, contract,
bossmail, rol_num)
self.parent = user_form.parent
self.view = fv.FPView(self.parent)
user_form.destroy()
self.view.pack()
FPthread = threading.Thread(target=self.finger_print_init)
FPthread.start()
except:
self.create_error_frame("Database Error")