package repository;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

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

import dto.Candidato;
import database.Queries;

@Repository
public class CandidatoRepositoryImpl implements CandidatoRepository {

	@Autowired
	private JdbcTemplate jdbcTemplate;

	static String domicilio, capDomicilio;

	private String capitalize(String stringa) {

		int i = 0;
		String comodo= null, s= null;
		StringBuilder uppercase = null;
		stringa = stringa.trim();
		int n= stringa.length();
		s = stringa.substring(0,1).toUpperCase()+stringa.substring(1,n).toLowerCase();

		for (i = 0; i < s.length(); i++) {

			if (s.charAt(i)==' ' && i < s.length()-1) {
				comodo = s.substring(i+1, i+2).toUpperCase();
				uppercase = new StringBuilder(s);
				uppercase.replace(i+1, i+2,comodo);
				s =	uppercase.toString();
			}
		}
		return s;
	}

	//rivedere ordine in base alla tabella sia qua che in dto
	@Override
	public int addCandidato(Candidato candidatoDto) {

		if(candidatoDto.getDomicilio() == null && candidatoDto.getCapDomicilio() == null) {

			domicilio = candidatoDto.getResidenza();
			capDomicilio = candidatoDto.getCapResidenza();

		}else {

			domicilio = candidatoDto.getDomicilio();
			capDomicilio = candidatoDto.getCapDomicilio();

		}
			return jdbcTemplate.update(Queries.queryInsertCandidato, new Object[] {

					candidatoDto.getCf().toUpperCase(),
					capitalize(candidatoDto.getNome()),
					capitalize(candidatoDto.getCognome()),
					candidatoDto.getEmail(),
					candidatoDto.getDataNascita(),
					capitalize(candidatoDto.getLuogoNascita()),
					candidatoDto.isCittadinanza(),
					capitalize(candidatoDto.getResidenza()),
					candidatoDto.getCapResidenza().toUpperCase(),
					capitalize(domicilio),
					capDomicilio.toUpperCase(),
					candidatoDto.getRecapitoMobile(),
					candidatoDto.getRecapitoFisso(),
					candidatoDto.isCategoriaProtetta()
					});
		}

	@Override
	public int updateCandidato(Candidato candidatoDto, String cfToUpdate) {

		if(candidatoDto.getDomicilio() == null && candidatoDto.getCapDomicilio() == null) {

			domicilio = candidatoDto.getResidenza();
			capDomicilio = candidatoDto.getCapResidenza();

		}else {

			domicilio = candidatoDto.getDomicilio();
			capDomicilio = candidatoDto.getCapDomicilio();

		}

	return jdbcTemplate.update(Queries.updatedCandidato, new Object[] {

			capitalize(candidatoDto.getNome()),
			capitalize(candidatoDto.getCognome()),
			candidatoDto.getEmail(),
			candidatoDto.getDataNascita(),
			capitalize(candidatoDto.getLuogoNascita()),
			candidatoDto.isCittadinanza(),
			capitalize(candidatoDto.getResidenza()),
			candidatoDto.getCapResidenza().toUpperCase(),
			capitalize(domicilio),
			capDomicilio.toUpperCase(),
			candidatoDto.getRecapitoMobile(),
			candidatoDto.getRecapitoFisso(),
			candidatoDto.isCategoriaProtetta(),
			cfToUpdate
	});


	// INNER CLASS, mappatura necessaria per il readStudents
		/*private static final class StudentVoMapper implements RowMapper<StudentVo> {

			public StudentVo mapRow(ResultSet rs, int numRows) throws SQLException {
				StudentVo studentVo = new StudentVo();
				studentVo.setId(rs.getInt("id"));
				studentVo.setName(rs.getString("name"));
				studentVo.setLastname(rs.getString("lastname"));
				studentVo.setEmail(rs.getString("email"));
				studentVo.setPassword(rs.getString("password"));
				return studentVo;
			}*/

	}
}