/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.bestray.transtracking.dao.mapper;

import com.bestray.trastrack.domain.Party;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.ResultSetExtractor;

/**
 *
 * @author user3
 */
public class PartyResultSetExtractor implements ResultSetExtractor<Object> {
    
    public Object extractData(ResultSet rs) throws SQLException,DataAccessException{
                   List <Party> partys = new ArrayList<Party>();
        while (rs.next()) {
            Party party = new Party();
          //  Address address = new Address();
            party.setId(rs.getLong("id"));
            party.setPartyname(rs.getString("name"));
            party.setBillingname(rs.getString("billing_name"));
            party.setContactperson(rs.getString("contact_person"));
            party.setPartytype_id(rs.getLong("party_type_id"));
            party.setEmail(rs.getString("email"));
            //party.setCity(rs.getString("city"));
            party.setAddressid(rs.getLong("address_id"));
            party.setContact1(rs.getLong("contact_1"));
            party.setContact2(rs.getLong("contact_2"));
            party.setOpeningbal1(rs.getDouble("opening_balance"));
            party.setOpeningbaltype1(rs.getString("opening_balance_type"));
            //party.setOpeningbal2(rs.getDouble("opening_balance2"));
            //party.setOpeningbaltype2(rs.getString("opening_balance_type2"));
            party.setLock(rs.getString("lock_ind"));
            partys.add(party);
        }
        return partys;
    }
    
}