package gui;
import java.awt.*;

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

import java.sql.*;
import java.sql.ResultSetMetaData;
import java.util.Vector;

@SuppressWarnings("serial")
public class loginPage extends JFrame implements ActionListener, KeyListener{

    //requirements for LoginPage
    // two JLabels
    // two JTexts
    // one JButton

    /**
     *
     */
    JLabel labelUsername, labelPassword;
    JTextField textUsername, textPassword;
    JButton submitButton; JButton cancel; JButton b4;
    JButton b1 = new JButton ("Add/Update Category");
    JButton b2 = new JButton ("Manage GuestBok");
    JButton b3 = new JButton ("Manage Shop Creation Requests");
    JButton back = new JButton("Back");
    JButton c1 = new JButton("Add / view Guestbook");
    Connection con;
    Statement st1;
    ResultSet rs1;

    ResultSetMetaData md;
    Vector columnNames, data;


    public void CD(){


        // Connecting to the database
        try {
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             String filename = "c:/db/signup.mdb"; //Location of an Access database
             String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
             database+= filename.trim() + ";DriverID=22;READONLY=true}";
             con = DriverManager.getConnection (database," "," ");
             st1=con.createStatement();

             rs1=st1.executeQuery("select FName from Info");
            }
        catch(Exception e)
            {
             System.out.println("Error in establishing the connection: "+e);
            }

    }




    loginPage(){

        labelUsername = new JLabel("Username: ");
        textUsername = new JTextField(15);
        labelPassword = new JLabel("Password: ");
        textPassword = new JPasswordField(15);
        submitButton = new JButton("Submit");
        cancel = new JButton("Cancel");
        b4 = new JButton("logout");

        setTitle("Online Mall");


        //container
        getContentPane().setLayout(new FlowLayout());

        //content
        getContentPane().add(labelUsername);
        getContentPane().add(textUsername);
        getContentPane().add(labelPassword);
        getContentPane().add(textPassword);
        getContentPane().add(submitButton);
        getContentPane().add(cancel);


        submitButton.addActionListener(this);
        cancel.addActionListener(this);

        //create and show
        pack();
        setVisible(true);
        this.setResizable(false);
        this.setLocationRelativeTo(null);
        setDefaultCloseOperation(EXIT_ON_CLOSE);
        submitButton.addKeyListener(this);
        textPassword.addKeyListener(this);

    }

    public void A(){


        dispose();
        System.out.println("Submit is working");



        getContentPane().setLayout (new FlowLayout());

        getContentPane().removeAll();

        getContentPane().add(b1);
        getContentPane().add(b2);
        getContentPane().add(b3);
        getContentPane().add(b4);

        b1.addActionListener(this);
        b2.addActionListener(this);
        b3.addActionListener(this);
        b4.addActionListener(this);

        pack();
        setVisible(true);


        setDefaultCloseOperation(EXIT_ON_CLOSE);



    }
    public void U(){
        JButton o1 = new JButton("Set Up Shop");
        JButton o2 = new JButton("Discontinue shop");

        getContentPane().removeAll();

        getContentPane().add(o1);
        getContentPane().add(o2);
        getContentPane().add(b4);

        o1.addActionListener(this);
        o2.addActionListener(this);
        b4.addActionListener(this);

        pack();
        setVisible(true);
        }

    public void C(){

        JButton c2 = new JButton("Check Order Details");
        JButton c3 = new JButton ("Enter Shop");

        getContentPane().removeAll();

        getContentPane().add(c1);
        getContentPane().add(c2);
        getContentPane().add(c3);
        getContentPane().add(b4);

        c1.addActionListener(this);
        c2.addActionListener(this);
        c3.addActionListener(this);
        b4.addActionListener(this);

        pack();
        setVisible(true);

    }

    public void J(){
        JTable tabel = new JTable();

        getContentPane().removeAll();

        getContentPane().add(tabel);
        getContentPane().add(b4);

        pack();
        setVisible(true);
        CD();


    }

    public void P(){
        JSpinner spinner = new JSpinner();

        getContentPane().removeAll();

        getContentPane().add(spinner);
        getContentPane().add(b4);

        pack();
        setVisible(true);
        CD();
    }

    public void R(){
        JComboBox c = new JComboBox();

        getContentPane().removeAll();

        getContentPane().add(c);
        getContentPane().add(b4);

        pack();
        setVisible(true);
        CD();
    }


    public void X(){

        System.out.println("This");
        JLabel l = new JLabel("Wrong Login/Password");

        getContentPane().removeAll();

        getContentPane().add(back);
        getContentPane().add(l);
        back.addActionListener(this);

        pack();
        setVisible(true);

    }




    //Enter Key
    public void keyTyped(KeyEvent e) {}
    public void keyReleased(KeyEvent e){}
    public void keyPressed(KeyEvent e){
        int key = e.getKeyCode();
        if (key == KeyEvent.VK_ENTER){
        System.out.println("Enter pressed");
        if (textUsername.getText().contains("admin") && textPassword.getText().contains("root")){
        A();
        }
        else if (textUsername.getText().contains("owner") && textPassword.getText().contains("owner01")){
        U();
            }
        else if (textUsername.getText().contains("customer") && textPassword.getText().contains("customer01")){
        C();
        }
        else {
            X();
        }

        }

    }
    public void actionPerformed(ActionEvent e){
        if (e.getSource() == cancel)
            dispose();
        else if (e.getSource() == submitButton && textUsername.getText().contains("admin") && textPassword.getText().contains("root"))
        {
            A();

        }

        else if (e.getSource() == b4)
            {new loginPage();
            dispose();
        }
                else if (e.getSource() == submitButton && textUsername.getText().contains("owner") && textPassword.getText().contains("owner01"))
        {
            U();
        }

        else if (e.getSource() == submitButton && textUsername.getText().contains("customer") && textPassword.getText().contains("customer01"))
        {C();}

        else if (b3 == e.getSource()){
            J();
        }

        else if (b2 == e.getSource()){
            P();
        }
        else if (c1 == e.getSource()){
            return;
        }
        else if (b1 == e.getSource()){
            R();
        }

        else if (back == e.getSource()){
            dispose();
            new loginPage();
        }
        else{
            X();
        }

    }


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


}