menu

import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JPanel;
import java.awt.BorderLayout;
import java.awt.CardLayout;
import javax.swing.JLabel;
import java.awt.Font;
import javax.swing.JRadioButton;
import java.awt.GridBagLayout;
import java.awt.GridBagConstraints;
import java.awt.Insets;
import javax.swing.JTextField;

import com.mysql.jdbc.Statement;

import net.proteanit.sql.DbUtils;

import javax.swing.JPasswordField;
import javax.swing.JButton;
import javax.swing.AbstractButton;
import javax.swing.ButtonGroup;
import javax.swing.DefaultComboBoxModel;

import java.awt.event.ActionListener;
import java.sql.*;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.List;
import java.util.Properties;
import java.awt.event.ActionEvent;
import java.awt.GridLayout;
import com.jgoodies.forms.layout.FormLayout;
import com.jgoodies.forms.layout.ColumnSpec;
import com.jgoodies.forms.layout.RowSpec;
import javax.swing.JTextPane;
import javax.swing.JTextArea;
import java.awt.Button;
import javax.swing.BoxLayout;
import java.awt.FlowLayout;
import java.awt.TextField;
import javax.swing.GroupLayout;
import javax.swing.GroupLayout.Alignment;
import javax.swing.LayoutStyle.ComponentPlacement;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

import org.jdatepicker.impl.JDatePanelImpl;
import org.jdatepicker.impl.JDatePickerImpl;
import org.jdatepicker.impl.UtilDateModel;

import java.awt.Color;
import javax.swing.JList;
import javax.swing.JComboBox;
import javax.swing.JTable;
import javax.swing.JScrollPane;
import javax.swing.JFormattedTextField;

public class DriverMenu {

    private JFrame frame;
    private JTextField usernameField1;
    private JPasswordField passwordField1;
    private final ButtonGroup buttonGroup = new ButtonGroup();
    private JTextField manifestField;
    private JTextField userField;
    private JTextField pwField;
    private JTextField nameField;
    private JTextField emailField;
    private JTextField userID;
    private JTextField userName;
    private JTextField passWord;
    private JTextField userIdfield;
    private JTable usertable;
    private JTextField customerID;
    private JTextField itemID;
    private JTextField orderID_field;
    private JTextField orderID;
    private JTable viewOrderstable;
    private JTable DeliveriesTable;

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

    /**
     * Create the application.
     */
    public DriverMenu() {
        initialize();
    }

    /**
     * Initialise the contents of the frame.
     */
    private void initialize() {
        frame = new JFrame("Delivery Mate");
        frame.setBounds(100, 100, 450, 300);
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.getContentPane().setLayout(new CardLayout(0, 0));

        final JPanel LoginScreen = new JPanel();
        frame.getContentPane().add(LoginScreen, "name_207530697233738");
        LoginScreen.setVisible(true);
        LoginScreen.setLayout(null);

        final JPanel DeliveryDropsScreen = new JPanel();
        frame.getContentPane().add(DeliveryDropsScreen, "name_207530725353173");
        DeliveryDropsScreen.setLayout(null);
        DeliveryDropsScreen.setVisible(false);

        final JPanel DropDetailsScreen = new JPanel();
        frame.getContentPane().add(DropDetailsScreen, "name_207530736043688");
        DropDetailsScreen.setLayout(null);

        JScrollPane scrollPane_4 = new JScrollPane();
        scrollPane_4.setBounds(10, 11, 414, 180);
        DropDetailsScreen.add(scrollPane_4);

        JScrollPane scrollPane_3 = new JScrollPane();
        scrollPane_4.setViewportView(scrollPane_3);

        DeliveriesTable = new JTable();
        DeliveriesTable.setEnabled(false);
        scrollPane_3.setViewportView(DeliveriesTable);
        DropDetailsScreen.setVisible(false);

        final JPanel DropContactinfoScreen = new JPanel();
        frame.getContentPane().add(DropContactinfoScreen, "name_207530746600288");
        DropContactinfoScreen.setLayout(null);

        final JPanel AdminScreen = new JPanel();
        frame.getContentPane().add(AdminScreen, "name_366575809614281");
        AdminScreen.setLayout(null);
        AdminScreen.setVisible(false);

        final JPanel ManifestScreen = new JPanel();
        frame.getContentPane().add(ManifestScreen, "name_207530714550072");
        ManifestScreen.setLayout(null);
        ManifestScreen.setVisible(false);

        final JPanel createDriver = new JPanel();
        frame.getContentPane().add(createDriver, "name_372280905846196");
        createDriver.setLayout(null);
        createDriver.setVisible(false);

        final JPanel deleteDriver = new JPanel();
        frame.getContentPane().add(deleteDriver, "name_387139362781477");
        deleteDriver.setLayout(null);
        deleteDriver.setVisible(false);

        final JPanel driverDetails = new JPanel();
        frame.getContentPane().add(driverDetails, "name_387154147718154");
        driverDetails.setLayout(null);
        driverDetails.setVisible(false);

        final JPanel addOrders = new JPanel();
        frame.getContentPane().add(addOrders, "name_387173677401370");
        addOrders.setLayout(null);
        addOrders.setVisible(false);

        final JPanel deleteOrders = new JPanel();
        frame.getContentPane().add(deleteOrders, "name_387186687503037");
        deleteOrders.setLayout(null);

        final JPanel viewOrder = new JPanel();
        frame.getContentPane().add(viewOrder, "name_548751439739632");
        viewOrder.setLayout(null);
        viewOrder.setVisible(false);

        JLabel lblCustomerName = new JLabel("Customer Name");
        lblCustomerName.setBounds(10, 11, 120, 22);
        DropContactinfoScreen.add(lblCustomerName);

        JLabel lblCustomerAddress = new JLabel("Customer Address");
        lblCustomerAddress.setBounds(10, 44, 120, 53);
        DropContactinfoScreen.add(lblCustomerAddress);
        DropContactinfoScreen.setVisible(false);


        JButton deleteOrders_back = new JButton("Back");
        deleteOrders_back.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                AdminScreen.setVisible(true);
                deleteOrders.setVisible(false);
            }
        });
        deleteOrders_back.setBounds(190, 213, 80, 37);
        deleteOrders.add(deleteOrders_back);

        JButton btnSort = new JButton("Sort");
        btnSort.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                OrderInfo postcode;
                GeoCoder geo;
                try {
                    postcode = new OrderInfo();
                    String address = postcode.getPostcode().toString();
                    geo = new GeoCoder();
                    GeocodeResponse coords = geo.getLocation(address);
                } catch (Exception e1) {
                    // TODO Auto-generated catch block
                    e1.printStackTrace();
                }

                //TODO Convert delivery addresses to geocodes and then organise to best route

            }
        });
        btnSort.setBounds(173, 215, 100, 35);
        DropDetailsScreen.add(btnSort);

        JButton btnLogOff_1 = new JButton("Log Off");
        btnLogOff_1.setBounds(283, 215, 100, 35);
        btnLogOff_1.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                LoginScreen.setVisible(true);
                DropDetailsScreen.setVisible(false);
            }
        });
        DropDetailsScreen.add(btnLogOff_1);

        JButton btnViewMap = new JButton("View Map");
        btnViewMap.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {

            }
        });
        btnViewMap.setBounds(63, 215, 100, 35);
        DropDetailsScreen.add(btnViewMap);

        JButton deleteOrders_clear = new JButton("Clear");
        deleteOrders_clear.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                orderID_field.setText(null);
            }
        });
        deleteOrders_clear.setBounds(100, 213, 80, 37);
        deleteOrders.add(deleteOrders_clear);

        JButton deleteOrders_submit = new JButton("Submit");
        deleteOrders_submit.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                DBConnect db = null;
                try {
                    String orderid = orderID_field.getText();
                    db = new DBConnect();
                    db = db.deleteOrder(orderid);

                } catch (Exception e4) {
                    System.err.println(e4.getMessage());
                }
                //TODO drop stmt based on order number
            }
        });
        deleteOrders_submit.setBounds(10, 213, 80, 37);
        deleteOrders.add(deleteOrders_submit);

        JLabel lblOrderId = new JLabel("Order ID");
        lblOrderId.setBounds(10, 82, 115, 25);
        deleteOrders.add(lblOrderId);

        orderID_field = new JTextField();
        orderID_field.setBounds(100, 82, 129, 25);
        deleteOrders.add(orderID_field);
        orderID_field.setColumns(10);

        JLabel lblEnterOrderId = new JLabel("Enter Customer ID");
        lblEnterOrderId.setBounds(0, 0, 114, 24);
        viewOrder.add(lblEnterOrderId);

        orderID = new JTextField();
        orderID.setColumns(10);
        orderID.setBounds(124, 2, 160, 20);
        viewOrder.add(orderID);

        JButton button = new JButton("Submit");
        button.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                DBConnect db = null;
                String orderid = orderID.getText();
                List<OrderInfo> values = null;
                try {
                    db = new DBConnect();
                    values = db.loadOrder(orderid);
                } catch (Exception e1) {
                    e1.printStackTrace();
                }
                DefaultTableModel ordersmodel = new DefaultTableModel(new Object[][] {}, new String[] {"Order ID", "CustomerID", "Item ID", "Delivery Date"});
                for(OrderInfo v : values) {
                    ordersmodel.addRow(new Object[] {v.getOrderid(), v.getCustomerid(), v.getItemid(), v.getItemname()});
                } viewOrderstable.setModel(ordersmodel);
            }

        });
        button.setBounds(294, 1, 120, 23);
        viewOrder.add(button);

        JButton vieworder_backBtn = new JButton("Back");
        vieworder_backBtn.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                AdminScreen.setVisible(true);
                viewOrder.setVisible(false);
            }
        });
        vieworder_backBtn.setBounds(325, 200, 89, 39);
        viewOrder.add(vieworder_backBtn);

        JScrollPane viewOrder_table = new JScrollPane();
        viewOrder_table.setBounds(10, 35, 414, 159);
        viewOrder.add(viewOrder_table);

        viewOrderstable = new JTable();
        viewOrder_table.setViewportView(viewOrderstable);
        viewOrder.setVisible(false);

        JLabel lblCustomersId = new JLabel("Customers ID");
        lblCustomersId.setBounds(10, 11, 115, 30);
        addOrders.add(lblCustomersId);

        JLabel lblItemId = new JLabel("Item ID");
        lblItemId.setBounds(10, 52, 115, 30);
        addOrders.add(lblItemId);

        customerID = new JTextField();
        customerID.setBounds(135, 16, 170, 25);
        addOrders.add(customerID);
        customerID.setColumns(10);

        itemID = new JTextField();
        itemID.setColumns(10);
        itemID.setBounds(135, 55, 170, 25);
        addOrders.add(itemID);

        UtilDateModel model2 = new UtilDateModel();
        Properties p = new Properties();
        p.put("text.today",  "Today");
        p.put("text.month", "Month");
        p.put("text.year", "Year");
        JDatePanelImpl datePanel = new JDatePanelImpl(model2, p);
        JDatePickerImpl datePicker = new JDatePickerImpl(datePanel, new DateLabelFormatter());
        datePicker.setSize(170, 25);
        datePicker.setLocation(135, 98);
        addOrders.add(datePicker);

        JButton addOrder_back = new JButton("Back");
        addOrder_back.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                AdminScreen.setVisible(true);
                addOrders.setVisible(false);
            }
        });
        addOrder_back.setBounds(190, 213, 80, 37);
        addOrders.add(addOrder_back);

        JButton addOrder_clear = new JButton("Clear");
        addOrder_clear.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                customerID.setText(null);
                itemID.setText(null);
            }
        });
        addOrder_clear.setBounds(100, 213, 80, 37);
        addOrders.add(addOrder_clear);

        JButton addOrder_sbmt = new JButton("Submit");
        addOrder_sbmt.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                // TODO create insert stmnt
                DBConnect db = null;

                String custid = customerID.getText();
                String itemid = itemID.getText();
                Date date = (Date) datePicker.getModel().getValue();

                try {
                    db = new DBConnect();
                    db = db.addOrder(custid, itemid, date);
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
        });
        addOrder_sbmt.setBounds(10, 213, 80, 37);
        addOrders.add(addOrder_sbmt);

        JLabel lblDeliverydate = new JLabel("DeliveryDate");
        lblDeliverydate.setBounds(10, 93, 115, 30);
        addOrders.add(lblDeliverydate);



        JLabel lblEnterUserId = new JLabel("Enter User ID");
        lblEnterUserId.setBounds(10, 11, 100, 24);
        driverDetails.add(lblEnterUserId);

        userIdfield = new JTextField();
        userIdfield.setBounds(105, 13, 160, 20);
        driverDetails.add(userIdfield);
        userIdfield.setColumns(10);

        JButton btnSubmit_1 = new JButton("Submit");
        btnSubmit_1.addActionListener(new ActionListener() {


            public void actionPerformed(ActionEvent event) {
                DBConnect db = null;
                String userid = userIdfield.getText();
                List<UserInfo> values = null;
                try {
                    db = new DBConnect();
                    values = db.loadUsers(userid);
                } catch (SQLException e1) {
                    // TODO Auto-generated catch block
                    e1.printStackTrace();
                }
                DefaultTableModel model = new DefaultTableModel(new Object[][] {}, new String[] {"User ID","Username","Password","Name","Email","User Auth"});
                for(UserInfo v : values) {
                    model.addRow(new Object[] {v.getUserID(),v.getUsername(),v.getPassword(),v.getName(),v.getEmail(),v.getUserauth()});
                }
                usertable.setModel(model);
                    /* query = new DBConnect();
                    query = (DBConnect) query.loadUsers( userid);
                    usertable.setModel(DbUtils.resultSetToTableModel(DBConnect.loadUsers(rs)));
                    //TODO Fix this mess.. https://stackoverflow.com/questions/17947762/accessing-data-from-resultset-in-another-class-java
                     *
                     */

            }
        });
        btnSubmit_1.setBounds(275, 12, 120, 23);
        driverDetails.add(btnSubmit_1);

        JScrollPane scrollPane_2 = new JScrollPane();
        scrollPane_2.setBounds(10, 73, 414, 127);
        driverDetails.add(scrollPane_2);

        JScrollPane scrollPane = new JScrollPane();
        scrollPane.setEnabled(false);
        scrollPane_2.setViewportView(scrollPane);


        usertable = new JTable();
        //usertable.setModel(model);
        scrollPane.setViewportView(usertable);
        //DefaultTableModel model = new DefaultTableModel(new Object[][] {}, new String[] {"First column","Second column","Third column","Fourth column","Fifth column"});

        JButton backBtn = new JButton("Back");
        backBtn.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                AdminScreen.setVisible(true);
                driverDetails.setVisible(false);
            }
        });
        backBtn.setBounds(335, 211, 89, 39);
        driverDetails.add(backBtn);
        driverDetails.setVisible(false);

        manifestField = new JTextField();
        manifestField.setBounds(80, 90, 258, 20);
        manifestField.setColumns(10);

        JButton btnRequest = new JButton("Request");
        btnRequest.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                DropDetailsScreen.setVisible(true);
                ManifestScreen.setVisible(false);
                //String maninum = manifestField.getText();
                DBConnect manifest = null;
                List<OrderInfo> drops = null;
                try
                {
                    manifest = new DBConnect();
                    drops = manifest.getDrops();
                } catch (Exception e1) {
                    System.err.println(e1);
                }
                DefaultTableModel dropsmodel = new DefaultTableModel(new Object[][] {}, new String[]
                        {"Order ID","Customer ID","First Name","Last Name","Email","House Number", "Street Name", "Post Code", "Latitude", "Longitude"});
                //CustID, First name, Last name, Email, post code, street name, city, orderID, Delivery Date
                for(OrderInfo v : drops) {
                    dropsmodel.addRow(new Object[] {v.getOrderid(), v.getCustomerid(),
                            v.getFirstname(), v.getLastname(), v.getEmail(), v.getHousenum(),
                            v.getStreetname(), v.getPostcode(), v.getLatitude(), v.getLongitude()});
            } DeliveriesTable.setModel(dropsmodel);
            }
        });
        btnRequest.setBounds(90, 121, 95, 23);

        JButton btnLogOff = new JButton("Log off");
        btnLogOff.setBounds(243, 121, 95, 23);
        btnLogOff.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                ManifestScreen.setVisible(false);
                LoginScreen.setVisible(true);
            }
        });
        ManifestScreen.setLayout(null);
        ManifestScreen.add(manifestField);
        ManifestScreen.add(btnRequest);
        ManifestScreen.add(btnLogOff);

        JLabel lblEnterAManifest = new JLabel("Enter a Manifest number or press Request");
        lblEnterAManifest.setFont(new Font("Segoe UI Semilight", Font.PLAIN, 14));
        lblEnterAManifest.setBounds(80, 30, 258, 26);
        ManifestScreen.add(lblEnterAManifest);

        JLabel lblDeliveryMate = new JLabel("Delivery Mate");
        lblDeliveryMate.setBounds(133, 11, 129, 24);
        lblDeliveryMate.setFont(new Font("Segoe UI Semibold", Font.ITALIC, 17));
        LoginScreen.add(lblDeliveryMate);

        JRadioButton rdbtnDriver = new JRadioButton("Driver");
        rdbtnDriver.setBounds(133, 59, 68, 23);
        buttonGroup.add(rdbtnDriver);
        LoginScreen.add(rdbtnDriver);

        JRadioButton rdbtnAdmin = new JRadioButton("Admin");
        rdbtnAdmin.setBounds(246, 59, 68, 23);
        buttonGroup.add(rdbtnAdmin);
        LoginScreen.add(rdbtnAdmin);

        JLabel lblUsername = new JLabel("Username");
        lblUsername.setBounds(60, 91, 68, 14);
        LoginScreen.add(lblUsername);

        usernameField1 = new JTextField();
        usernameField1.setBounds(133, 88, 108, 20);
        LoginScreen.add(usernameField1);
        usernameField1.setColumns(10);

        JButton btnLogin = new JButton("Login");
        btnLogin.setBounds(246, 87, 68, 23);
        btnLogin.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                String uname = usernameField1.getText();
                String pword = String.valueOf(passwordField1.getPassword());
                DBConnect userauth = null;
                String useroption = getSelectedButtonText(buttonGroup);
                String usertype = null;

                try {
                    userauth = new DBConnect();
                    usertype = userauth.logIn(uname, pword);
                System.out.println("Userauth is : " +useroption+ " While Selected Usertype is: "+usertype);

                } catch (SQLException e1) {
                    e1.printStackTrace();
                } if (useroption.equals(usertype) ) {
                    if (useroption == "Driver") {
                        ManifestScreen.setVisible(true);
                        LoginScreen.setVisible(false);
                    } else
                        if (useroption == "Admin") {
                            AdminScreen.setVisible(true);
                            LoginScreen.setVisible(false);
                    }
                }
            }
        });
        LoginScreen.add(btnLogin);

        JLabel lblPassword = new JLabel("Password");
        lblPassword.setBounds(60, 119, 68, 14);
        LoginScreen.add(lblPassword);

        passwordField1 = new JPasswordField();
        passwordField1.setBounds(133, 116, 108, 20);
        LoginScreen.add(passwordField1);

        JButton btnClear = new JButton("Clear");
        btnClear.setBounds(246, 115, 68, 23);
        btnClear.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                passwordField1.setText(null);
                usernameField1.setText(null);
            }
        });
        LoginScreen.add(btnClear);

        JButton userCreate = new JButton("Create Driver");
        userCreate.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                AdminScreen.setVisible(false);
                createDriver.setVisible(true);
            }
        });
        userCreate.setBounds(10, 11, 150, 37);
        AdminScreen.add(userCreate);

        JButton deleteUser = new JButton("Delete Driver");
        deleteUser.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                deleteDriver.setVisible(true);
                AdminScreen.setVisible(false);
            }
        });
        deleteUser.setBounds(10, 59, 150, 37);
        AdminScreen.add(deleteUser);

        JButton createOrder = new JButton("Add Order");
        createOrder.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                addOrders.setVisible(true);
                AdminScreen.setVisible(false);
            }
        });
        createOrder.setBounds(249, 11, 150, 37);
        AdminScreen.add(createOrder);

        JButton deleteOrder = new JButton("Delete Order");
        deleteOrder.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                deleteOrders.setVisible(true);
                AdminScreen.setVisible(false);
            }
        });
        deleteOrder.setBounds(249, 59, 150, 37);
        AdminScreen.add(deleteOrder);

        JButton getDetails = new JButton("Driver Details");
        getDetails.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                driverDetails.setVisible(true);
                AdminScreen.setVisible(false);
            }
        });
        getDetails.setBounds(10, 107, 150, 37);
        AdminScreen.add(getDetails);

        JButton orderDetails = new JButton("Order Details");
        orderDetails.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                viewOrder.setVisible(true);
                AdminScreen.setVisible(false);

            }
        });
        orderDetails.setBounds(249, 107, 150, 37);
        AdminScreen.add(orderDetails);

        JButton adminLogOff = new JButton("Log off");
        adminLogOff.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                AdminScreen.setVisible(false);
                LoginScreen.setVisible(true);
            }
        });
        adminLogOff.setBounds(315, 213, 109, 37);
        AdminScreen.add(adminLogOff);

        JLabel lblNewLabel = new JLabel("Username");
        lblNewLabel.setBounds(10, 11, 85, 24);
        createDriver.add(lblNewLabel);

        JLabel lblPassword_1 = new JLabel("Password");
        lblPassword_1.setBounds(10, 46, 85, 24);
        createDriver.add(lblPassword_1);

        JLabel lblName = new JLabel("Name");
        lblName.setBounds(10, 81, 85, 24);
        createDriver.add(lblName);

        JLabel lblEmail = new JLabel("E-mail");
        lblEmail.setBounds(10, 116, 85, 24);
        createDriver.add(lblEmail);

        JLabel lblUserAuth = new JLabel("User Auth");
        lblUserAuth.setBounds(10, 151, 85, 24);
        createDriver.add(lblUserAuth);

        userField = new JTextField();
        userField.setBounds(105, 13, 155, 20);
        createDriver.add(userField);
        userField.setColumns(10);

        pwField = new JTextField();
        pwField.setBounds(105, 48, 155, 20);
        createDriver.add(pwField);
        pwField.setColumns(10);

        nameField = new JTextField();
        nameField.setBounds(105, 83, 155, 20);
        createDriver.add(nameField);
        nameField.setColumns(10);

        emailField = new JTextField();
        emailField.setBounds(105, 118, 155, 20);
        createDriver.add(emailField);
        emailField.setColumns(10);

        String[] options = {"Driver", "Admin"};
        DefaultComboBoxModel<String> comboModel = new DefaultComboBoxModel<String>(options);
        JComboBox<String> comboBox = new JComboBox<String>(comboModel);
        comboBox.setMaximumRowCount(2);
        comboBox.setBounds(105, 153, 155, 20);
        comboBox.setSelectedIndex(0);
        createDriver.add(comboBox);

        JButton btnSubmit = new JButton("Submit");
        btnSubmit.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                DBConnect insert = null;

                String username = userField.getText();
                String pw = pwField.getText();
                String name = nameField.getText();
                String email = emailField.getText();
                String userauth = comboBox.getSelectedItem().toString();

                try {
                    insert = new DBConnect();
                    insert = insert.createDriver(username, pw, name, email, userauth);


                } catch (Exception e1) {
                       System.err.println(e1.getMessage());
                       }

            }

        });
        btnSubmit.setBounds(15, 193, 80, 37);
        createDriver.add(btnSubmit);

        JButton btnClear_1 = new JButton("Clear");
        btnClear_1.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                userField.setText(null);
                pwField.setText(null);
                nameField.setText(null);
                emailField.setText(null);
            }
        });
        btnClear_1.setBounds(105, 193, 80, 37);
        createDriver.add(btnClear_1);

        JButton btnBack = new JButton("Back");
        btnBack.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                createDriver.setVisible(false);
                AdminScreen.setVisible(true);

            }
        });
        btnBack.setBounds(195, 193, 80, 37);
        createDriver.add(btnBack);

        JLabel lblUserId = new JLabel("User ID");
        lblUserId.setBounds(10, 11, 85, 24);
        deleteDriver.add(lblUserId);

        JLabel lblUsername_1 = new JLabel("Username");
        lblUsername_1.setBounds(10, 46, 85, 24);
        deleteDriver.add(lblUsername_1);

        JLabel lblPassword_2 = new JLabel("Password");
        lblPassword_2.setBounds(10, 81, 85, 24);
        deleteDriver.add(lblPassword_2);

        userID = new JTextField();
        userID.setBounds(105, 13, 120, 20);
        deleteDriver.add(userID);
        userID.setColumns(10);

        userName = new JTextField();
        userName.setColumns(10);
        userName.setBounds(105, 48, 120, 20);
        deleteDriver.add(userName);

        passWord = new JTextField();
        passWord.setColumns(10);
        passWord.setBounds(105, 83, 120, 20);
        deleteDriver.add(passWord);

        JButton btnDeleteUser = new JButton("Submit");
        btnDeleteUser.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                DBConnect delete = null;
                String userid = userID.getText();
                String username = userName.getText();
                String password = passWord.getText();

                try {
                    delete = new DBConnect();
                    delete = delete.deleteDriver(userid, username, password);
                } catch (Exception e1) {
                       System.err.println(e1.getMessage());
                }
            }
        });


        btnDeleteUser.setBounds(10, 211, 89, 39);
        deleteDriver.add(btnDeleteUser);

        JButton btnClear_2 = new JButton("Clear");
        btnClear_2.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                userID.setText(null);
                userName.setText(null);
                passWord.setText(null);
            }
        });
        btnClear_2.setBounds(109, 211, 89, 39);
        deleteDriver.add(btnClear_2);

        JButton btnBack_1 = new JButton("Back");
        btnBack_1.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                deleteDriver.setVisible(false);
                AdminScreen.setVisible(true);

            }
        });
        btnBack_1.setBounds(208, 211, 89, 39);
        deleteDriver.add(btnBack_1);


    }

    public String getSelectedButtonText(ButtonGroup buttonGroup) {
        for (Enumeration<AbstractButton> buttons = buttonGroup.getElements(); buttons.hasMoreElements();) {
            AbstractButton button = buttons.nextElement();

            if (button.isSelected()) {
                return button.getText();
            }
        }

        return null;
    }
}