package rent.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
//import java.sql.Date;




import org.postgresql.Driver;



public class TenantDAO {

	private static TenantDAO instance;
	private Connection connection;

	public TenantDAO()
	{
		try {
			Class.forName("org.postgresql.Driver");
			connection = DriverManager
					.getConnection("jdbc:postgresql://localhost:5432/postgres?currentSchema=orm", "postgres", "admin");
			connection.setSchema("public");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}



	}

	public void createEmployee(String name, String rentedFrom) throws SQLException, ParseException {
//		Connection connection = DriverManager
//				.getConnection("jdbc:postgresql://localhost:5432/postgres?currentSchema=orm", "postgres", "admin");
//		connection.setSchema("public");
		try {
			PreparedStatement prepareStatement = connection
					.prepareStatement("INSERT INTO Tenant(name, rented_from, nickname) VALUES (?,?,?)", PreparedStatement.RETURN_GENERATED_KEYS);
			prepareStatement.setString(1, name);


			SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy");
			Date parsed;

				parsed = format.parse(rentedFrom);
				System.out.println(format.parse(rentedFrom));
				java.sql.Date sql = new java.sql.Date(parsed.getTime());



//				prepareStatement.setDate(2, new java.sql.Date(rentedFrom.getTime()));
			prepareStatement.setDate(2, sql);
			prepareStatement.setString(3, name);

			prepareStatement.executeUpdate();
		} finally {
			connection.close();
		}
	}


	public int update(Tenant tenant) throws SQLException {
//		Connection connection = DriverManager
//				.getConnection("jdbc:postgresql://localhost:5432/postgres?currentSchema=orm", "postgres", "admin");
//		connection.setSchema("public");
		try {
//			set this to include whatvever you need for the table
			PreparedStatement prepareStatement = connection
					.prepareStatement("UPDATE Tenant SET name = ?, rented_from = ? WHERE id = ?");
			prepareStatement.setString(1, tenant.getName());
//			prepareStatement.setDate(2, new java.sql.Date(tenant.getRentedFrom().getTime()));
			prepareStatement.setDate(2, new java.sql.Date(System.currentTimeMillis()));
//			prepareStatement.setInt(3, tenant.getId());
			return prepareStatement.executeUpdate();
		} finally {
			connection.close();
		}
	}


	public String returnID(String name) throws SQLException{

//		change this to include what you need to search&4
	      // if you only need a few columns, specify them by name instead of using "*"
//	      String query = "SELECT nickname FROM Tenant WHERE name = Satan";
		PreparedStatement prepareStatement = connection
				.prepareStatement("SELECT Employee From name WHERE = ?");
		prepareStatement.setString(1, name);

	      // create the java statement
	      Statement st = connection.createStatement();

	      // execute the query, and get a java resultset
	      ResultSet rs = st.executeQuery(name);
          String lastName = rs.getString("nickname");

	      while (rs.next()) {

	            System.out.format("%s\n", lastName);
	      }
	      return lastName;
	}

		  	public String returnBirthDate(String name) throws SQLException{

				PreparedStatement prepareStatement = connection
						.prepareStatement("SELECT Employee From name WHERE = ?");
						      Statement st = connection.createStatement();
			      ResultSet rs = st.executeQuery(name);
		          String lastName = rs.getString("birthDate");

			      while (rs.next()) {

			            System.out.format("%s\n", lastName);
			      }
			      return lastName;
		  	}

		  	public String returnBirthDay(String name) throws SQLException{
				PreparedStatement prepareStatement = connection
						.prepareStatement("SELECT Employee From name WHERE = ?");
			      Statement st = connection.createStatement();
			      ResultSet rs = st.executeQuery(name);
		          String lastName = rs.getString("birthday");

			      while (rs.next()) {

			            System.out.format("%s\n", lastName);
			      }
			      return lastName;
		  	}

		  	public String returnEmail(String name) throws SQLException{

				PreparedStatement prepareStatement = connection
						.prepareStatement("SELECT Employee From name WHERE = ?");
			      Statement st = connection.createStatement();
			      ResultSet rs = st.executeQuery(name);
		          String lastName = rs.getString("email");

			      while (rs.next()) {

			            System.out.format("%s\n", lastName);
			      }
			      return lastName;
		  	}

		  	public String returnRole(String name) throws SQLException{

				PreparedStatement prepareStatement = connection
						.prepareStatement("SELECT Employee From name WHERE = ?");
			      Statement st = connection.createStatement();
			      ResultSet rs = st.executeQuery(name);
		          String lastName = rs.getString("role");

			      while (rs.next()) {

			            System.out.format("%s\n", lastName);
			      }
			      return lastName;

		  	}

		  	public String returnWage(String name) throws SQLException{

				PreparedStatement prepareStatement = connection
						.prepareStatement("SELECT Employee From name WHERE = ?");
			      Statement st = connection.createStatement();
			      ResultSet rs = st.executeQuery(name);
		          String lastName = rs.getString("wage");

			      while (rs.next()) {

			            System.out.format("%s\n", lastName);
			      }
			      return lastName;
		  	}






}