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);
 }
}