public User Login(String username, String password) throws NoSuchAlgorithmException
    {
        session.beginTransaction();

        Query q = session.createQuery("FROM User WHERE Username = :un AND Password = :pa");
        q.setParameter("un", username);
        q.setParameter("pa", getSecurePassword(password));

        User user =  (User)q.uniqueResult();

        session.getTransaction().commit();

        return user;
    }

    public RegisterStatus Registry(String username, String password, String email, UserType type)// throws Exception
    {
        RegisterStatus status = RegisterStatus.Success;

        session.beginTransaction();
        Query q;
        Email emailExist = null;
        if(type == UserType.Client)
        {
            q = session.createQuery("FROM Email WHERE email = :e");
            q.setParameter("e", email);
            emailExist = (Email)q.uniqueResult();
        }

        q = session.createQuery("FROM User WHERE Username = :u");
        q.setParameter("u", username);
        User usernameExist = (User)q.uniqueResult();

        session.getTransaction().commit();

        if(emailExist != null && type == UserType.Client)
                return RegisterStatus.EmailExists;

        if(usernameExist != null)
            return RegisterStatus.UsernameExists;

        Email emailObj = new Email();
        emailObj.setEmail(email);

        User userObj = new User();

        if(type == UserType.Client)
            userObj.setID_email(emailObj);

        userObj.setUsername(username);
        userObj.setPassword(getSecurePassword(password));
        userObj.setUserType(type.toString());

        session.beginTransaction();
        session.save(userObj);
        session.getTransaction().commit();

        return RegisterStatus.Success;
    }