def verify_rdv(self): global ident from Database import connexion id_patient_rdv = self.id_Patient_rdv.text() conx, cur = connexion() try: cur.execute("""SELECT * FROM rdv WHERE id_patient ="{}" """.format(id_patient_rdv)) print("SQL --> ok") except Exception as e: print("error: ",e) print("SQL --> fail") res= cur.fetchall() if len(res)!=0: ident= res[0][1] print("ident =",ident) self.open_liste_rdv() else: print("ident =",ident) msg = QMessageBox() msg.setWindowTitle("Echec") msg.setText("Vous n'avez pas de RDV") msg.setIcon(QMessageBox.Critical) msg.exec_() print("ident=",ident) conx.close()
def login_handler(self): from Database import connexion pseudo = self.username_log.text() pwd = self.password.text() conx, cur = connexion() try: cur.execute("""SELECT * FROM connexion""") except Exception as e: print(e) rows = cur.fetchall() for row in rows: if pseudo == row[1] and pwd == row[2]: print("connected") msg = QMessageBox() msg.setWindowTitle("Succes") msg.setText("Vous êtes connecté") msg.exec_() self.open_acc() else: print("not connected") msg = QMessageBox() msg.setWindowTitle("Alert") msg.setText("Pseudo ou Password incorrect veuiller recommencer") msg.setIcon(QMessageBox.Critical) msg.exec_()
def verify_handler(self): global identify from Database import connexion id_patient = self.id_Patient.text() conx, cur = connexion() try: cur.execute( """SELECT * FROM patient WHERE id_patient ="{}" """.format( id_patient)) print("SQL --> ok") except Exception as e: print("error: ", e) print("SQL --> fail") res = cur.fetchall() if len(res) != 0: identify = res[0][0] print("id =", identify) self.open_ficheMed() else: print("id =", identify) msg = QMessageBox() msg.setWindowTitle("Echec") msg.setText("Vous n'êtes pas inscrit") msg.setIcon(QMessageBox.Critical) msg.exec_()
def update_info(self): from accueil import iden nom = self.nomClient.text() prenom = self.prenomClient.text() sexe = self.sexe.currentText() # dateNaiss = self.date.date().toPyDate() profession = self.prof.text() tel = self.cont.text() email = self.mail.text() assurance = self.sexe_3.currentText() id_patient = iden # id_patient = "DA454" element = (nom, prenom, sexe, profession, tel, email, assurance, id_patient) conx, cur = connexion() try: cur.execute( """UPDATE patient SET nom= ?, prenom= ?, sexe= ?, profession= ?, tel= ?, email= ?, assurance= ? WHERE id_patient=?""", element) print("SQL MODIFICATION TABLE patient--> ok") conx.commit() msg = QMessageBox() msg.setWindowTitle("Succes") msg.setText("Modification Effectuée avec success") msg.exec_() except Exception as e: print("SQL MODIFICATION TABLE patient--> fail") print('Error : ', e) msg = QMessageBox() msg.setWindowTitle("Echec") msg.setText("Echec de connexion") msg.setIcon(QMessageBox.Critical) msg.exec_() conx.close()
def select_info(self): """Pour recuperer les info depuis la base de donnée""" from accueil import iden print("id_p dans modif =", iden) test = iden # test = "DA454" conx, cur = connexion() try: cur.execute( """SELECT nom,prenom,sexe,dateNaiss,cni,profession,tel,email,assurance FROM patient WHERE id_patient = "{}" """ .format(test)) print("SQL SELECTION TABLE patient --> ok") except Exception as e: print("ERREUR SELECTION TABLE patient : ", e) res = cur.fetchall() conx.close() if len(res) != 0: info = list() for data in res: info.append(data) return info else: msg = QMessageBox() msg.setWindowTitle("Alert") msg.setText("Le patient n'existe pas dans la base de donnée!!!") msg.setIcon(QMessageBox.Critical) msg.exec_()
def loadData(self): from Database import connexion conx, cur = connexion() try: cur.execute("""SELECT * FROM patient""") print("SQL -->ok") except Exception as e: print("error here:",e) res = cur.fetchall() print("len = ",len(res)) for row_number, row_data in enumerate(res): self.tableWidget.setRowCount((row_number+1)) for column_number, data in enumerate(row_data): self.tableWidget.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(str(data))) conx.close()
def delete_info(self): from Database import connexion num = self.line_Edit_Supprimer.text() conx, cur = connexion() try: cur.execute( """SELECT * FROM patient WHERE id_patient="{}" """.format(num)) except Exception as e: print("ERREUR SELECTION TABLE patient: ", e) res = cur.fetchall() if (len(res) != 0): msgBox = QMessageBox() msgBox.setIcon(QMessageBox.Information) msgBox.setWindowTitle("Alert") msgBox.setText( "Voulez vous vraiment supprimer le patient N° {}".format(num)) msgBox.setStandardButtons(QMessageBox.Yes | QMessageBox.No) returnValue = msgBox.exec_() if returnValue == QMessageBox.Yes: try: cur.execute( """DELETE FROM patient WHERE id_patient="{}" """. format(num)) cur.execute( """DELETE FROM rdv WHERE id_patient="{}" """.format( num)) conx.commit() print("SQL SUPPRESSION TABLE patient --> ok") msg = QMessageBox() msg.setWindowTitle("Info") msg.setText("Effacé avec success!!!") msg.exec_() conx.close() except Exception as e: print("ERREUR SUPPRESSION TABLE patient: ", e) conx.close() else: msg = QMessageBox() msg.setWindowTitle("Alert") msg.setText("Le patient n'existe pas dans la base de donnée!!!") msg.setIcon(QMessageBox.Critical) msg.exec_()
def loadData(self): from saisie_Id_rdv import ident from Database import connexion conx, cur = connexion() try: cur.execute( """SELECT * FROM rdv where id_patient="{}" """.format(ident)) print("SQL -->ok") except Exception as e: print("error here:", e) res = cur.fetchall() print("len = ", len(res)) for row_number, row_data in enumerate(res): self.liste_rdv_2.setRowCount((row_number + 1)) for column_number, data in enumerate(row_data): self.liste_rdv_2.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(str(data))) conx.close()
def insert_ordonnance(self): from Database import connexion from saisie_Id import identify from ficheMed import Ui_FicheMed, d, nm #d represente la date ne pas effacer nom_med = nm conx, cur = connexion() try: cur.execute( """SELECT id_med FROM medecin WHERE nom="{}" """.format( nom_med)) #On recupère l'id du medecin except Exception as e: print("error select id_med :", e) res = cur.fetchall() print("len = ", len(res)) id_med = res[0][0] medicaments = self.text_ordonnace.toPlainText() element = (medicaments, d[0], id_med, identify) try: cur.execute( """INSERT INTO ordonnance(medicaments,date,id_med,id_patient) VALUES(?,?,?,?)""", element) print("SQL INSERTION TABLE ordonance --> ok") conx.commit() msg = QMessageBox() msg.setWindowTitle("Succes") msg.setText("Enregistrement effectué avec succes") msg.exec_() except Exception as e: print('Error in ordonance : ', e) print('SQL --> fail') msg = QMessageBox() msg.setWindowTitle("Echec") msg.setText("Echec de connexion") msg.setIcon(QMessageBox.Critical) msg.exec_() conx.close()
def save_handler(self): from Database import connexion nom = self.nomClient.text() prenom = self.prenomClient.text() sexe = self.sexe.currentText() dateNaiss = self.date.date().toPyDate() cni = self.cni_Client.text() profession = self.prof.text() tel = self.cont.text() email = self.mail.text() assurance = self.sexe_3.currentText() id_patient = "STP20-{}20".format(cni) element = (id_patient,nom,prenom,sexe,dateNaiss,cni,profession,tel,email,assurance) conx, cur = connexion() if(cni ==""): msg = QMessageBox() msg.setWindowTitle("Echec") msg.setText("Veuiller Remplir le champ cni svp") msg.setIcon(QMessageBox.Critical) msg.exec_() else: try: cur.execute("""INSERT INTO patient(id_patient,nom,prenom,sexe,dateNaiss,cni,profession,tel,email,assurance) VALUES(?,?,?,?,?,?,?,?,?,?)""",element) print("SQL INSERTION TABLE patient --> ok") conx.commit() msg = QMessageBox() msg.setWindowTitle("Succes") msg.setText("Enregistrement effectué avec succes") msg.exec_() except Exception as e: print('Error : ',e) print('SQL --> fail') msg = QMessageBox() msg.setWindowTitle("Echec") msg.setText("Echec de connexion") msg.setIcon(QMessageBox.Critical) msg.exec_() conx.close()