/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package fpw.lSimone.classi;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author simon
 */
public class UserFactory {
    private static UserFactory instance;
    private ArrayList<User> userList = new ArrayList<>();

    private UserFactory()
    {
        User user1 = new User();

        User user2 = new User("pippo","paperino","paperpippo","pippopaperino@pipppppo.it","passwordinutile","img/profimgpippopaperino.png",0,1);

        User user3 = new User("donald","trump","parrucchino","imrichbitch@trump.cia","123","img/trumpstar.png",1,2);

        User user4 = new User("sofia","corona","sofi","sofi@gmail.com","ciaoTofi","img/trumpstar.png",1,3);

        userList.add(user1);
        userList.add(user2);
        userList.add(user3);
        userList.add(user4);
    }

    public static UserFactory getInstance()
    {
        if (instance == null)
            instance = new UserFactory();
        return instance;
    }
    public User getUserById(int id)
    {
        try {
            Connection conn = DbManager.getInstance().getDbConnection();
            String sql = "select * from Utente where id = ?";
            User userToReturn = new User();

            PreparedStatement stmt = conn.prepareStatement(sql);

            stmt.setInt(1, id);

            ResultSet set = stmt.executeQuery();

            if (set.next())
            {   userToReturn.setTipo(set.getInt("tipo"));
                userToReturn.setId(set.getInt("id"));
                userToReturn.setName(set.getString("nome"));
                userToReturn.setSurname(set.getString("cognome"));
                userToReturn.seteMail(set.getString("email"));
                userToReturn.setPassword(set.getString("password"));
                userToReturn.setImgProfile(set.getString("urlImagineProfilo"));
                userToReturn.setUserName(set.getString("username"));
            }

            stmt.close();
            conn.close();

            return userToReturn;
        } catch (SQLException ex) {
            Logger.getLogger(UserFactory.class.getName()).log(Level.SEVERE, null, ex);
        }

        return null;
    }
    public User getUserByUserName(String  username_)
    {
        try {
            Connection conn = DbManager.getInstance().getDbConnection();
            String sql = "select * from Utente where username = ?";
            User userToReturn = new User();

            PreparedStatement stmt = conn.prepareStatement(sql);

            stmt.setString(1, username_);

            ResultSet set = stmt.executeQuery();

            if (set.next())
            {   userToReturn.setTipo(set.getInt("tipo"));
                userToReturn.setId(set.getInt("id"));
                userToReturn.setName(set.getString("nome"));
                userToReturn.setSurname(set.getString("cognome"));
                userToReturn.seteMail(set.getString("email"));
                userToReturn.setPassword(set.getString("password"));
                userToReturn.setImgProfile(set.getString("urlImagineProfilo"));
            }

            stmt.close();
            conn.close();

            return userToReturn;
        } catch (SQLException ex) {
            Logger.getLogger(UserFactory.class.getName()).log(Level.SEVERE, null, ex);
        }

        return null;
    }
    public void addUser(User user){
        if(user!=null)
            userList.add(user);
    }
    public boolean login(String userName,String password){
        try {
                Connection conn = DbManager.getInstance().getDbConnection();
                String sql = "select * from Utente where username = ? and "
                        + "password = ?";
                Boolean loggedIn;

                PreparedStatement stmt = conn.prepareStatement(sql);

                stmt.setString(1, userName);
                stmt.setString(2, password);

                ResultSet set = stmt.executeQuery();

                loggedIn = set.next();

                stmt.close();
                conn.close();
                return loggedIn;
            } catch (SQLException ex) {
                Logger.getLogger(UserFactory.class.getName()).log(Level.SEVERE, null, ex);
            }

            return false;
    }

    public void deleteUser(User user){
        if(user!=null)
            userList.remove(user);
    }
}