package com.isi.tpjava2jpjm.model.managers;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.isi.tpjava2jpjm.model.entities.Client;
import com.isi.tpjava2jpjm.model.services.ConnecteurBD;

public class ClientManager {
    ConnecteurBD cbd;

    public ClientManager(ConnecteurBD cbd) {
        this.cbd = cbd;
    }

    public Client getClientByEmailPW(String email, String pw) {
        Client c = new Client();
        PreparedStatement ps = cbd.getPreparedStatement("SELECT * FROM clients WHERE courrielClient=? AND passwordClient=?");
        try {
            ps.setString(1, email);
            ps.setString(2, pw);
        } catch (SQLException e1) {
            // TODO Auto-generated catch block
            e1.printStackTrace();
        }

        ResultSet rs = null;
        try {
            rs = ps.executeQuery();
            if (rs.next()) {
                c.setCourrielClient(rs.getString("courrielClient"));
                c.setNoClient(rs.getString("noClient"));
                c.setTelClient(rs.getString("telephoneClient"));
                c.setNoCarteCreditClient(rs.getString("noCarteCredit"));
                c.setVilleClient(rs.getString("villeClient"));
                c.setRueClient(rs.getString("rueClient"));
                c.setPrenomClient(rs.getString("prenomClient"));
                c.setNomClient(rs.getString("nomClient"));
                }
            else {
                c = null;
            }

        }
             catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                finally{
                    try {
                        rs.close();
                        ps.close();
                        cbd.fermerConnection();

                    } catch (SQLException e) {
                        // TODO Auto-generated catch block
                        e.printStackTrace();
                    }

                }

            return c;
            }
}