def editData(self): alterAddress = database.databaseUser() alterEmail = database.databaseLogin() userType = self.data.type() if (userType == "STUDENT"): userType = 0 email = self.email_edit.text() number = self.house_number_edit.text() street = self.street_edit.text() sdistrict = self.sub_district_edit.text() district = self.district_edit.text() province = self.province_edit.text() zip = self.zip_code_edit.text() changeEmail = alterEmail.editLogin(self.data.getUsername(), email, userType) changeAddress = alterAddress.updateAddress(self.data.getID(), number, street, sdistrict, district, province, zip) if (changeEmail and changeAddress): self.parent.showOK("Information Changed", "Data has been edited successfully.") self.parent.changePageLoginSection("login") alterAddress.disconnect() alterEmail.disconnect() self.close()
def UIinit(self): loader = QUiLoader() form = loader.load("resources/UI/login.ui", None) self.setCentralWidget(form) self.logolabel = form.findChild(QLabel, "label_2") self.logolabel.setPixmap(self.logo) self.wronglabel = form.findChild(QLabel, "wrong") self.wronglabel.setStyleSheet('color: red') self.user_id = form.findChild(QLineEdit, "usernameinp") self.password = form.findChild(QLineEdit, "pwinp") self.login_button = form.findChild(QPushButton, "loginButton") self.forgetpw_button = form.findChild(QCommandLinkButton, "forgetButton") self.status = form.findChild(QLabel, "status_2") self.password.returnPressed.connect(self.logIn) self.login_button.clicked.connect(self.logIn) self.forgetpw_button.clicked.connect(self.forgetpass) try: self.login = database.databaseLogin() self.data = database.databaseUser() self.status.setText("Online") except database.invalidQueryException as e: self.wronglabel.setText(str(e)) self.status.setText("Offline")
def createImageFile(self): db = database.databaseUser() blob = db.getProfilePicture(self.user_id) if(blob[0].picture != None): file = open(self.path, "wb") file.write(base64.decodestring(blob[0].picture)) file.close() else: self.path = self.default_path
def add(self): self.dbLogin = database.databaseLogin() self.dbLogin.createLogin(self.user_id.text(), self.username.text(), self.email.text(), userType=self.status_set) self.dbLogin.disconnect() self.dbUser = database.databaseUser() if (self.status_set == 0): status = self.dbUser.createStudent(self.user_id.text(), self.first_name.text(), self.surname.text(), self.email.text(), self.faculty_id.text(), self.major_id.text()) elif (self.status_set == 1): status = self.dbUser.createProfessor(self.user_id.text(), self.first_name.text(), self.surname.text(), self.email.text(), self.faculty_id.text()) elif (self.status_set == 2): status = self.dbUser.createAdmin(self.user_id.text(), self.first_name.text(), self.surname.text(), self.email.text()) if (status[0] == 1): self.parent.showOK("User Saved", "The User has been added successfully") self.dbUser.disconnect() self.close() if (status[0] == "EXISTS"): self.parent.showERROR("Data Duplication Error" + status[0], "UserID already exists.") elif (status[0] == "22P02"): self.parent.showERROR( "Data Integrity Error" + status[0], "Invalid DataType or Incomplete Form.\nPlease check your fields." ) elif (status[0] == "23505"): self.parent.showERROR("Data Duplication Error" + status[0], "UserID already exists.") elif (status[0] == "23503"): self.parent.showERROR( "Data Consistency Error" + status[0], "Either FacultyID, or Major ID is incorrect OR Username Exists." )
def writeData(self, blob): db = database.databaseUser() imageWrite = db.editProfilePicture(blob, self.user_id) db.disconnect() return imageWrite