package quiz_windows;

import java.awt.Color;
import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JPasswordField;
import java.awt.Font;
import java.awt.Window;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;


import java.sql.*;
import javax.swing.*;

public class Login {

	private JFrame LoginFrame;
	private JTextField textFieldUsN;
	private JPasswordField passwordField;

	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					Login window = new Login();
					window.LoginFrame.setVisible(true);
						} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	Connection connection = null;

	/**
	 * Create the application.
	 */
	public Login() {
		initialize();
		connection = sqliteConnection.dbConnector(); //Initialises connection
	}

	/**
	 * Initialize the contents of the frame.
	 */
	private void initialize() {
		LoginFrame = new JFrame();
		LoginFrame.setBounds(100, 100, 691, 408);
		LoginFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		LoginFrame.getContentPane().setLayout(null);

		JButton LoginBtn = new JButton("Login ");
		LoginBtn.setActionCommand("Login");
		LoginBtn.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				try{
					String query = "select * from StudentDetailsTbl where Username=? and Password=? "; //Makes a query to the database
					PreparedStatement pst = connection.prepareStatement(query); //Creates and object and passed the query to the PreparedStatement
                    pst.setString(1, textFieldUsN.getText() );
                    pst.setString(2, passwordField.getText() );

                    ResultSet rs = pst.executeQuery();
                    int count = 0;
                    while(rs.next()){
                    	count = count+1;

                    }
                    if (count == 1)
                    {
                    	JOptionPane.showMessageDialog(null, "Username and Password is correct");
                    	LoginFrame.dispose();
                    	new Mainmenu();
                    }
                    else{
                    	JOptionPane.showMessageDialog(null, "Username and Password is incorrect, Try again");
                    }
                    rs.close();
                    pst.close(); //Closes connection to database
				}catch(Exception e)
				{
				   JOptionPane.showMessageDialog(null, e);
				}
				finally{
					try{

					}catch(Exception e)
					{
						JOptionPane.showMessageDialog(null, e);
					}
				}

			}

		});

		LoginBtn.setBounds(312, 293, 89, 23);
		LoginBtn.setBackground(new Color(59, 89, 182));
        LoginBtn.setForeground(Color.WHITE);
		LoginFrame.getContentPane().add(LoginBtn);

		JLabel Usernamelbl = new JLabel("Username");
		Usernamelbl.setFont(new Font("Tahoma", Font.BOLD, 14));
		Usernamelbl.setBounds(237, 124, 89, 23);
		LoginFrame.getContentPane().add(Usernamelbl);

		JLabel Passwordlbl = new JLabel("Password");
		Passwordlbl.setFont(new Font("Tahoma", Font.BOLD, 14));
		Passwordlbl.setBounds(237, 179, 78, 17);
		LoginFrame.getContentPane().add(Passwordlbl);

		textFieldUsN = new JTextField();
		textFieldUsN.setBounds(347, 127, 97, 23);
		LoginFrame.getContentPane().add(textFieldUsN);
		textFieldUsN.setColumns(10);

		passwordField = new JPasswordField();
		passwordField.setBounds(347, 179, 97, 23);
		LoginFrame.getContentPane().add(passwordField);

		JButton btnRegister = new JButton("Register");
		btnRegister.setBackground(new Color(59, 89, 182));
        btnRegister.setForeground(Color.WHITE);
		btnRegister.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				LoginFrame.dispose();
				new Register();
			}

		});
		btnRegister.setBounds(576, 11, 89, 23);
		LoginFrame.getContentPane().add(btnRegister);

		LoginFrame.setVisible(true);
	}
}