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!")
