@Override
    public boolean login(String username, String password) {

        try {
            Class.forName(JDBC_DRIVER);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        try(Connection conn = DriverManager.getConnection(DB_URL, USER, PASS)) {
            String sql = "SELECT Username, Password FROM user" +
                    "WHERE Username = '" + username + "' and password = '" + password + "';";

            PreparedStatement stmt = conn.prepareStatement(sql);

            ResultSet rs = stmt.executeQuery(sql);
            if (!rs.next()) {
                return false;
            }
            /*String userRole = rs.getString("User_Role");

            if(userRole.equals("ADMIN")) {
                return true;
            } else if (userRole.equals("CLIENT")) {
                return false;
            }*/
            return true;
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return false;
    }

    @Override
    public boolean register(String username, String password) {

        try {
            Class.forName(JDBC_DRIVER);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        try(Connection conn = DriverManager.getConnection(DB_URL, USER, PASS)) {
            String sql = "INSERT INTO user (username, password, User_Role)" +
                    "VALUES (?, ?, ?)";

            PreparedStatement stmt = conn.prepareStatement(sql);

            stmt.setString(1, username);
            stmt.setString(2, password);
            stmt.setString(3, UserRole.CLIENT.toString());

            stmt.execute();

            return true;
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return false;
    }


     public void register(String username, String password) {
        try {
            URL wsdlURL = new URL("http://localhost:8888/ws/admin?wsdl");
            QName qname = new QName("http://impl/", "AdminServiceImplService");

            Service service = Service.create(wsdlURL, qname);

            AdminService adminService = service.getPort(AdminService.class);

            if(adminService.register(username, password)) {
                mainFrameView.displaySuccessfulMessage();
            } else {
                mainFrameView.displayAccountNotCreatedMessage();
            }
        } catch (MalformedURLException e1) {
            e1.printStackTrace();
        }
    }

    public void login(String username, String password) {
        try {
            URL wsdlURL = new URL("http://localhost:8888/ws/admin?wsdl");
            QName qname = new QName("http://impl/", "AdminServiceImplService");

            Service service = Service.create(wsdlURL, qname);

            AdminService adminService = service.getPort(AdminService.class);

            if(adminService.login(username, password)) {
                mainFrameView.displayMainAdminView();
            } else {
                mainFrameView.displayInvalidAccountMessage();
            }
        } catch (MalformedURLException e1) {
            e1.printStackTrace();
        }
    }