public HealthSystemSettings HealthSystemSettingsLoadByID(int healthSystemID)
 {
     HealthSystemSettings result = null;
     StoredProcedure proc = new StoredProcedure(SQLResource.HealthSystemSettingsLoadByID, this.ConnectionString);
     proc.Parameters.AddWithValue("@HealthSystemID", healthSystemID);
     DataTable t = proc.ExecuteReader();
     if (t.Rows.Count == 0)
     {
         throw new DataException(String.Format("Unable to find settings for HealthSystemID {0}", healthSystemID));
     }
     result = new HealthSystemSettings(t.Rows[0]);
     return result;
 }
 public HealthSystemModel(HealthSystem system, HealthSystemSettings settings)
 {
     this._HealthSystem = system;
     this._HealthSystemSettings = settings;
 }