Exemple #1
0
 public ObservableCollection<Condition> selectAllRelatedCondition()
 {
     if (!isValid())
         return null;
     ObservableCollection<Condition> conditionList = new ObservableCollection<Condition>();
     string sqlCommand = String.Format("select cdID from Condition where pID = {0}", pID);
     Sql sql = new Sql();
     SqlDataReader reader = sql.selectConditionIDByPmID(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;
 }