import entities.Employee;
import entities.Project;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;
import javax.persistence.Version;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.math.BigDecimal;
import java.util.List;

public class IncreaseSalaries {
    @SuppressWarnings("unchecked")
    public static void main(String[] args) throws IOException {

        EntityManagerFactory newfac =
                Persistence.createEntityManagerFactory("PersistenceUnit");
        EntityManager koiSiTi = newfac.createEntityManager();


        List<Employee> allEmpl = koiSiTi.createQuery
                ("select e from Employee as e " +
                                "where e.department.name = 'Engineering'" +
                                "or e.department.name= 'Tool Design'" +
                                "or e.department.name = 'Marketing'" +
                                "or e.department.name = 'Information Services'",
                        Employee.class)
                .getResultList();

        koiSiTi.getTransaction().begin();

        allEmpl.forEach(e -> {
            double newd = 1.12;
            e.setSalary(e.getSalary().multiply(BigDecimal.valueOf(newd)));
            koiSiTi.persist(e);
        });

        koiSiTi.getTransaction().commit();


        for(Employee e: allEmpl) {
           System.out.printf("%s %s ($%.2f)",
                    e.getFirstName (),
                    e.getLastName(),
                    e.getSalary());
        }

        koiSiTi.close();
        newfac.close();

    }

}