package com.ibm.dw.spring2;

import java.util.List;

import org.springframework.orm.jpa.support.JpaDaoSupport;



public class EmployeeDAO extends JpaDaoSupport implements EmployeeService {

	public Employee findById(long id) {
		return getJpaTemplate().find(Employee.class, id);
	}
    public List<Employee> findAll() {
    	return getJpaTemplate().find("select e from Employee e order by e.empno");
    }
	public List<Employee> findByEmployeeNumber(String empno) {
		return getJpaTemplate().find("select e from Employee e where e.empno = ?1", empno);
	}

	public List<Employee> findByAddressStreetName(String street) {
		return getJpaTemplate().find("select e from Employee e where e.addr.street = ?1", street);
	}

	public List<Employee> findByEmployeeFirstNameLike(String firstName) {
		return getJpaTemplate().find("select e from Employee e where e.firstName like ?1", firstName);
	}

	public List<Employee> findEmployeeWithSalaryOver(double sal) {
		return getJpaTemplate().find("select e from Employee e where e.salary > ?1", sal);
	}

	public List<Employee> findEmployeeWithCommissionOver(double comm) {
		return getJpaTemplate().find("select e from Employee e where e.commission > ?1", comm);
	}

	public Employee save(Employee emp) {
		getJpaTemplate().persist(emp);
		return emp;
		
	}

	public Employee update(Employee emp) {
		return getJpaTemplate().merge(emp);
	}

	public void delete(Employee emp) {
		getJpaTemplate().remove(emp);
			
	}

	}