//import the packages for using the classes in them into the program
   import java.awt.*;
   import java.util.*;
   import java.text.*;
   import javax.swing.*;
   import java.awt.event.*;

/**
 *A public class
 */
   public class borrowBooks extends JInternalFrame {
   /***************************************************************************
    ***      declaration of the private variables used in the program       ***
    ***************************************************************************/
   
   //for creating the North Panel
      private JPanel northPanel = new JPanel();
   //for creating the label
      private JLabel title = new JLabel("BOOK INFORMATION");
   
   //for creating the Center Panel
      private JPanel centerPanel = new JPanel();
   //for creating an Internal Panel in the center panel
      private JPanel informationPanel = new JPanel();
   //for creating an array of JLabel
      private JLabel[] informationLabel = new JLabel[4];
   //for creating an array of String
      private String[] informationString = {" Write the Book ID:", " Write the Member ID:",
         " The Current Data:" , " The Return Date:"};
   //for creating an array of JTextField
      private JTextField[] informationTextField = new JTextField[4];
   //for creating the date in the String
      private String date = new SimpleDateFormat("dd-MMM-yy",Locale.US).format(new java.util.Date());
    // for internationalization purpose can use second option  
    //private String date = new SimpleDateFormat("dd-MMM-yy",Locale.getDefault()).format(new java.util.Date());
   
   //for creating an array of string to store the data
      private String[] data;
   
   //for creating an Internal Panel in the center panel
      private JPanel borrowButtonPanel = new JPanel();
   //for creating the button
      private JButton borrowButton = new JButton("Borrow");
   
   //for creating South Panel
      private JPanel southPanel = new JPanel();
   //for creating the button
      private JButton cancelButton = new JButton("Cancel");
   
   //for creating an object from toDatabase() class
      private toDatabase dataToDatabase;
   //for checking the information from the text field
      public boolean isCorrect() {
         data = new String[4];
         for(int i = 0; i < informationLabel.length; i++) {
            if(!informationTextField[i].getText().equals(""))
               data[i] = informationTextField[i].getText();
            else 
               return false;
         }
         return true;
      }
   //constructor of borrowBooks
      public borrowBooks() {
      //for setting the title for the internal frame
         super("Borrow Books", false, true, false, true);
      //for setting the icon
         setFrameIcon(new ImageIcon(ClassLoader.getSystemResource("images/Export16.gif")));
      //for getting the graphical user interface components display area
         Container cp = getContentPane();
      
      //for setting the layout
         northPanel.setLayout(new FlowLayout(FlowLayout.CENTER));
      //for setting the font
         title.setFont(new Font("Tahoma", Font.BOLD, 14));
      //for adding the label to the panel
         northPanel.add(title);
      //for adding the panel to the container
         cp.add("North", northPanel);
      
      //for setting the layout
         centerPanel.setLayout(new BorderLayout());
      //for setting the layout for the internal panel
         informationPanel.setLayout(new GridLayout(4,2,1,1));
      
      /***********************************************************************
       * for adding the strings to the labels, for setting the font 		   *
       * and adding these labels to the panel.							   *
       * finally adding the panel to the container						   *
       ***********************************************************************/
         for(int i = 0; i < informationLabel.length; i++) {
            informationPanel.add(informationLabel[i] = new JLabel(informationString[i]));
            informationLabel[i].setFont(new Font("Tahoma", Font.BOLD, 11));
            if(i == 2) {
               informationPanel.add(informationTextField[i] = new JTextField(date));
               informationTextField[i].setFont(new Font("Tahoma", Font.PLAIN, 11));
               informationTextField[i].setEnabled(false);
            }
            else {
               informationPanel.add(informationTextField[i] = new JTextField());
               informationTextField[i].setFont(new Font("Tahoma", Font.PLAIN, 11));
            }
         }	
         centerPanel.add("Center", informationPanel);
      
      //for setting the layout
         borrowButtonPanel.setLayout(new FlowLayout(FlowLayout.RIGHT));
      //for setting the font to the button
         borrowButton.setFont(new Font("Tahoma", Font.BOLD, 11));
      //for adding the button to the panel
         borrowButtonPanel.add(borrowButton);
      //for adding the panel to the center panel
         centerPanel.add("South", borrowButtonPanel);
      //for setting the border to the panel
         centerPanel.setBorder(BorderFactory.createTitledBorder("Borrow a book:"));
      //for adding the panel to the container
         cp.add("Center", centerPanel);
      
      //for adding the layout
         southPanel.setLayout(new FlowLayout(FlowLayout.RIGHT));
      //for setting the font to the button
         cancelButton.setFont(new Font("Tahoma", Font.BOLD, 11));
      //for adding the button to the panel
         southPanel.add(cancelButton);
      //for setting the border to the panel
         southPanel.setBorder(BorderFactory.createEtchedBorder());
      //for adding the panel to the container
         cp.add("South", southPanel);
      
      /***********************************************************************
       * for adding the action listener to the button,first the text will be *
       * taken from the JTextField[] and make the connection for database,   *
       * after that update the table in the database with the new value      *
       ***********************************************************************/
         borrowButton.addActionListener(
                                 new ActionListener() {
                                    public void actionPerformed(ActionEvent ae) {
                                    //for checking if there is a missing information
                                       if(isCorrect()) {
                                          Thread runner = 
                                             new Thread() {
                                                public void run() {
                                                   dataToDatabase = new toDatabase();
                                                //for checking if there is no same information in the database
                                                   if((dataToDatabase.memberID("SELECT MemberID FROM Books WHERE BookID = " + data[0])) == 0) {
                                                      dataToDatabase.update("UPDATE Books SET Availble = false, " +
                                                                           "DateOfBorrowed = '" + data[2] + "', " +
                                                                           "DateOfReturn   = '" + data[3] + "', " +
                                                                           "MemberID       =  " + data[1] +
                                                                           " WHERE BookID  =  " + data[0]);
                                                      int numberOfBooks = 1 + dataToDatabase.numberOfBooks("SELECT numberOfBooks FROM " +
                                                                        "Members WHERE MemberID = " + data[1]);
                                                      dataToDatabase.update("UPDATE Members SET numberOfBooks = " +
                                                                           numberOfBooks + " WHERE MemberID = " + data[1]);
                                                   //for setting the array of JTextField to null
                                                      for(int i = 0; i < informationTextField.length; i++)
                                                         if(i != 2)
                                                            informationTextField[i].setText(null);
                                                   }
                                                   else
                                                      JOptionPane.showMessageDialog(null,"The book is borrowed","Warning",JOptionPane.WARNING_MESSAGE);
                                                }
                                             };
                                          runner.start();
                                       }
                                       //if there is a missing data, then display Message Dialog
                                       else
                                          JOptionPane.showMessageDialog(null,"Please, complete the information","Warning",JOptionPane.WARNING_MESSAGE);
                                    }
                                 });
      //for adding the action listener for the button to dispose the frame
         cancelButton.addActionListener(
                                 new ActionListener() {
                                    public void actionPerformed(ActionEvent ae) {
                                       dispose();
                                    }
                                 });
      //for setting the visible to true
         setVisible(true);
      //show the internal frame
         pack();
      }
   }