# Task

Now let's get to the task:

Your task is to implement the methods in the classes `RoleDaoImpl`, `RoleServiceImpl`, `EmployeeDaoImpl`, and `EmployeeServiceImpl`. This is not difficult; you have done this many times. The only potential challenge might be with the `updateRole` method, but I'm confident you can handle it.

To test your solution, you need to run the code I have written for you in the main class. Then, you will need to compare the result with the correct result, which I will provide below.

Testing such large applications with database interaction implementation becomes increasingly challenging, so now your project will be tested by yourself (or you can peek at the Solution).

Correct output: 

```
[Employee(id=1, name=John, salary=55000.0, hireDate=2021-10-05, department=Department(id=1, name=Marketing, location=Head Office), role=Role(id=1, name=Marketing Specialist, description=A dynamic role focused on developing and implementing strategies to promote brand awareness and drive product sales. Responsibilities include market research, content creation, and campaign management to enhance engagement and achieve business goals.)), Employee(id=2, name=Bob, salary=70000.0, hireDate=2022-02-18, department=Department(id=2, name=Development, location=IT Office), role=Role(id=2, name=Software Engineer, description=A software engineer writes and maintains the code for computer applications and systems.))]
```

<link
        rel="stylesheet"
        href="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.62.3/codemirror.min.css"
/>
<link
        rel="stylesheet"
        href="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.62.3/theme/dracula.min.css"
/>


<link
        rel="stylesheet"
        href="https://codefinity-content-media-v2.s3.eu-west-1.amazonaws.com/courses/c1087363-9025-4c37-8d5e-983a32a007e9/buttons-section/hint-solution-with-copyable-%26%3Dhighlighted-code.css"
/>

<div class="button-container">
    <button
            class="button"
            onclick="toggleBlock6('hint-block6', 'solution-block6')"
    >
        Hint
    </button>
    <button
            class="button"
            onclick="toggleBlock6('solution-block6', 'hint-block6')"
    >
        Solution
    </button>
</div>


<div id="hint-block6" class="block hint-styling-block">
    1. First, you need to implement the methods from the <code>RoleDao</code> interface. You've done this many times before, so there shouldn't be any problems. <br/>
    2. For the method with role update, use the following algorithm: Retrieve the role from the database, reassign the role's fields with new values, and use the <code>session.merge()</code> method.<br/>
    3. To implement the <code>setRoleById()</code> method and override it, you can use the template from the previous chapter. You need to do the same thing. <br/>
    4. Run the main class and compare your result with the expected one.
</div>

<div id="solution-block6" class="block solution-styling-block">
    
    <textarea id="code-6" class="language-java">
// RoleDaoImpl
public class RoleDaoImpl implements RoleDao {
    SessionFactory sessionFactory = HibernateUtil.getSessionFactory();

    @Override
    public Role add(Role role) {
        Session session = null;
        Transaction transaction = null;

        try {
            session = sessionFactory.openSession();
            transaction = session.beginTransaction();

            session.persist(role);
            transaction.commit();
        } catch (Exception e) {
            if (transaction != null) {
                transaction.rollback();
                throw new RuntimeException("Can't add new Role", e);
            }
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return role;
    }

    @Override
    public Role getById(int id) {
        Session session = null;
        Role role = null;

        try {
            session = sessionFactory.openSession();
            role = session.get(Role.class, id);
        } catch (Exception e) {
            throw new NoSuchElementException("Can't get Role by ID " + id, e);
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return role;
    }

    @Override
    public List<Role> getAll() {
        Session session = null;
        List<Role> roles = null;

        try {
            session = sessionFactory.openSession();

            String hql = "FROM Role";
            Query<Role> query = session.createQuery(hql, Role.class);

            roles = query.getResultList();
        } catch (Exception e) {
            throw new NoSuchElementException("Can't get Employees from the DB", e);
        } finally {
            if (session != null) {
                session.close();
            }
        }
        return roles;
    }

    @Override
    public Role updateRole(int id, Role newRole) {
        Session session = null;
        Role role = null;
        Transaction transaction = null;

        if (newRole == null) {
            throw new NullPointerException("The `newRole` is null!");
        }

        try {
            session = sessionFactory.openSession();
            transaction = session.beginTransaction();

            role = getById(id);
            role.setName(newRole.getName());
            role.setDescription(newRole.getDescription());

            session.merge(role);
            transaction.commit();
        } catch (Exception e) {
            if (transaction != null) {
                transaction.rollback();
            }
            throw new HibernateException("Can't update the role");
        }
        return role;
    }
}

//EmployeeDaoImpl
@Override
public Employee setRoleById(int employeeId, int roleId) {
    Employee employee = null;
    Role role = null;
    Session session = null;
    Transaction transaction = null;

    try {
        session = sessionFactory.openSession();
        transaction = session.beginTransaction();

        employee = getById(employeeId);
        role = roleService.getById(roleId);

        employee.setRole(role);
        session.merge(employee);
        transaction.commit();
    } catch (Exception e) {
        if (transaction != null) {
            transaction.rollback();
        }
    } finally {
        if (session != null) {
            session.close();
        }
    }
    return employee;
}

//RoleServiceImpl
public class RoleServiceImpl implements RoleService {
    private final RoleDao roleDao = new RoleDaoImpl();

    @Override
    public Role add(Role role) {
        return roleDao.add(role);
    }

    @Override
    public Role getById(int id) {
        return roleDao.getById(id);
    }

    @Override
    public List<Role> getAll() {
        return roleDao.getAll();
    }

    @Override
    public Role updateRole(int id, Role newRole) {
        return roleDao.updateRole(id, newRole);
    }
}

//EmployeeServiceImpl
@Override
public Employee setRoleById(int employeeId, int roleId) {
    return employeeDao.setRoleById(employeeId, roleId);
}

@Override
public Employee setRoleById(int employeeId, Role role) {
    if (role == null) {
        throw new NullPointerException("The role is null!");
    }

    List<Role> roles = roleService.getAll();

    if (roles.contains(role)) {
        int roleId = role.getId();
        return setRoleById(employeeId, roleId);
    } else {
        throw new NoSuchElementException("No such role found in the database!");
    }
}</textarea>

    <button class="copy-button" onclick="handleClick6('code-6')">
        <svg
                width="20"
                height="20"
                x="0"
                y="0"
                viewBox="0 0 32 32"
                style="enable-background: new 0 0 512 512"
                xml:space="preserve"
                class=""
        >
      <g>
        <path
                d="m26.121 6.707-3.828-3.828A2.98 2.98 0 0 0 20.172 2H12a3.003 3.003 0 0 0-3 3v1H8a3.003 3.003 0 0 0-3 3v18a3.003 3.003 0 0 0 3 3h12a3.003 3.003 0 0 0 3-3v-1h1a3.003 3.003 0 0 0 3-3V8.829a2.982 2.982 0 0 0-.879-2.122ZM22 5.414 23.586 7H22ZM20 28H8a1.001 1.001 0 0 1-1-1V9a1.001 1.001 0 0 1 1-1h8v3a2.002 2.002 0 0 0 2 2h3v14a1 1 0 0 1-1 1ZM18 9.414 19.586 11H18ZM24 24h-1V12.829a2.982 2.982 0 0 0-.879-2.122l-3.828-3.828A2.98 2.98 0 0 0 16.171 6H11V5a1.001 1.001 0 0 1 1-1h8v3a2.002 2.002 0 0 0 2 2h3v14a1 1 0 0 1-1 1Zm-6-8h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Zm0 4h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Zm0 4h-8a1 1 0 0 1 0-2h8a1 1 0 0 1 0 2Z"
                fill="#a6b8e6"
                opacity="1"
                data-original="#000000"
                class=""
        ></path>
      </g>
    </svg>
    </button>
</div>

<script src="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.62.3/codemirror.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/codemirror/5.62.3/mode/clike/clike.min.js"></script>


<script src="https://cdn.jsdelivr.net/npm/notiflix@2.7.0/dist/notiflix-aio-2.7.0.min.js"></script>

<script>
    function onPageLoad6() {
        var editor = CodeMirror.fromTextArea(document.getElementById("code-6"), {
            lineNumbers: true,
            mode: "text/x-java",
            theme: "dracula",
        });

        // ----------> HIGHLIGHT <----------
        editor.markText(
            { line: 0, ch: 0 },
            { line: 0, ch: 0 },
            { className: "specific" }
        );

        editor.markText(
            { line: 0, ch: 0 },
            { line: 0, ch: 0 },
            { className: "specific" }
        );

        editor.markText(
            { line: 0, ch: 0 },
            { line: 0, ch: 0 },
            { className: "specific" }
        );

        editor.markText(
            { line: 0, ch: 0 },
            { line: 0, ch: 0 },
            { className: "specific" }
        );

        editor.markText(
            { line: 0, ch: 0 },
            { line: 0, ch: 0 },
            { className: "specific" }
        );

        // Initially hide both the hint and solution blocks
        hideBlock6("hint-block6");
        hideBlock6("solution-block6");
    }

    // Copy Button handler
    const handleClick6 = (codeBlock) => {
        const textarea = document.getElementById(codeBlock);
        const copiedText = textarea.value;

        navigator.clipboard.writeText(copiedText);

        Notiflix.Notify.Success("Copied to clipboard!", {
            timeout: 2000,
            width: "260px",
            position: "center-top",
            textColor: "#ff5549",
        });
    };

    // Function to toggle the visibility of a block
    const toggleBlock6 = (blockId) => {
        const block = document.getElementById(blockId);

        if (block.style.display === "none" || block.style.display === "") {
            hideBlock6("hint-block6");
            hideBlock6("solution-block6");
            showBlock6(blockId);
        } else {
            hideBlock6(blockId);
        }
    };

    // Function to show a block
    const showBlock6 = (blockId) => {
        const block = document.getElementById(blockId);
        block.style.display = "block";
    };

    // Function to hide a block
    const hideBlock6 = (blockId) => {
        const block = document.getElementById(blockId);
        block.style.display = "none";
    };

    const imgElement6 = document.createElement("img");
    imgElement6.src = "nonexistent-image";
    imgElement6.style.display = "none";
    imgElement6.onerror = onPageLoad6;

    document.body.appendChild(imgElement6);
</script>

Every backend developer must be proficient in working with various databases. Connecting a database to the code and performing data operations directly from Java code to execute SQL queries and various data operations directly from the code. JDBC and Hibernate help developers with this. It's time to learn how to connect a database to your IDE, use tables from this database, and manipulate data!

Why do we need a database? How does the interaction between a database and code work? What tools are used for different types of databases? You will learn all about this in this section!

This section will tell you how to set up and use Hibernate. You will learn how this framework works, what ORM is, and how to work with databases efficiently. You will also learn to write basic operations with a connected database, demonstrating your skills in practice!

In this section, we will complete work on the project's foundation for employee management in the company. We will add the remaining operations and one more entity.

Java Data Manipulation with Hibernate

Challenge: Role Layers Implementation

Task