public ObservableCollection<Condition> getAllRelatedCondition()
{
if (!isValid(new List<string>() { "prName", "pID" }))
return null;
ObservableCollection<Condition> conditionList = new ObservableCollection<Condition>();
string sqlCommand = String.Format("select cdID from Condition where prID={0}", prID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectConditionIDByPrID(sqlCommand);
while (reader.Read())
{
int cdID = Int32.Parse(reader[0].ToString());
Condition condition = new Condition();
condition.id = cdID;
condition.select();
conditionList.Add(condition);
}
sql.closeConnection();
return conditionList;
}