package foodbankdatabase3;

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

public class FoodBankDatabase extends JFrame{
    /*
    Initializing Variables
    */
    static String testConnect;
    static Connection conn;
    static PreparedStatement pst;
    static ResultSet rs;
    /*
    Initializing JPanels
    */
    JPanel contPanel = new JPanel();
    JPanel loginGui = new JPanel();
    JPanel usernamePanel = new JPanel();
    JPanel passwordPanel = new JPanel();
    JPanel mainMenuGui = new JPanel();
    JPanel loginButtonPanel = new JPanel();
    JPanel testConnectPanel = new JPanel();
    /*
    Initializing JLabels
    */
    JLabel usernameLabel = new JLabel("Username: ");
    JLabel passwordLabel = new JLabel("Password: ");
    JLabel testConnectLabel = new JLabel(testConnect);
    /*
    Initializing JTextFields
    */
    JTextField usernameTextField = new JTextField(10);
    JPasswordField passwordTextField = new JPasswordField(10);
    /*
    Initializing JButtons
    */
    JButton loginButton = new JButton("Click here to login");
    JButton logoutButton = new JButton("Click here to logout");
    JButton conductInterview = new JButton("Conduct an interview");
    JButton addClient = new JButton("Add a new client");
    JButton viewClient = new JButton("View existing client details");


    CardLayout cardLayout = new CardLayout();

    public FoodBankDatabase(){
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        initComponents();
        pack();
        setVisible(true);
    }

    private void initComponents(){
        contPanel.setLayout(cardLayout);

        /*
        Login Gui Components
        */
        loginGui.setLayout(new BoxLayout(loginGui, BoxLayout.Y_AXIS));
        usernamePanel.add(usernameLabel);
        usernamePanel.add(usernameTextField);
        passwordPanel.add(passwordLabel);
        passwordPanel.add(passwordTextField);
        loginButtonPanel.add(loginButton);
        testConnectPanel.add(testConnectLabel);
        loginGui.add(usernamePanel);
        loginGui.add(passwordPanel);
        loginGui.add(loginButtonPanel);
        loginGui.add(testConnectPanel);

        /*
        Main Menu Gui Components
        */
        mainMenuGui.setLayout(new BoxLayout(mainMenuGui, BoxLayout.Y_AXIS));
        mainMenuGui.add(conductInterview);
        mainMenuGui.add(addClient);
        mainMenuGui.add(viewClient);
        mainMenuGui.add(logoutButton);

        contPanel.add(loginGui, "loginGui");
        contPanel.add(mainMenuGui, "mainMenuGui");

        cardLayout.show(contPanel, "loginGui");

        loginButton.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                String sql="SELECT * FROM loginDetails WHERE username=? AND password=?";
                try{
                    pst = conn.prepareStatement(sql);
                    pst.setString(1, usernameTextField.getText());
                    pst.setString(1, passwordTextField.getText());

                    rs=pst.executeQuery();
                    if(rs.next()){
                        JOptionPane.showMessageDialog(null, "Username and Password are correct");
                    }else{
                        JOptionPane.showMessageDialog(null, "Username and Password are not correct");
                    }

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

        logoutButton.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                    cardLayout.show(contPanel, "loginGui");
            }
        });

        add(contPanel);
    }

    private static void testConnection(){
        try{
            Connection con = DriverManager.getConnection("jdbc:mysql://sql5.freemysqlhosting.net:3306/sql562010", "sql562010", "bV5*yJ5%");

            Statement stat = (Statement) con.createStatement();

            testConnect = "Connection successful!";
        }catch(Exception e){
            testConnect = "Connection unsuccessful";
            System.out.println(e);
        }
    }

    public static void main(String[] args) {
        testConnection();
        new FoodBankDatabase();
    }
}