public Entity_Collection getEntitiesCovered(int rateScheduleID)
{
SqlDataReader sqlDataRdr = this.GetDataReader("SELECT Entity.EntityCode as EntityCode, CompanyCode, EntityDescr FROM Entity, Entity_RateSched WHERE Entity.EntityCode=Entity_RateSched.EntityCode AND RateSchedSeqNum=" + rateScheduleID);
Entity_Collection entities = new Entity_Collection();
EntityBO entityToAdd;
while(sqlDataRdr.Read())
{
entityToAdd = new EntityBO();
entityToAdd.CompanyCode = sqlDataRdr["CompanyCode"].ToString();
entityToAdd.EntityCode = sqlDataRdr["EntityCode"].ToString();
entityToAdd.Name = sqlDataRdr["EntityDescr"].ToString();
entities.addEntity(entityToAdd);
}
this.CloseConnection();
return entities;
}
public void addEntity(EntityBO entityToAdd)
{
entitiesList.Add(entityToAdd);
}
public Entity_Collection getEntitiesCovered()
{
SqlDataReader sqlDataRdr = this.GetDataReader("SELECT EntityCode, CompanyCode, EntityDescr FROM Entity");
Entity_Collection entities = new Entity_Collection();
EntityBO entityToAdd;
while(sqlDataRdr.Read())
{
entityToAdd = new EntityBO();
entityToAdd.CompanyCode = sqlDataRdr["CompanyCode"].ToString();
entityToAdd.EntityCode = sqlDataRdr["EntityCode"].ToString();
entityToAdd.Name = sqlDataRdr["EntityDescr"].ToString();
entities.addEntity(entityToAdd);
}
this.CloseConnection();
return entities;
}