private void PopulateTableWithReservedRooms() {
try {
RoomsHelper.AddReservedRoomsToTable(getRoomsTableName(), m_UserId, m_Model);
} catch (Exception e) {
Logger.getLogger(RoomsFilterPage.class.getName()).log(Level.SEVERE, null, e);
}
}
private boolean AnyRoomsWithCapacityPresent() {
try {
int capacity = getCapacity();
if (capacity <= 0) return false;
return RoomsHelper.AnyRoomsWithCapacityPresent(
getRoomsTableName(), capacity, getCapacityColName());
} catch (Exception e) {
Logger.getLogger(RoomsFilterPage.class.getName()).log(Level.SEVERE, null, e);
}
return false;
}
private void PopulateRoomsTable() {
try {
String dateString = getFromDate();
RoomsHelper.AddRoomsToTable(
getRoomsTableName(),
"ROOMNO",
"FLOOR",
getCapacity(),
"CAPACITY",
"LIBRARYID",
dateString,
m_Model);
} catch (Exception e) {
Logger.getLogger(RoomsFilterPage.class.getName()).log(Level.SEVERE, null, e);
}
}
private void checkinButtonActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_checkinButtonActionPerformed
try {
int selectedRow = roomsTable.getSelectedRow();
if (selectedRow == -1) {
invisibleLabel.setText("Please select a room!");
return;
}
String roomNo = (String) roomsTable.getModel().getValueAt(selectedRow, 0);
if (RoomsHelper.CheckinRoom(getRoomsTableName(), m_UserId, roomNo)) {
invisibleLabel.setText("Room has been Checkedin!");
return;
}
invisibleLabel.setText("Room cannot be Checkedin!");
} catch (Exception e) {
Logger.getLogger(RoomsFilterPage.class.getName()).log(Level.SEVERE, null, e);
}
} // GEN-LAST:event_checkinButtonActionPerformed
private void reserveButtonActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_reserveButtonActionPerformed
try {
int selectedRow = roomsTable.getSelectedRow();
if (selectedRow == -1) {
invisibleLabel.setText("Please select a room!");
return;
}
String roomNo = (String) roomsTable.getModel().getValueAt(selectedRow, 0);
String floor = (String) roomsTable.getModel().getValueAt(selectedRow, 1);
String libId = (String) roomsTable.getModel().getValueAt(selectedRow, 3);
String libName = (String) roomsTable.getModel().getValueAt(selectedRow, 4);
String fromDate = getFromDate();
String toDate = getToDate();
RoomsHelper.ReserveRoom(getRoomsTableName(), m_UserId, roomNo, libId, fromDate, toDate);
this.dispose();
new ReservationDetailsPage(m_RoomsPage, roomNo, libName, floor, fromDate, toDate)
.setVisible(true);
} catch (Exception e) {
Logger.getLogger(RoomsFilterPage.class.getName()).log(Level.SEVERE, null, e);
}
} // GEN-LAST:event_reserveButtonActionPerformed
