public HealthSystem HealthSystemLoadByID(int healthSystemID)
{
HealthSystem result = null;
StoredProcedure proc = new StoredProcedure(SQLResource.GetHealthSystemInformation, this.ConnectionString);
proc.Parameters.AddWithValue("@HealthSystemID", healthSystemID);
DataTable t = proc.ExecuteReader();
if (t.Rows.Count == 0)
{
throw new DataException(String.Format("Could not Get Health System Information for ID {0}", healthSystemID));
}
result = new HealthSystem(t.Rows[0]);
return result;
}
public List<HealthSystem> HealthSystemList()
{
List<HealthSystem> systems = new List<HealthSystem>();
StoredProcedure proc = new StoredProcedure(SQLResource.GetHealthSystemList, ConnectionString);
DataTable t = proc.ExecuteReader();
if (t.Rows.Count == 0)
{
throw new DataException("Could not Get Health System List");
}
foreach (DataRow row in t.Rows)
{
HealthSystem h = new HealthSystem(row);
systems.Add(h);
}
return systems;
}
public HealthSystemModel(HealthSystem system, HealthSystemSettings settings)
{
this._HealthSystem = system;
this._HealthSystemSettings = settings;
}
