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; }