/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package I3.UI;
import I3.Classes.Booking;
import I3.Classes.UserInfo;
import I3.DatabaseOperation.BookingDb;
import I3.DatabaseOperation.CustomerDb;
import I3.DatabaseOperation.DatabaseOperation;
import I3.TableModel.CustomCellRenderer;
import java.awt.Color;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.beans.PropertyChangeEvent;
import java.beans.PropertyChangeListener;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Vector;
import javax.swing.DefaultComboBoxModel;
import javax.swing.DefaultListModel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.UIManager;
import javax.swing.text.JTextComponent;
import net.proteanit.sql.DbUtils;
import org.jdesktop.swingx.autocomplete.AutoCompleteDecorator;
/**
*
* @author Faysal Ahmed
*/
public class ControlPanel extends javax.swing.JFrame {
/**
* Creates new form ControlPanel
*/
Vector<String> customerList = new Vector();
DatabaseOperation db = new DatabaseOperation();
CustomerDb customerdb = new CustomerDb();
Booking booking;
BookingDb bookingdb = new BookingDb();
boolean existingCustomer = false;
UserInfo user;
ResultSet result;
public ControlPanel() {
initComponents();
// UIManager.setLookAndFeel(UIManager);
this.getContentPane().setBackground(new Color(241,241,242));
searchCustomerHelper();
AutoCompleteDecorator.decorate(combo_users);
date_checkIn.setDate(new Date());
//populateWithBookingData();
}
public void populateWithBookingData() {
result = bookingdb.getBookingInformation();
//bookingdb.flushAll();
//table_booking.setModel(DbUtils.resultSetToTableModel(result));
CustomCellRenderer customRenderer = new CustomCellRenderer();
//table_booking.setDefaultRenderer(Object.class, customRenderer);
bookingdb.flushAll();
}
/**
* This method is called from within the constructor to initialize the form.
* WARNING: Do NOT modify this code. The content of this method is always
* regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
private void initComponents() {
jSeparator7 = new javax.swing.JSeparator();
jScrollPane2 = new javax.swing.JScrollPane();
panel_container = new javax.swing.JPanel();
jPanel3 = new javax.swing.JPanel();
btn_room_up = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
roomsList = new javax.swing.JList();
jSeparator5 = new javax.swing.JSeparator();
jLabel11 = new javax.swing.JLabel();
jLabel12 = new javax.swing.JLabel();
jPanel2 = new javax.swing.JPanel();
date_checkOut = new com.toedter.calendar.JDateChooser();
jLabel4 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel9 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
date_checkIn = new com.toedter.calendar.JDateChooser();
jLabel5 = new javax.swing.JLabel();
tf_name = new javax.swing.JTextField();
tf_contact = new javax.swing.JTextField();
tf_address = new javax.swing.JTextField();
jLabel7 = new javax.swing.JLabel();
jLabel8 = new javax.swing.JLabel();
combo_reservationType = new javax.swing.JComboBox();
jLabel3 = new javax.swing.JLabel();
btn_saveBooking = new javax.swing.JButton();
tf_rooms = new javax.swing.JTextField();
tf_guestNo = new javax.swing.JTextField();
jLabel10 = new javax.swing.JLabel();
tf_customerId = new javax.swing.JTextField();
jLabel13 = new javax.swing.JLabel();
jPanel1 = new javax.swing.JPanel();
combo_users = new javax.swing.JComboBox();
jLabel1 = new javax.swing.JLabel();
jToolBar1 = new javax.swing.JToolBar();
jButton1 = new javax.swing.JButton();
jSeparator3 = new javax.swing.JToolBar.Separator();
jButton2 = new javax.swing.JButton();
jSeparator4 = new javax.swing.JToolBar.Separator();
jButton4 = new javax.swing.JButton();
jSeparator1 = new javax.swing.JToolBar.Separator();
jButton5 = new javax.swing.JButton();
jSeparator2 = new javax.swing.JToolBar.Separator();
jButton7 = new javax.swing.JButton();
jSeparator8 = new javax.swing.JToolBar.Separator();
jButton6 = new javax.swing.JButton();
jSeparator6 = new javax.swing.JToolBar.Separator();
jButton3 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
panel_container.setBackground(new java.awt.Color(241, 241, 242));
jPanel3.setBackground(new java.awt.Color(230, 231, 232));
btn_room_up.setIcon(new javax.swing.ImageIcon(getClass().getResource("/resources/AddRoomButton.png"))); // NOI18N
btn_room_up.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btn_room_upActionPerformed(evt);
}
});
roomsList.setFont(new java.awt.Font("Serif", 0, 24)); // NOI18N
roomsList.setModel(new javax.swing.AbstractListModel() {
String[] strings = { "Item 1", "Item 2", "Item 3", "Item 4", "Item 5" };
public int getSize() { return strings.length; }
public Object getElementAt(int i) { return strings[i]; }
});
roomsList.setLayoutOrientation(javax.swing.JList.HORIZONTAL_WRAP);
roomsList.setVisibleRowCount(1);
jScrollPane1.setViewportView(roomsList);
jLabel11.setText("Available Rooms :");
jLabel12.setFont(new java.awt.Font("Tahoma", 0, 13)); // NOI18N
jLabel12.setText("( please use ctrl to select multiple rooms )");
javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);
jPanel3Layout.setHorizontalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jSeparator5)
.addGroup(jPanel3Layout.createSequentialGroup()
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel11, javax.swing.GroupLayout.PREFERRED_SIZE, 236, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel12))
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 445, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel3Layout.createSequentialGroup()
.addGap(72, 72, 72)
.addComponent(btn_room_up, javax.swing.GroupLayout.PREFERRED_SIZE, 311, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel11)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel12)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 28, Short.MAX_VALUE)
.addComponent(jSeparator5, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(3, 3, 3)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 47, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(47, 47, 47)
.addComponent(btn_room_up, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(38, 38, 38))
);
jPanel2.setBackground(new java.awt.Color(230, 231, 232));
jLabel4.setText("Contact No");
jLabel2.setText("Name");
jLabel9.setText("Type");
jLabel6.setText("Guests");
date_checkIn.setIcon(null);
date_checkIn.addPropertyChangeListener(new java.beans.PropertyChangeListener() {
public void propertyChange(java.beans.PropertyChangeEvent evt) {
date_checkInPropertyChange(evt);
}
});
jLabel5.setText("Rooms");
tf_contact.setToolTipText("digits only");
tf_contact.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyTyped(java.awt.event.KeyEvent evt) {
tf_contactKeyTyped(evt);
}
});
jLabel7.setText("Check in");
jLabel8.setText("Check Out");
combo_reservationType.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "On Spot", "Paid reservation", "reservation" }));
jLabel3.setText("Address");
btn_saveBooking.setBackground(new java.awt.Color(0, 167, 157));
btn_saveBooking.setForeground(new java.awt.Color(255, 255, 255));
btn_saveBooking.setText("Save");
btn_saveBooking.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 167, 157)));
btn_saveBooking.setBorderPainted(false);
btn_saveBooking.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btn_saveBookingActionPerformed(evt);
}
});
tf_rooms.setEditable(false);
tf_guestNo.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyTyped(java.awt.event.KeyEvent evt) {
tf_guestNoKeyTyped(evt);
}
});
jLabel10.setText("ID");
tf_customerId.setEditable(false);
tf_customerId.setBackground(new java.awt.Color(209, 210, 212));
jLabel13.setText("New Booking :");
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(96, 96, 96)
.addComponent(btn_saveBooking, javax.swing.GroupLayout.PREFERRED_SIZE, 80, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(0, 0, Short.MAX_VALUE))
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jLabel13, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel8, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel7, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel6, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel5, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel4, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 80, Short.MAX_VALUE)
.addComponent(jLabel3, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel9, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel10, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 80, Short.MAX_VALUE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(date_checkIn, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(date_checkOut, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(combo_reservationType, 0, 120, Short.MAX_VALUE)
.addComponent(tf_name)
.addComponent(tf_address)
.addComponent(tf_contact)
.addComponent(tf_rooms)
.addComponent(tf_guestNo))
.addComponent(tf_customerId, javax.swing.GroupLayout.PREFERRED_SIZE, 120, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(0, 41, Short.MAX_VALUE)))))
.addContainerGap())
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel13)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 7, Short.MAX_VALUE)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel10)
.addComponent(tf_customerId, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tf_name, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(tf_address, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel4, javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(tf_contact, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel5, javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(tf_rooms, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel6, javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(tf_guestNo, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel7, javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(date_checkIn, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel8, javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(date_checkOut, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel9)
.addComponent(combo_reservationType, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addComponent(btn_saveBooking, javax.swing.GroupLayout.PREFERRED_SIZE, 27, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
jPanel1.setBackground(new java.awt.Color(0, 167, 157));
combo_users.setEditable(true);
jLabel1.setForeground(new java.awt.Color(255, 255, 255));
jLabel1.setText("Search User: (type and hit Enter)");
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(combo_users, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, 220, Short.MAX_VALUE))
.addContainerGap(235, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 19, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(combo_users, javax.swing.GroupLayout.DEFAULT_SIZE, 29, Short.MAX_VALUE)
.addContainerGap())
);
jToolBar1.setRollover(true);
jToolBar1.setBorderPainted(false);
jButton1.setFont(new java.awt.Font("Tahoma", 0, 14)); // NOI18N
jButton1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/resources/CustomerInfo.png"))); // NOI18N
jButton1.setText("Customer Info");
jButton1.setToolTipText("Customer Info");
jButton1.setFocusable(false);
jButton1.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton1.setMargin(new java.awt.Insets(2, 15, 15, 14));
jButton1.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jToolBar1.add(jButton1);
jToolBar1.add(jSeparator3);
jButton2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/resources/rooms.png"))); // NOI18N
jButton2.setText("Rooms");
jButton2.setToolTipText("Room Info");
jButton2.setFocusable(false);
jButton2.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton2.setMargin(new java.awt.Insets(2, 15, 15, 14));
jButton2.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
jToolBar1.add(jButton2);
jToolBar1.add(jSeparator4);
jButton4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/resources/BookingDiary.png"))); // NOI18N
jButton4.setText("Booking Diary");
jButton4.setToolTipText("Book a Room");
jButton4.setFocusable(false);
jButton4.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton4.setMargin(new java.awt.Insets(2, 15, 15, 14));
jButton4.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
jToolBar1.add(jButton4);
jToolBar1.add(jSeparator1);
jButton5.setIcon(new javax.swing.ImageIcon(getClass().getResource("/resources/foods.png"))); // NOI18N
jButton5.setText("Food");
jButton5.setFocusable(false);
jButton5.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton5.setMargin(new java.awt.Insets(2, 15, 15, 14));
jButton5.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
jToolBar1.add(jButton5);
jToolBar1.add(jSeparator2);
jButton7.setIcon(new javax.swing.ImageIcon(getClass().getResource("/resources/OtherItems.png"))); // NOI18N
jButton7.setText("Other Items");
jButton7.setFocusable(false);
jButton7.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton7.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton7ActionPerformed(evt);
}
});
jToolBar1.add(jButton7);
jToolBar1.add(jSeparator8);
jButton6.setIcon(new javax.swing.ImageIcon(getClass().getResource("/resources/Checkout&Payment.png"))); // NOI18N
jButton6.setText("Check Out and payment");
jButton6.setFocusable(false);
jButton6.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton6.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton6ActionPerformed(evt);
}
});
jToolBar1.add(jButton6);
jToolBar1.add(jSeparator6);
jButton3.setIcon(new javax.swing.ImageIcon(getClass().getResource("/resources/LogBook_1.png"))); // NOI18N
jButton3.setText("Log Book");
jButton3.setToolTipText("Log Book");
jButton3.setFocusable(false);
jButton3.setHorizontalTextPosition(javax.swing.SwingConstants.CENTER);
jButton3.setMargin(new java.awt.Insets(2, 15, 15, 14));
jButton3.setVerticalTextPosition(javax.swing.SwingConstants.BOTTOM);
jToolBar1.add(jButton3);
javax.swing.GroupLayout panel_containerLayout = new javax.swing.GroupLayout(panel_container);
panel_container.setLayout(panel_containerLayout);
panel_containerLayout.setHorizontalGroup(
panel_containerLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(panel_containerLayout.createSequentialGroup()
.addGroup(panel_containerLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(panel_containerLayout.createSequentialGroup()
.addGap(152, 152, 152)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(96, 96, 96)
.addGroup(panel_containerLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel3, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jPanel1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(panel_containerLayout.createSequentialGroup()
.addGap(192, 192, 192)
.addComponent(jToolBar1, javax.swing.GroupLayout.PREFERRED_SIZE, 963, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(0, 189, Short.MAX_VALUE))
);
panel_containerLayout.setVerticalGroup(
panel_containerLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(panel_containerLayout.createSequentialGroup()
.addComponent(jToolBar1, javax.swing.GroupLayout.PREFERRED_SIZE, 152, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(49, 49, 49)
.addGroup(panel_containerLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(panel_containerLayout.createSequentialGroup()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(35, 35, 35)
.addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap(260, Short.MAX_VALUE))
);
jScrollPane2.setViewportView(panel_container);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 1197, Short.MAX_VALUE)
.addGap(18, 18, 18))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 743, Short.MAX_VALUE)
.addContainerGap())
);
pack();
}// </editor-fold>//GEN-END:initComponents
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
CustomerPanel c = new CustomerPanel();
c.setVisible(true);
}//GEN-LAST:event_jButton1ActionPerformed
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
RoomPanel r = new RoomPanel(this, rootPaneCheckingEnabled);
r.setVisible(true);
}//GEN-LAST:event_jButton2ActionPerformed
private void btn_saveBookingActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btn_saveBookingActionPerformed
if (!isAnyRequiredFieldEmpty()) {
//System.out.println("coming");
bookingObjectCreation();
bookingdb.insertBooking(booking);
clearAllFields();
}
else
{
JOptionPane.showMessageDialog(null, "Missing any text field");
}
}//GEN-LAST:event_btn_saveBookingActionPerformed
// returning true should block the user to execute next processes
private boolean isAnyRequiredFieldEmpty() {
return tf_address.getText().equals("") || tf_contact.getText().equals("") || tf_guestNo.getText().equals("") || tf_name.getText().equals("") || tf_rooms.getText().equals("");
}
private void bookingObjectCreation() {
booking = new Booking();
roomsToRoomObjectList(tf_rooms.getText());
booking.setBookingType((String) combo_reservationType.getSelectedItem());
booking.setPerson(Integer.parseInt(tf_guestNo.getText()));
booking.setCheckInDateTime(date_checkIn.getDate().getTime() / 1000);
booking.setBookingType((String) combo_reservationType.getSelectedItem());
if (date_checkOut.getDate() != null) {
booking.setCheckOutDateTime(date_checkOut.getDate().getTime() / 1000);
}
if (existingCustomer) {
booking.getCustomer().setCustomer_id(Integer.parseInt(tf_customerId.getText()));
} else {
createNewCustomer();
customerdb.insertCustomer(user);
booking.getCustomer().setCustomer_id(db.getCustomerId(user));
db.flushAll();
}
}
private void createNewCustomer() {
user = new UserInfo();
user.setName(tf_name.getText());
user.setAddress(tf_address.getText());
user.setPhone_no(tf_contact.getText());
}
private void roomsToRoomObjectList(String value) {
if (!value.contains(",")) {
booking.addRoom(value.trim());
} else {
String[] roomArray = value.split(",");
for (String s : roomArray) {
booking.addRoom(s);
}
}
}
private void btn_room_upActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btn_room_upActionPerformed
List<String> list = new ArrayList();
list = roomsList.getSelectedValuesList();
if (!list.isEmpty()) {
String roomString = list.get(0);
for (int i = 1; i < list.size(); i++) {
roomString += "," + list.get(i);
}
tf_rooms.setText(roomString);
}
}//GEN-LAST:event_btn_room_upActionPerformed
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton4ActionPerformed
// true params block the parents to work
OrderPanel c = new OrderPanel(this, true);
c.setVisible(true);
}//GEN-LAST:event_jButton4ActionPerformed
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed
FoodPanel f = new FoodPanel(this, true);
f.setVisible(true);
}//GEN-LAST:event_jButton5ActionPerformed
private void tf_contactKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tf_contactKeyTyped
char c = evt.getKeyChar();
if (!(Character.isDigit(c) || c == KeyEvent.VK_BACK_SPACE || c == KeyEvent.VK_DELETE)) {
evt.consume();
}
}//GEN-LAST:event_tf_contactKeyTyped
private void tf_guestNoKeyTyped(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_tf_guestNoKeyTyped
char c = evt.getKeyChar();
if (!(Character.isDigit(c) || c == KeyEvent.VK_BACK_SPACE || c == KeyEvent.VK_DELETE)) {
evt.consume();
}
}//GEN-LAST:event_tf_guestNoKeyTyped
private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton6ActionPerformed
PaymentPanel p = new PaymentPanel(this, true);
p.setVisible(true);
}//GEN-LAST:event_jButton6ActionPerformed
private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton7ActionPerformed
ItemPanel i = new ItemPanel(this, true);
i.setVisible(true);
}//GEN-LAST:event_jButton7ActionPerformed
private void date_checkInPropertyChange(java.beans.PropertyChangeEvent evt) {//GEN-FIRST:event_date_checkInPropertyChange
if (date_checkIn.getDate() != null) {
try {
//System.err.println("aise");
long date = date_checkIn.getDate().getTime() / 1000;
//System.out.println(">> "+date);
ResultSet x = db.getAvailableRooms(date);
DefaultListModel model = new DefaultListModel();
while (x.next()) {
model.addElement(x.getString("room_no"));
}
roomsList.setModel(model);
} catch (SQLException ex) {
System.err.println("errrrrrrrrrrrr");
}
}
}//GEN-LAST:event_date_checkInPropertyChange
private void searchCustomerHelper() {
final DefaultComboBoxModel model = new DefaultComboBoxModel(customerList);
combo_users.setModel(model);
JTextComponent editor = (JTextComponent) combo_users.getEditor().getEditorComponent();
editor.addKeyListener(new KeyAdapter() {
@Override
public void keyTyped(KeyEvent evt) {
//System.out.println((int)KeyEvent.VK_ACCEPT);
// .............. 1st part for searching a customer, user should hit enter if he finds a user.
if (evt.getKeyChar() == KeyEvent.VK_ENTER) {
String details = (String) combo_users.getSelectedItem();
//System.out.println(details);
if (!details.contains(",")) {
JOptionPane.showMessageDialog(null, "no users found, try adding a new user");
} else {
int customerId = Integer.parseInt(details.substring(details.lastIndexOf(",") + 1));
// A if condition should be here, but not required as the last line has no chance of returning -1.
System.out.println(".>> " + customerId);
ResultSet userDB = db.searchAnUser(customerId);
displayTextField(userDB);
existingCustomer = true;
}
}
//................. end of first part, start of 2nd part, for suggesting saved customer data list
String value = "";
try {
value = combo_users.getEditor().getItem().toString();
//System.out.println(value +" <<<<<<<<<<<<<");
} catch (Exception ex) {
}
if (value.length() >= 2) {
//System.out.println("working");
userComboFill(db.searchUser(value));
}
}
});
}
private void displayTextField(ResultSet rs) {
System.out.println("in");
try {
while (rs.next()) {
tf_customerId.setText(rs.getInt("user_id") + "");
tf_name.setText(rs.getString("name"));
tf_contact.setText(rs.getString("phone"));
tf_address.setText(rs.getString("address"));
}
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null, "err from displaying to board");
}
}
private void userComboFill(ResultSet result) {
customerList.clear();
try {
while (result.next()) {
//System.out.println(">>>>>> "+result.getString("name"));
customerList.add(result.getString("name") + ", " + result.getString("address") + "," + result.getString("user_id"));
}
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null, "userCombo fill error");
}
}
private void clearAllFields() {
combo_users.getEditor().setItem(null);
combo_reservationType.setSelectedIndex(0);
tf_address.setText("");
tf_contact.setText("");
tf_customerId.setText("");
tf_guestNo.setText("");
tf_name.setText("");
tf_rooms.setText("");
date_checkIn.setDate(new Date());
date_checkOut.setDate(null);
existingCustomer = false;
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(ControlPanel.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(ControlPanel.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(ControlPanel.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(ControlPanel.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new ControlPanel().setVisible(true);
}
});
}
// Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JButton btn_room_up;
private javax.swing.JButton btn_saveBooking;
private javax.swing.JComboBox combo_reservationType;
private javax.swing.JComboBox combo_users;
private com.toedter.calendar.JDateChooser date_checkIn;
private com.toedter.calendar.JDateChooser date_checkOut;
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private javax.swing.JButton jButton6;
private javax.swing.JButton jButton7;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
private javax.swing.JLabel jLabel12;
private javax.swing.JLabel jLabel13;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JToolBar.Separator jSeparator1;
private javax.swing.JToolBar.Separator jSeparator2;
private javax.swing.JToolBar.Separator jSeparator3;
private javax.swing.JToolBar.Separator jSeparator4;
private javax.swing.JSeparator jSeparator5;
private javax.swing.JToolBar.Separator jSeparator6;
private javax.swing.JSeparator jSeparator7;
private javax.swing.JToolBar.Separator jSeparator8;
private javax.swing.JToolBar jToolBar1;
private javax.swing.JPanel panel_container;
private javax.swing.JList roomsList;
private javax.swing.JTextField tf_address;
private javax.swing.JTextField tf_contact;
private javax.swing.JTextField tf_customerId;
private javax.swing.JTextField tf_guestNo;
private javax.swing.JTextField tf_name;
private javax.swing.JTextField tf_rooms;
// End of variables declaration//GEN-END:variables
}
