package com.idega.block.trade.data;

import java.rmi.RemoteException;
import java.util.Iterator;
import javax.ejb.FinderException;
import java.util.Collection;
import com.idega.data.*;
import java.sql.SQLException;


/**
 * Title:        IW Trade
 * Description:
 * Copyright:    Copyright (c) 2001
 * Company:      idega.is
 * @author 2000 - idega team - <br><a href="mailto:gummi@idega.is">Gu�mundur �g�st S�mundsson</a><br><a href="mailto:gimmi@idega.is">Gr�mur J�nsson</a>
 * @version 1.0
 */

public class CurrencyBMPBean extends com.idega.data.GenericEntity implements Currency{

  public CurrencyBMPBean() {
  }

  public CurrencyBMPBean(int id) throws SQLException{
    super(id);
  }

  public void initializeAttributes() {
    this.addAttribute(getIDColumnName());
    this.addAttribute(getColumnNameCurrencyName(),"Nafn",true,true,String.class,255);
    this.addAttribute(getColumnNameCurrencyAbbreviation(),"Skammst�fun",true,true,String.class,20);

  }

  public String getEntityName() {
    return "TR_CURRENCY";
  }

  public String getName() {
    return getCurrencyName();
  }

  public String getCurrencyName() {
    return getStringColumnValue(getColumnNameCurrencyName());
  }

  public String getCurrencyAbbreviation() {
    return getStringColumnValue(getColumnNameCurrencyAbbreviation());
  }

  public void setCurrencyName(String name) {
    setColumn(getColumnNameCurrencyName(), name);
  }

  public void setCurrencyAbbreviation(String abbreviation) {
    setColumn(getColumnNameCurrencyAbbreviation(), abbreviation);
  }

  public Collection ejbHomeGetCurrenciesByAbbreviation(String currencyAbbreviation) throws FinderException{
    return this.idoFindAllIDsByColumnBySQL(getColumnNameCurrencyAbbreviation(), currencyAbbreviation);
  }

  public Currency ejbHomeGetCurrencyByAbbreviation(String currencyAbbreviation) throws FinderException, RemoteException {
    //Collection coll = this.idoFindAllIDsByColumnOrderedBySQL(getColumnNameCurrencyAbbreviation(), currencyAbbreviation, getColumnNameCurrencyAbbreviation() + " desc");
    Collection coll = ejbHomeGetCurrenciesByAbbreviation(currencyAbbreviation);
    Iterator iter = coll.iterator();
    if (iter.hasNext()) {
      return getHome().findByPrimaryKey(iter.next());
    }
    return null;
  }

  private CurrencyHome getHome() throws RemoteException{
    return (CurrencyHome) IDOLookup.getHome(Currency.class);
  }

  public static String getColumnNameCurrencyID(){return "TR_CURRENCY_ID";}
  public static String getColumnNameCurrencyName(){return"CURRENCY_NAME";}
  public static String getColumnNameCurrencyAbbreviation(){return"CURRENCY_ABBREVIATION";}

  public Collection ejbFindAll() throws FinderException {
	return this.idoFindAllIDsBySQL();  
  }
  
}