package sessionBeans;

import javax.ejb.Stateful;
import javax.persistence.EntityManager;
import javax.persistence.NoResultException;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import entities.OperatorsEntity;

@Stateful
public class OperatorsBean implements Operators {

    @PersistenceContext
    private EntityManager entityManager;

    private static Results results;
    private String username, password;

    public OperatorsBean() {
        this.username = "";
        this.password = "";
    }

    public OperatorsBean(String username, String password) {
        this.username = username;
        this.password = password;
    }

    public Results getResults() {
        return results;
    }

    public int login(String username, String password) {
        OperatorsEntity operator = get(username);
        if(operator != null) {
            if(operator.getPassword().equals(password))
                return Results.SUCCESS;
            else
                return Results.INVALID_PASSWORD;
        } else
            return Results.OPERATOR_NOT_FOUND;
    }

    public int logout() {
        this.username = "";
        this.password = "";

        return Results.SUCCESS;
    }

    public int register(String username, String password) {
        OperatorsEntity operator = get(username);
        if(operator == null) {
            entityManager.persist(new OperatorsEntity(username,password));
            return Results.SUCCESS;
        } else
            return Results.OPERATOR_ALREADY_EXISTS;
    }

    public OperatorsEntity get(String username) {
        OperatorsEntity operator = null;
        try {
            Query query = entityManager.createQuery("SELECT * FROM OperatorsEntity oe WHERE oe.username = :username");
            query.setParameter("username", username);
            operator = (OperatorsEntity) query.getSingleResult();
            return operator;
        } catch(NoResultException e) {
            return operator;
        }
    }

    public OperatorsEntity get(int id) {
        OperatorsEntity operator = null;
        try {
            Query query = entityManager.createQuery("SELECT * FROM OperatorsEntity oe WHERE oe.id = :id");
            query.setParameter("id", id);
            operator = (OperatorsEntity) query.getSingleResult();
            return operator;
        } catch(NoResultException e) {
            return operator;
        }
    }

    public int delete(OperatorsEntity operator) {
        try {
            Query query = entityManager.createQuery("DELETE FROM OperatorsEntity oe WHERE oe.id = :id");
            query.setParameter("id", operator.getId());
            query.executeUpdate();
            return Results.SUCCESS;
        } catch (Exception ex) {
            ex.printStackTrace();
            return Results.CANNOT_DELETE_OPERATOR;
        }
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}