package application;

import java.awt.List;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.HashMap;

public class Server {

	private ArrayList<Routes> contents = new ArrayList<Routes>();
	private HashMap<Integer, String> cities = new HashMap<Integer, String>();
	private Connection conn;
	private Statement st;
	private ResultSet rs;
	private String username;
	private String query;

	public Server() {

		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager.getConnection(
					"jdbc:mysql://localhost/bussons buss ab", "root", "");
			st = conn.createStatement();
			updateCities();
		} catch (Exception e) {
			System.out.println(e.toString());
		}

	}

	public void searchToDatabase(String from, String to) {
		// QUERY THAT GETS MATCHING RESULTS OF THE FROM AND TO.
		getSearchResult();
	}

	// public void actionPerformed(ActionEvent e) {
	// String from, to;
	// from = textfield1.getText();
	// to = textfield2.getText();
	// if (e.getSource() == btnSearch) {
	// searchToDatabase(from, to);
	// }

	// }

	public ArrayList getSearchResult() {
		contents.clear();
		int ID, price;
		String departure, arrival;
		double departureTime, arrivalTime;

		try {
			while (rs.next()) {
				ID = rs.getInt("ID");
				price = rs.getInt("Price");
				departure = cities.get(rs.getString("POD"));
				arrival = cities.get(rs.getString("POA"));
				departureTime = rs.getDouble("Departure");
				arrivalTime = rs.getDouble("Arrival");

				contents.add(new Routes(ID, price, departure, arrival,
						departureTime, arrivalTime));

			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		return contents;

	}

	public boolean login(String username, String password) throws SQLException {
		this.username = username;
		query = "SELECT * FROM customers WHERE username = " + username
				+ " AND " + "password = " + password + ";";

		return st.execute(query);

	}

	public boolean requestBooking(String ID){
		 query = "SELECT SSN FROM customer WHERE username = " + username + ";";
		 st.executeQuery(query);
		 rs.getNString("")


	query = "Insert into booking values(" + bookingReference + ", " +  + ", " + "" +  ID
	}	public String registerUser(String SSN, String username, String password,
			String name, String address, String email) {
		String query = "INSERT INTO customer values(" + SSN + "," + username
				+ "," + password + "," + name + "," + address + "," + email
				+ ");";
		try {
			rs = st.executeQuery(query);
		} catch (SQLException e) {
			return "Fel vid tillägg av användare";
		}
		return "Användare tillagd i databasen";

	}

	public void updateCities() {
		query = "SELECT ID, City FROM locations;";
		try {
			st.executeQuery(query);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		try {
			while (rs.next()) {
				cities.put(rs.getInt("ID"), rs.getString("City"));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

}

// String placeOfDeparture, placeOfArrival;
// String query =
// "SELECT * FROM routes join locations on locations.ID = routes.POD & locations.ID = routes.POA WHERE locations.city ="
// + placeOfDeparture & locations.city = placeOfArrival;