package ejb;

import java.util.ArrayList;
import java.util.List;
import javax.ejb.EJB;
import javax.ejb.Remove;
import javax.ejb.Stateless;
import javax.persistence.*;

@Stateless
public class LibMemberManagerBean implements LibMemberManagerBeanRemote {
    @PersistenceContext
    private EntityManager em;


    public LibMemberManagerBean() {
    }

    @Override
    public String createMember(String username, String password,
            String contact, String email, String address, String password2) {
        LibMemberEntity m =  new LibMemberEntity();
        LibMemberEntity mn = em.find(LibMemberEntity.class, username);
        if(mn != null){
            return "Duplicate username.";
        } else if(!password.equals(password2)){
            return "Password mismatch";
        }
        m.create(username, password, contact, email, address);
        em.persist(m);
        return "Member added successfully";
    }

    @Override
    public String deleteMember(String username){
        LibMemberEntity member;
        member = em.find(LibMemberEntity.class, username);
        if(member==null){
            return "Member " +username+" not found";
        } else {
            em.remove(member);
            return "Member " +username+ "deleted successfully";
        }


    }

    @Override
    public Boolean checkUser(String username, String password){

        Query q = em.createQuery("SELECT l FROM LibMember l WHERE l.username='"+username+"' AND l.password='"+password+"'");
        List list = q.getResultList();

        if(list.size()==0)
            return false;

        return true;
    }

    @Override
    public String updateMember(String username, String password, String contact,
            String email, String address, String newPass1, String newPass2){

        LibMemberEntity lm = em.find(LibMemberEntity.class, username);
        String pass = lm.getPassword();
        if(!newPass1.equals(newPass2) && !password.equals(newPass1) && !password.equals(pass) && !password.isEmpty())
            return "Password Mismatch";

        lm.setUserName(username);
        lm.setPassword(password);
        lm.setContact(contact);
        lm.setEmail(email);
        lm.setAddress(address);

        return "User profile successfully updated!";
    }

    @Override
    public ArrayList getDetails(String username){
        ArrayList al = new ArrayList();
        LibMemberEntity lm = em.find(LibMemberEntity.class, username);

        al.add(username);
        al.add(lm.getPassword());
        al.add(lm.getContact());
        al.add(lm.getEmail());
        al.add(lm.getAddress());
        return al;
    }


    @Remove
    public void remove() {
        System.out.println("LibMemberManagerBean:remove()");
    }
}