public int create(Building building) {
String insert =
"INSERT INTO building("
+ "name, "
+ "organization_id, "
+ "email, "
+ "address_1, "
+ "address_2, "
+ "state, "
+ "zip, "
+ "phone, "
+ "total_units, "
+ "created_by, "
+ "created_date)"
+ "VALUES (:name, :organizationId, :email, :address1, :address2, :state, :zip, :phone, :totalUnits,:createdBy, now()) RETURNING id";
MapSqlParameterSource params = new MapSqlParameterSource();
params.addValue("name", building.getName());
params.addValue("organizationId", building.getOrganizationId());
params.addValue("email", building.getEmail());
params.addValue("address1", building.getAddress1());
params.addValue("address2", building.getAddress2());
params.addValue("state", building.getState());
params.addValue("zip", building.getZip());
params.addValue("phone", building.getPhone());
params.addValue("totalUnits", building.getTotalUnits());
params.addValue("createdBy", building.getCreatedBy());
int id = namedParameterJdbcTemplate.queryForObject(insert, params, Integer.class);
return id;
}
