package at.nisteria.nisteria;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

@Component
public class MandantService {

	@Autowired
	private JdbcTemplate jdbcTemplate;

	public List<Mandant> findAll() {
		return jdbcTemplate.query(
				"SELECT id, name, status, anmerkung, plz, ort, adresse FROM mandanten", (rs, rowNum) -> new Mandant(rs.getInt("id"), rs.getString("name"), rs.getInt("status"), rs.getString("anmerkung"), rs.getString("plz"), rs.getString("ort"), rs.getString("adresse")));
	}

	public void update(Mandant mandant) {
		jdbcTemplate.update(
	            "UPDATE mandanten SET name=?, status=?, anmerkung=?, plz=?, ort=?, adresse=? WHERE id=?",
	            mandant.getName(), mandant.getStatus(), mandant.getAnmerkung(), mandant.getPlz(), mandant.getOrt(), mandant.getAdresse(), mandant.getId());
	}


}