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 setEntitiesCovered(Entity_Collection in_EntitiesCovered)
{
entitiesCovered = in_EntitiesCovered;
this.loadCtrl();
}
private void setupEntityListBox()
{
entities = coverage.getEntitiesCovered();
for(int k=0; k< entities.Count; k++)
{ entityListBx.Items.Add( ((EntityBO) entities.getEntityAt(k)).Name ); }
// Set Selected
for(int k=0; k<entityListBx.Items.Count; k++)
{
for(int e=0; e<rateSchedule.Coverage.Entities.Count; e++)
{
if (Convert.ToString(entityListBx.Items[k]) == ((EntityBO) rateSchedule.Coverage.Entities.getEntityAt(e)).Name)
{ entityListBx.SetSelected(k, true); }
}
}
}
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;
}