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