package ditFreshFrames;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.SwingConstants;

import com.mysql.jdbc.UpdatableResultSet;

import java.awt.Color;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.awt.BorderLayout;

public class TestCustomer {

	private JDialog frame;
	private JTextField username;
	private JTextField passwordSpace;
	private JTextField address;
	private JTextField phoneNumber;
	private JTextField email;

	private static final String url = "jdbc:mysql://leia.skip.chalmers.se:3306/team_08?autoReconnect=true&useSSL=false";
	private static final String user = "team_08";
	private static final String password = "team_08123!";
	public static Connection con = null;

	public static Connection connector() {
		if (con == null) {
			try {
				con = DriverManager.getConnection(url, user, password);
				JOptionPane.showMessageDialog(null, "Connection Successful!");
			} catch (SQLException ex) {
				JOptionPane.showMessageDialog(null, "Connection Unsuccessful.");
				System.err.println("Got an exception!");
				ex.printStackTrace();
			}
		}
			return con;
	}

	public static void main(String[] args) {
		connector();
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					TestCustomer window = new TestCustomer();
					window.frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

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

	/**
	 * Initialize the contents of the frame.
	 */
	private void initialize() {
		frame = new JDialog();
		frame.setResizable(false);
		frame.setBounds(100, 100,470 , 300);
		frame.getContentPane().setLayout(null);

		username = new JTextField();
		username.setEditable(false);
		username.setBounds(96, 77, 257, 26);
		frame.getContentPane().add(username);
		username.setColumns(10);

		passwordSpace = new JTextField();
		passwordSpace.setEditable(false);
		passwordSpace.setBounds(96, 102, 257, 26);
		frame.getContentPane().add(passwordSpace);
		passwordSpace.setColumns(10);

		address = new JTextField();
		address.setEditable(false);
		address.setBounds(96, 126, 257, 26);
		frame.getContentPane().add(address);
		address.setColumns(10);

		phoneNumber = new JTextField();
		phoneNumber.setEditable(false);
		phoneNumber.setBounds(96, 152, 257, 26);
		frame.getContentPane().add(phoneNumber);
		phoneNumber.setColumns(10);

		email = new JTextField();
		email.setEditable(false);
		email.setBounds(96, 179, 257, 26);
		frame.getContentPane().add(email);
		email.setColumns(10);

		JButton btnAdd = new JButton("Update");
		btnAdd.setEnabled(false);
		btnAdd.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent e) {
				try {
					String query = "INSERT INTO `Customer` (`Username`, `Password`, `Address`, `Phone#`, `ID`, `Email`) VALUES (?, ?, ?, ?, NULL, ?)";
					PreparedStatement pst = con.prepareStatement(query);

					pst.setString(1, username.getText());
					pst.setString(2, passwordSpace.getText());
					pst.setString(3, address.getText());
					pst.setString(4, phoneNumber.getText());
					pst.setString(5, email.getText());
					pst.executeUpdate();
				} catch (Exception ex) {
					ex.printStackTrace();
				}
			}
		});




		btnAdd.setBounds(225, 229, 117, 29);
		frame.getContentPane().add(btnAdd);

		JLabel lblUsername = new JLabel("Username:");
		lblUsername.setBounds(6, 82, 78, 16);

		frame.getContentPane().add(lblUsername);

		JLabel lblAddress = new JLabel("Address:");
		lblAddress.setBounds(6, 131, 78, 16);
		frame.getContentPane().add(lblAddress);

		JLabel lblPassword = new JLabel("Password:");
		lblPassword.setBounds(6, 107, 78, 16);
		frame.getContentPane().add(lblPassword);

		JLabel lblPhoneNo = new JLabel("Phone No.:");
		lblPhoneNo.setBounds(6, 157, 78, 16);
		frame.getContentPane().add(lblPhoneNo);

		JLabel lblEmail = new JLabel("Email:");
		lblEmail.setBounds(6, 184, 78, 16);
		frame.getContentPane().add(lblEmail);

		JLabel lblNewLabel_1 = new JLabel(" Profile Details");
		lblNewLabel_1.setForeground(Color.BLACK);
		lblNewLabel_1.setHorizontalAlignment(SwingConstants.CENTER);
		lblNewLabel_1.setBounds(6, 6, 104, 59);
		frame.getContentPane().add(lblNewLabel_1);

		JButton btnEdit = new JButton("Edit");
		btnEdit.addActionListener(new ActionListener() {

			@Override
			public void actionPerformed(ActionEvent e) {

				btnEdit.setEnabled(false);
				passwordSpace.setEditable(true);
				address.setEditable(true);
				phoneNumber.setEditable(true);
				email.setEditable(true);
				btnAdd.setEnabled(true);
			}

		});
		btnEdit.setBounds(333, 229, 117, 29);
		frame.getContentPane().add(btnEdit);
		  frame.setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE);

	}
}