コード例 #1
0
        public List <TaxonRank> GetDefaultChildRanks(string parentElemType, string kingdomCode)
        {
            var list = new List <TaxonRank>();

            StoredProcReaderForEach("spBiotaDefGetChildren", (reader) => {
                list.Add(TaxonMapper.MapTaxonRank(reader));
            }, _P("vchrRank", parentElemType), _P("vchrKingdom", kingdomCode));
            return(list);
        }
コード例 #2
0
        public List <Taxon> GetTaxaForParent(int taxonId)
        {
            List <Taxon> taxa = new List <Taxon>();

            StoredProcReaderForEach("spBiotaList", (reader) => {
                taxa.Add(TaxonMapper.MapTaxon(reader));
            }, new SqlParameter("intParentId", taxonId));

            return(taxa);
        }
コード例 #3
0
        public List <Taxon> GetTopLevelTaxa()
        {
            List <Taxon> taxa = new List <Taxon>();

            StoredProcReaderForEach("spBiotaListTop", (reader) => {
                taxa.Add(TaxonMapper.MapTaxon(reader));
            });

            return(taxa);
        }
コード例 #4
0
        public List <Taxon> GetExpandFullTree(int taxonId)
        {
            List <Taxon> taxa = new List <Taxon>();

            StoredProcReaderForEach("spBiotaListFullTree", (reader) => {
                taxa.Add(TaxonMapper.MapTaxon(reader, new ConvertingMapper("NumChildren", (elem) => { return(Int32.Parse(elem == null ? "-1" : elem.ToString())); })));
            }, new SqlParameter("intParentId", taxonId));

            return(taxa);
        }
コード例 #5
0
        public List <TaxonSearchResult> FindTaxa(string searchTerm)
        {
            List <TaxonSearchResult> taxa = new List <TaxonSearchResult>();

            searchTerm = EscapeSearchTerm(searchTerm, true); /// * are wildcards, replace them with the SQL wildcard

            StoredProcReaderForEach("spBiotaFind", (reader) => {
                taxa.Add(TaxonMapper.MapTaxonSearchResult(reader));
            }, new SqlParameter("vchrLimitations", ""), new SqlParameter("vchrTaxaToFind", searchTerm));

            return(taxa);
        }
コード例 #6
0
 /// <summary>
 /// The rank list is cached because it rarely, if ever, changes.
 /// </summary>
 /// <returns></returns>
 public List <TaxonRank> GetTaxonRanks()
 {
     lock (_rankLock) {
         if (_rankList == null)
         {
             _rankList = new List <TaxonRank>();
             StoredProcReaderForEach("spBiotaDefRankGetAll", (reader) => {
                 _rankList.Add(TaxonMapper.MapTaxonRank(reader));
             });
         }
     }
     return(_rankList);
 }