public List <RhizobiumDescriptor> Detail(string hostPlantName) { List <RhizobiumDescriptor> rhizobiumDescriptors = new List <RhizobiumDescriptor>(); try { var results = _dataContext.LP_RHIZOBIUM_GET_DETAIL(hostPlantName); foreach (var result in results) { RhizobiumDescriptor rhizobiumDescriptor = new RhizobiumDescriptor(); rhizobiumDescriptor.RhyID = result.rhy_id; rhizobiumDescriptor.Identifier = result.identifier; rhizobiumDescriptor.USDAAccession = result.usda_acces; rhizobiumDescriptor.Synonym1 = result.synonym_1; rhizobiumDescriptor.Synonym2 = result.synonym_2; rhizobiumDescriptor.Synonym3 = result.synonym_3; rhizobiumDescriptor.Synonym4 = result.synonym_4; rhizobiumDescriptor.HostPlant = result.host_plant; rhizobiumDescriptor.CommonName = result.common_nam; rhizobiumDescriptor.Source = result.source; rhizobiumDescriptor.GeoSource = result.geo_source; rhizobiumDescriptor.SeroGroup = result.serogroup; rhizobiumDescriptor.HostsNodu = result.hosts_nodu; rhizobiumDescriptor.Comments = result.comments; rhizobiumDescriptor.GenusSPP = result.genus_spp; rhizobiumDescriptors.Add(rhizobiumDescriptor); } } catch (Exception ex) { } return(rhizobiumDescriptors); }
public List <RhizobiumDescriptor> Search(string searchString) { List <RhizobiumDescriptor> rhizobiumDescriptorList = new List <RhizobiumDescriptor>(); try { var results = this._dataContext.LP_RHIZOBIUM_SEARCH(searchString).ToList(); if (results != null) { if (results.Count() > 0) { rhizobiumDescriptorList = new List <RhizobiumDescriptor>(); foreach (var result in results) { RhizobiumDescriptor rhizobiumDescriptor = new RhizobiumDescriptor(); rhizobiumDescriptor.RhyID = result.rhy_id; rhizobiumDescriptor.Identifier = result.identifier; rhizobiumDescriptor.USDAAccession = result.usda_acces; rhizobiumDescriptor.Synonym1 = result.synonym_1; rhizobiumDescriptor.Synonym2 = result.synonym_2; rhizobiumDescriptor.Synonym3 = result.synonym_3; rhizobiumDescriptor.Synonym4 = result.synonym_4; rhizobiumDescriptor.HostPlant = result.host_plant; rhizobiumDescriptor.CommonName = result.common_nam; rhizobiumDescriptor.Source = result.source; rhizobiumDescriptor.GeoSource = result.geo_source; rhizobiumDescriptor.SeroGroup = result.serogroup; rhizobiumDescriptor.HostsNodu = result.hosts_nodu; rhizobiumDescriptor.Comments = result.comments; rhizobiumDescriptor.GenusSPP = result.genus_spp; rhizobiumDescriptorList.Add(rhizobiumDescriptor); } } } } catch (Exception ex) { throw ex; } return(rhizobiumDescriptorList); }