public void display(ResultSet rs) {
try {
boolean recordNumber = rs.next();
if (recordNumber) {
payNo = rs.getString(1);
pasNo = rs.getString(2);
pasName = rs.getString(3);
mode = rs.getString(4);
dt = rs.getString(5);
amount = rs.getString(6);
rev = rs.getString(7);
text1.setText(payNo);
combo1.setSelectedItem(pasNo);
combo2.setSelectedItem(pasName);
combo4.setSelectedItem(mode);
p_date.setText(dt);
combo8.setSelectedItem(amount);
combo3.setSelectedItem(rev);
} else {
JOptionPane.showMessageDialog(
null, "Record Not found", "ERROR", JOptionPane.DEFAULT_OPTION);
}
} catch (SQLException sqlex) {
sqlex.printStackTrace();
}
}
/**
* Create a default filename given the current date selection. If custom dates are selected, use
* those dates; otherwise, use year and week numbers.
*
* @return The default filename.
*/
private String getDefaultFilename() {
if (yearCB.getSelectedIndex() == 0 || weekCB.getSelectedIndex() == 0)
return "timesheet-"
+ dateFormat.format(fromDate.getDate()).replaceAll("/", "")
+ "-"
+ dateFormat.format(toDate.getDate()).replaceAll("/", "")
+ ".txt";
return "timesheet-" + yearCB.getSelectedItem() + "wk" + weekCB.getSelectedItem() + ".txt";
}
/**
* Set calendar to this week's Monday; set year and week combo boxes to the currently set date;
* set the date labels appropriately; and, refresh the review table.
*/
private void updateYearWeekDates() {
yearWeekCalendar.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY);
yearWeekCalendar.set(Calendar.HOUR_OF_DAY, 0);
yearWeekCalendar.set(Calendar.MINUTE, 0);
yearWeekCalendar.set(Calendar.SECOND, 0);
yearWeekCalendar.set(Calendar.MILLISECOND, 0);
yearCB.setSelectedItem(yearWeekCalendar.get(Calendar.YEAR));
weekCB.setSelectedItem(yearWeekCalendar.get(Calendar.WEEK_OF_YEAR));
fromDate.setDate(yearWeekCalendar);
yearWeekCalendar.add(Calendar.DAY_OF_MONTH, 7);
toDate.setDate(yearWeekCalendar);
yearWeekCalendar.add(Calendar.DAY_OF_MONTH, -7);
refreshReviewTable();
}
private void setamount() {
try {
ResultSet rst =
DBConnection.getDBConnection()
.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE)
.executeQuery(
"SELECT Amount FROM BOOKING where Pass_No='" + combo1.getSelectedItem() + "'");
while (rst.next()) {
combo8.addItem(rst.getString(1));
}
} catch (Exception n) {
n.printStackTrace();
}
}
private void setcbr() {
try {
ResultSet rst =
DBConnection.getDBConnection()
.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE)
.executeQuery(
"SELECT * FROM Passenger where Booked_status='Booked' and Pay_Status='Not_Paid'");
System.out.println("Hello");
while (rst.next()) {
combo1.addItem(rst.getString(1));
combo2.addItem(rst.getString(2));
}
} catch (Exception n) {
n.printStackTrace();
}
}
private void setCombo() {
try {
ResultSet rst =
DBConnection.getDBConnection()
.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE)
.executeQuery(
"SELECT Emp.empNo, Emp.Sname, Emp.Fname, Emp.Lname, Emp.Designation FROM Emp WHERE Emp.Designation='Booking Clerk'");
while (rst.next()) {
combo3.addItem(rst.getString(3));
}
} catch (Exception n) {
n.printStackTrace();
}
}
public void setRenderer(ListCellRenderer<? super Locale> newValue) {
renderer = null;
super.setRenderer(newValue);
}
public void setLocale(Locale newValue) {
super.setLocale(newValue);
sort();
}
/**
* Returns the unique ID of a week prefixed with the year.
*
* @return Selected week's ID.
*/
String getSelectedWeekID() {
String weekNo = weekCB.getSelectedItem().toString();
if (weekNo.length() == 1) weekNo = "0" + weekNo;
return yearCB.getSelectedItem() + "wk" + weekNo;
}
/**
* Checks whether the interval has been set using the date chooser.
*
* @return True if custom.
*/
boolean isIntervalCustom() {
return yearCB.getSelectedIndex() == 0 || weekCB.getSelectedIndex() == 0;
}
/** Set both year and week combo boxes to field "Custom". */
private void resetYearWeekComboBoxes() {
yearCB.setSelectedIndex(0);
weekCB.setSelectedIndex(0);
}
public Payment() {
super("Payment Process", false, true, false, true);
setDefaultCloseOperation(DISPOSE_ON_CLOSE);
label1 = new JLabel("Paymnent Number");
label2 = new JLabel("Passenger Number");
label3 = new JLabel("Passenger Name");
label6 = new JLabel("Mode of Payment");
label4 = new JLabel("Date of Payment");
label5 = new JLabel("Amount Paid");
label7 = new JLabel("Received By");
text1 = new JTextField(10);
text5 = new JTextField(10);
p_date = new DateButton();
p_date.setForeground(Color.red);
combo1 = new JComboBox();
combo2 = new JComboBox();
combo3 = new JComboBox();
combo4 = new JComboBox();
combo4.addItem("Cash");
combo4.addItem("Bank");
combo8 = new JComboBox();
button1 =
new JButton("Pay", new ImageIcon(ClassLoader.getSystemResource("Images/payments.png")));
button2 =
new JButton(
"Print Receipt", new ImageIcon(ClassLoader.getSystemResource("Images/print.png")));
button3 =
new JButton("Cancel", new ImageIcon(ClassLoader.getSystemResource("Images/exit.png")));
button4 =
new JButton("Search", new ImageIcon(ClassLoader.getSystemResource("Images/search.png")));
button5 =
new JButton("Delete", new ImageIcon(ClassLoader.getSystemResource("Images/delete.png")));
// combo3.addItem(new)
panel1 = new JPanel(new GridLayout(7, 2));
panel1.setPreferredSize(new Dimension(350, 250));
panel1.add(label1);
panel1.add(text1);
panel1.add(label2);
panel1.add(combo1);
panel1.add(label3);
panel1.add(combo2);
panel1.add(label6);
panel1.add(combo4);
panel1.add(label4);
panel1.add(p_date);
panel1.add(label5);
panel1.add(combo8);
panel1.add(label7);
panel1.add(combo3);
// combo8.removeAllItems();
pane = new JPanel();
pane.add(button1);
pane.add(button2);
pane.add(button3);
pane.add(button4);
panel3 = new JPanel();
panel3.add(panel1);
panel3.add(pane);
button2.setEnabled(false);
add(panel3);
setSize(500, 350);
setCombo();
setcbr();
generator();
setamount();
setLocation((screen.width - 300) / 2, ((screen.height - 300) / 2));
setResizable(false);
combo1.addActionListener(
new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
combo2.setSelectedIndex(combo1.getSelectedIndex());
combo8.removeItem(combo8.getSelectedItem());
setamount();
}
});
button3.addActionListener(
new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
setVisible(true);
dispose();
}
});
button2.addActionListener(
new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
Receipt frm = new Receipt();
MDIWindow.desktop.add(frm);
frm.setVisible(true);
button2.setEnabled(false);
}
});
button1.addActionListener(
new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
if (combo1.getSelectedItem() == null) {
JOptionPane.showMessageDialog(
null, "All Passenger have paid", "Error", JOptionPane.DEFAULT_OPTION);
return;
}
if (combo2.getSelectedItem() == null) {
JOptionPane.showMessageDialog(
null, "All Passenger have paid", "Error", JOptionPane.DEFAULT_OPTION);
return;
}
generator();
if (combo8.getSelectedItem() == null) {
JOptionPane.showMessageDialog(
null, "The Passenger has not been booked", "ERROR", JOptionPane.DEFAULT_OPTION);
return;
}
try {
Statement statement = DBConnection.getDBConnection().createStatement();
{
String temp =
"INSERT INTO Payment (Payment_No, Pass_No, Pass_Name, Payment_Mode, Date_Payment,Amount_Paid,Received_By) VALUES ('"
+ text1.getText()
+ "', '"
+ combo1.getSelectedItem()
+ "', '"
+ combo2.getSelectedItem()
+ "', '"
+ combo4.getSelectedItem()
+ "', '"
+ p_date.getText()
+ "', '"
+ combo8.getSelectedItem()
+ "', '"
+ combo3.getSelectedItem()
+ "')";
combo1.removeItem(combo1.getSelectedItem());
combo2.removeItem(combo2.getSelectedItem());
int result = statement.executeUpdate(temp);
JOptionPane.showMessageDialog(
null, "Passenger Account updated", "Updated", JOptionPane.DEFAULT_OPTION);
}
} catch (SQLException sqlex) {
sqlex.printStackTrace();
}
try {
Statement statement = DBConnection.getDBConnection().createStatement();
{
String temp =
"UPDATE Passenger SET Pay_Status='Paid'"
+ "WHERE Pass_NO LIKE '"
+ combo1.getSelectedItem()
+ "'";
int result = statement.executeUpdate(temp);
}
} catch (SQLException sqlex) {
sqlex.printStackTrace();
}
button1.setEnabled(false);
button2.setEnabled(true);
}
});
button4.addActionListener(
new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
if (!text1.equals("")) {
Statement statement = DBConnection.getDBConnection().createStatement();
String query =
("SELECT * FROM Payment where Payment_No ='" + text1.getText() + "'");
ResultSet rs = statement.executeQuery(query);
display(rs);
statement.close();
}
} catch (SQLException sqlex) {
sqlex.printStackTrace();
}
setVisible(true);
}
});
}