import java.awt.*;
import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class AddMCat extends JInternalFrame implements ActionListener {

	private JPanel pNew = new JPanel();
	private JLabel lbUser,lbDate,lbBooks;
	private JTextField txtUser,txtDate,txtBooks;
	private JButton btnOk, btnCancel;

	private Statement st;			//Statement for Getting the Required Table.

	//Constructor of Class.

	public AddMCat (Connection con) {

		//super(title, resizable, closable, maximizable, iconifiable)
		super ("New Member Category", false, true, false, true);
		setSize (280, 200);

		//Setting the Form's Labels.

		lbUser = new JLabel ("Category:");
		lbUser.setForeground (Color.black);
		lbUser.setBounds (20, 20, 100, 25);
		lbDate = new JLabel ("Days Issued:");
		lbDate.setForeground (Color.black);
		lbDate.setBounds (20, 55, 100, 25);
		lbBooks= new JLabel ("No. of Books");
		lbBooks.setForeground (Color.black);
		lbBooks.setBounds (20, 90, 100, 25);
		
		//Setting the Form's TextField & PasswordField.

		txtUser = new JTextField ();
		txtUser.setBounds (100, 20, 150, 25);
		
		txtDate = new JTextField ();
		txtDate.setBounds (100, 55, 150, 25);
		txtDate.addKeyListener (new KeyAdapter () {
			public void keyTyped (KeyEvent ke) {
				char c = ke.getKeyChar ();
				if (! ((Character.isDigit (c)) || (c == KeyEvent.VK_BACK_SPACE))) {
					getToolkit().beep ();
					ke.consume ();
				}
			}
		}
		);
		txtBooks = new JTextField();
		txtBooks.setBounds(100,90,150,25);
		txtBooks.addKeyListener (new KeyAdapter () {
			public void keyTyped (KeyEvent ke) {
				char c = ke.getKeyChar ();
				if (! ((Character.isDigit (c)) || (c == KeyEvent.VK_BACK_SPACE))) {
					getToolkit().beep ();
					ke.consume ();
				}
			}
		}
		);
		
		//Setting the Form's Buttons.

		btnOk = new JButton ("OK");
		btnOk.setBounds (20, 123, 100, 25);
		btnOk.addActionListener (this);
		btnCancel = new JButton ("Cancel");
		btnCancel.setBounds (150, 123, 100, 25);
		btnCancel.addActionListener (this);

		//Setting Panel's Layout.

		pNew.setLayout (null);

		//Adding All the Controls in Panel.

		pNew.add (lbUser);
		pNew.add (lbDate);
		pNew.add (lbBooks);
		
		pNew.add (txtUser);
		pNew.add (txtDate);
		pNew.add (txtBooks);
		
		pNew.add (btnOk);
		pNew.add (btnCancel);

		//Adding Panel to the Form.

		getContentPane().add (pNew);

		try {
			st = con.createStatement ();	//Creating Statement Object.
		}
		catch (SQLException sqlex) {			//If Problem then Show the User a Message.
 			JOptionPane.showMessageDialog (null, "A Problem Occurs While Loading the Form.");
 			dispose ();				//Closing the Form.
	 	}

		setVisible (true);

	}

	public void actionPerformed (ActionEvent ae) {

		Object obj = ae.getSource();

		if (obj == btnOk) {		//If OK Button Pressed.

			

			if (txtUser.getText().equals ("")) {
				txtUser.requestFocus();
				JOptionPane.showMessageDialog (this, "Username not Provided.");
			}
			
			else {
				try {	//INSERT Query to Add Book Record in Table.
					String id= txtUser.getText();
					String q = "SELECT CName FROM MeCat ";
					ResultSet rs = st.executeQuery (q);	//Executing the Query.
					int fl=0;
					while(rs.next())
					{
						String memberNo = rs.getString ("CName");	//Storing the Record.
						if(id.equals(memberNo))
						{
							JOptionPane.showMessageDialog(this,"Already existing Category");
							txtUser.setText("");
							txtUser.requestFocus();
							fl=1;
							break;
							
						}
					}
					rs.close();
					int num=0;
					try{
					rs= st.executeQuery("Select * From MeCat");
					
					while(rs.next())
					{
						num++;
					}
					num++;
					rs.close();
					}
					catch(Exception e)
					{
						JOptionPane.showMessageDialog (this, "Problem while Creating excep1.");
					}
					if(fl==0){
					//q = "INSERT INTO MeCat " + 
					//	"VALUES ('" + txtUser.getText() + "')";

					int result = st.executeUpdate ("Insert into MeCat Values(" + num + ", '" + txtUser.getText() + "' ," + Integer.parseInt(txtBooks.getText()) + " , " + Integer.parseInt(txtDate.getText())+ " )" );	//Running Query.
					if (result == 1) {			//If Query Successful.
						JOptionPane.showMessageDialog (this, "New Category Created.");
						txtUser.setText ("");
						txtUser.requestFocus ();
					}
					else {					//If Query Failed.
						JOptionPane.showMessageDialog (this, "Problem while Creating. ");
						txtUser.setText ("");
						txtUser.requestFocus ();
					}
					}
				}
				catch (SQLException sqlex) {
					
					JOptionPane.showMessageDialog (this, "Problem while Creating excep.");
				}
			}

		}		

		if (obj == btnCancel) {		//If Cancel Button Pressed Unload the From.

			setVisible (false);
			dispose();

		}

	}


}