package se.idega.idegaweb.commune.account.citizen.data;

import com.idega.data.GenericEntity;
import java.util.Collection;
import javax.ejb.FinderException;

/**
 * Last modified: $Date: 2003/04/02 17:55:51 $ by $Author: laddi $
 *
 * @author <a href="http://www.staffannoteberg.com">Staffan N�teberg</a>
 * @version $Revision: 1.7 $
 */
public class CitizenApplicantChildrenBMPBean extends GenericEntity
    implements CitizenApplicantChildren {
    private static final String ENTITY_NAME = "comm_cit_children";
    //private static final String COLUMN_ID = ENTITY_NAME + "_id";
	private static final String COLUMN_APPLICATION_ID = "application_id";
	private static final String COLUMN_FIRST_NAME = "first_name";
	private static final String COLUMN_LAST_NAME = "last_name";
	private static final String COLUMN_SSN = "ssn";

	public void initializeAttributes() {
		addAttribute (getIDColumnName());
       	addAttribute (COLUMN_APPLICATION_ID, "Application id", true, true,
                      Integer.class, "many-to-one", CitizenAccount.class);
		addAttribute (COLUMN_FIRST_NAME, "First Name", true, true, String.class,
                      40);
		addAttribute (COLUMN_LAST_NAME, "Last Name", true, true, String.class,
                      40);
		addAttribute (COLUMN_SSN, "SSN", true, true, String.class, 40);
	}

	public String getEntityName() {
		return ENTITY_NAME;
	}

    public int getApplicationId () {
        Integer applicationId = null;
        try {
            applicationId = getIntegerColumnValue (COLUMN_APPLICATION_ID);
        } catch (Exception e) {
            // nothing
        }

        return applicationId == null ? -1 : applicationId.intValue ();
    }

    public String getFirstName () {
        return getStringColumnValue (COLUMN_FIRST_NAME);
    }

    public String getLastName () {
        return getStringColumnValue (COLUMN_LAST_NAME);
    }

    public String getSsn () {
        return getStringColumnValue (COLUMN_SSN);
    }


    public void setApplicationId (final int applicationId) {
        setColumn (COLUMN_APPLICATION_ID, applicationId);
    }

    public void setFirstName (final String firstName) {
        setColumn (COLUMN_FIRST_NAME, firstName);
    }

    public void setLastName (final String lastName) {
        setColumn (COLUMN_LAST_NAME, lastName);
    }

    public void setSsn (final String ssn) {
        setColumn (COLUMN_SSN, ssn);
    }


    public Collection ejbFindByApplicationId (final int applicationId)
        throws FinderException {
        final String sql = "select * from " + ENTITY_NAME
                + " where " + COLUMN_APPLICATION_ID + " = " + applicationId;
        return idoFindPKsBySQL (sql);
    }
}