/*******************************************************************************
 * Open Behavioral Health Information Technology Architecture (OBHITA.org)
 *
 *   Redistribution and use in source and binary forms, with or without
 *   modification, are permitted provided that the following conditions are met:
 *       * Redistributions of source code must retain the above copyright
 *         notice, this list of conditions and the following disclaimer.
 *       * Redistributions in binary form must reproduce the above copyright
 *         notice, this list of conditions and the following disclaimer in the
 *         documentation and/or other materials provided with the distribution.
 *       * Neither the name of the <organization> nor the
 *         names of its contributors may be used to endorse or promote products
 *         derived from this software without specific prior written permission.
 *
 *   THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
 *   ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
 *   WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 *   DISCLAIMED. IN NO EVENT SHALL <COPYRIGHT HOLDER> BE LIABLE FOR ANY
 *   DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
 *   (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
 *   LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 *   ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 *   (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 *   SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 ******************************************************************************/
package gov.samhsa.consent2share.si;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.support.lob.LobHandler;

/**
 * The Class PolicyIdDtoRowMapper.
 */
public class RevokedConsentDtoRowMapper implements RowMapper<RevokedConsentDto> {

	/** The lob handler. */
	private LobHandler lobHandler;

	public RevokedConsentDtoRowMapper(LobHandler lobHandler) {
		super();
		this.lobHandler = lobHandler;
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see org.springframework.jdbc.core.RowMapper#mapRow(java.sql.ResultSet,
	 * int)
	 */
	@Override
	public RevokedConsentDto mapRow(ResultSet rs, int rowNum)
			throws SQLException {
		long pcmConsentId = rs.getLong("consent.id");
		String policyId = rs.getString("consent.consent_reference_id");
		String patientEid = rs.getString("patient.enterprise_identifier");
		String patientMrn = rs.getString("patient.medical_record_number");
		long pcmPatientId = rs.getLong("consent.patient");
		byte[] revokedPdfConsent = lobHandler
				.getBlobAsBytes(rs,
						"signedpdfconsent_revocation.signed_pdf_consent_revocation_content");

		RevokedConsentDto revokedConsentDto = new RevokedConsentDto();
		revokedConsentDto.setPatientEid(patientEid);
		revokedConsentDto.setPatientMrn(patientMrn);
		revokedConsentDto.setPcmConsentId(pcmConsentId);
		revokedConsentDto.setPcmPatientId(pcmPatientId);
		revokedConsentDto.setRevokedPdfConsent(revokedPdfConsent);
		revokedConsentDto.setXacmlCcdId(policyId);
		return revokedConsentDto;
	}
}