def findOtoritas(username): try: session = sessionFactory() for user in session.query(UserOrm).filter_by(username=username): return user.authority session.close() except Exception as e: print("===>", e)
def showAdmin(): try: session = sessionFactory() for admin in session.query(AdministratorOrm).all(): print("Nama = {}\n====================".format( admin.nama_admin)) session.close() except Exception as e: print("===>", e)
def roomStatus(room_number) -> bool: try: session = sessionFactory() if((session.query(RoomOrm).filter_by(room_number=room_number).count()) == 1): return True else: return False session.close() except Exception as e: print("--->", e)
def deleteHotel(nama_hotel): try: session = sessionFactory() session.query(HotelOrm).filter_by(id=nama_hotel).delete() session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil Dihapus!")
def deleteVisitor(id_visitor): try: session = sessionFactory() session.query(VisitorOrm).filter_by(id=id_visitor).delete() session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil Dihapus!")
def deleteEmployee(id_emp): try: session = sessionFactory() session.query(EmployeeOrm).filter_by(id=id_emp).delete() session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil Dihapus!")
def delAdmin(nama_admin): try: session = sessionFactory() session.query(AdministratorOrm).filter_by(id=nama_admin).delete() session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil Dihapus!")
def deleteUser(username): try: session = sessionFactory() session.query(UserOrm).filter_by(username=username).delete() session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil Dihapus!")
def showRoom(): try: session = sessionFactory() for room in session.query(RoomOrm).all(): print( "Room Number = {}\nRoom Code = {}\n--------------------" .format(room.room_number, room.room_code)) session.close() except Exception as e: print("--->", e)
def showUser(): try: session = sessionFactory() for user in session.query(UserOrm).all(): print( "Id User = {}, Username = {}, Password = {}, Hak Akses = {}" .format(user.id, user.username, user.password, user.authority)) session.close() except Exception as e: print("===>", e)
def insertRoom(self): try: session = sessionFactory() roomORM = RoomOrm(self.id, self.room_number, self.room_code, self.status) session.add(roomORM) session.commit() session.close() except Exception as e: print("--->", e) else: print("Data Berhasil Di Simpan")
def showHotel(): try: session = sessionFactory() for hotel in session.query(HotelOrm).all(): print( "Nama Hotel = {}\nAlamat Hotel = {}\nFasilitas : {}====================" .format(hotel.nama_hotel, hotel.alamat_hotel, hotel.fasilitas)) session.close() except Exception as e: print("===>", e)
def insertUser(user): try: session = sessionFactory() userOrm = UserOrm(user.username, user.password, user.authority) session.add(userOrm) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil Disimpan!")
def verifyUser(username, password) -> bool: try: session = sessionFactory() if ((session.query(UserOrm).filter_by( username=username, password=password).count()) == 1): return True else: return False session.close() except Exception as e: print("===>", e)
def updateUserPass(idUser): try: newPassword = input("Masukkan Password Baru: ") session = sessionFactory() session.query(UserOrm).filter_by(id=idUser).update( {UserOrm.password: newPassword}, synchronize_session=False) session.commit() except Exception as e: print("===>", e) else: print("Data Berhasil DiUpdate!")
def showVisitor(): try: session = sessionFactory() for visitor in session.query(VisitorOrm).all(): print( "Id Visitor = {}\nNama = {}\nAlamat = {}\nJabatan= {}\nJenis Kelamin = {}\nAlamat = {}\n====================" .format(visitor.id_visitor, visitor.nama, visitor.alamat, visitor.no_KTP, visitor.tanggal_lahir)) session.close() except Exception as e: print("===>", e)
def insertHotel(self): try: session = sessionFactory() HotelOrm = HotelOrm(self.__nama_hotel, self.__alamat_hotel, self.__fasilitas) session.add(HotelOrm) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil Disimpan!")
def showEmployee(): try: session = sessionFactory() for employee in session.query(EmployeeOrm).all(): print( "Id Karyawan = {}\nNama = {}\nTanggal Lahir = {}\nJabatan= {}\nJenis Kelamin = {}\nAlamat = {}\n====================" .format(employee.id_emp, employee.nama_emp, employee.TL_emp, employee.jabatan_emp, employee.JK_emp, employee.alamat_emp)) session.close() except Exception as e: print("===>", e)
def insertAdmin(self): try: session = sessionFactory() adminOrm = AdministratorOrm(self.id_admin, self.nama_admin, self.kode_admin) session.add(adminOrm) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil Disimpan!")
def insertVisitor(self): try: session = sessionFactory() visitorOrm = VisitorOrm(self.id_visitor, self.nama, self.jk, self.alamat, self.no_KTP, self.tanggal_lahir) session.add(visitorOrm) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil Disimpan!")
def insertEmployee(self): try: session = sessionFactory() employeeOrm = EmployeeOrm(self.id_emp, self.nama_emp, self.TL_emp, self.jabatan_emp, self.JK_emp, self.alamat_emp) session.add(employeeOrm) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil Disimpan!")
def updateAdmin(nama_admin): try: newNama = input("Masukkan Nama Baru: ") newKode = input("Masukkan Kode Baru: ") session = sessionFactory() session.query(AdministratorOrm).filter_by(id=nama_admin).update( { AdministratorOrm.nama_admin: newNama, AdministratorOrm.kode_admin: newKode }, synchronize_session=False) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil DiUpdate!")
def updateHotel(nama_hotel): try: newNama = input("Masukkan Nama Baru: ") newAlamat = input("Masukkkan Alamat Baru") session = sessionFactory() session.query(HotelOrm).filter_by(id=nama_hotel).update( { HotelOrm.nama_hotel: newNama, HotelOrm.alamat_hotel: newAlamat }, synchronize_session=False) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil DiUpdate!")
def updateVisitor(id_visitor): try: newNama = input("Masukkan Nama Baru: ") newAlamat = input("Masukkan Alamat Baru: ") newNo_KTP = input("Masukkan Nomor KTP Baru: ") newTanggalLahir = input("Masukkan Tanggal Lahir Baru: ") session = sessionFactory() session.query(VisitorOrm).filter_by(id=id_visitor).update( { VisitorOrm.nama: newNama, VisitorOrm.alamat: newAlamat, VisitorOrm.no_KTP: newNo_KTP, VisitorOrm.tanggal_lahir: newTanggalLahir }, synchronize_session=False) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil DiUpdate!")
def updateEmployee(id_emp): try: newNama = input("Masukkan Nama Baru: ") newTL = input("Masukkan Tanggal Lahir Baru: ") newJabatan = input("Masukkan Jabatan Baru: ") newJK = input("Masukkan Jenis Kelamin Baru: ") newAlamat = input("Masukkkan Alamat Baru") session = sessionFactory() session.query(EmployeeOrm).filter_by(id=id_emp).update( { EmployeeOrm.nama_emp: newNama, EmployeeOrm.TL_emp: newTL, EmployeeOrm.JK_emp: newJK, EmployeeOrm.alamat_emp: newAlamat }, synchronize_session=False) session.commit() session.close() except Exception as e: print("===>", e) else: print("Data Berhasil DiUpdate!")