public List <CWRTrait> GetCWRTraits(int cwrMapId) { const string COMMAND_TEXT = "usp_TaxonomyCwrTraits_Select"; List <CWRTrait> cwrTraits = new List <CWRTrait>(); CWRTrait cwrTrait = new CWRTrait(); try { using (SqlConnection cn = DataContext.GetConnection(this.GetConnectionStringKey(_context))) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = COMMAND_TEXT; cmd.Parameters.AddWithValue("@taxonomy_cwr_map_id", cwrMapId); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { cwrTrait.ID = GetInt(reader["taxonomy_cwr_trait_id"].ToString()); cwrTrait.CWRMapID = GetInt(reader["taxonomy_cwr_map_id"].ToString()); cwrTrait.CropForCWRID = GetInt(reader["taxonomy_cwr_crop_id"].ToString()); //cwrTrait.CropForCWRName = reader["cwr_crop_name"].ToString(); cwrTrait.SpeciesID = GetInt(reader["taxonomy_species_id"].ToString()); //cwrTrait.SpeciesName = reader["species_name"].ToString(); cwrTrait.TraitClassCode = reader["trait_class_code"].ToString(); cwrTrait.TraitClassTitle = reader["trait_class_title"].ToString(); cwrTrait.IsPotential = ParseBool(reader["is_potential"].ToString()); cwrTrait.BreedingTypeCode = reader["breeding_type_code"].ToString(); cwrTrait.BreedingTypeTitle = reader["breeding_type_title"].ToString(); cwrTrait.BreedingUsageNote = reader["breeding_usage_note"].ToString(); cwrTrait.OntologyTraitIdentifier = reader["ontology_trait_identifier"].ToString(); cwrTrait.CitationID = GetInt(reader["citation_id"].ToString()); if (reader["note"] != DBNull.Value) { cwrTrait.Note = reader["note"].ToString(); } cwrTrait.CreatedDate = GetDate(reader["created_date"].ToString()); cwrTrait.CreatedByCooperatorID = GetInt(reader["created_by"].ToString()); cwrTrait.CreatedByCooperatorName = reader["created_by_name"].ToString(); cwrTrait.ModifiedDate = GetDate(reader["modified_date"].ToString()); cwrTrait.ModifiedByCooperatorID = GetInt(reader["modified_by"].ToString()); cwrTrait.ModifiedByCooperatorName = reader["modified_by_name"].ToString(); cwrTraits.Add(cwrTrait); } } } } } catch (Exception ex) { throw ex; } return(cwrTraits); }
public ResultContainer DeleteCWRTrait(CWRTrait cwrTrait) { return(_cwrTraitDAO.Remove(cwrTrait)); }
public ResultContainer UpdateCWRTrait(CWRTrait cropTrait) { return(_cwrTraitDAO.Update(cropTrait)); }
public ResultContainer AddCropTrait(CWRTrait cwrTrait) { return(_cwrTraitDAO.Add(cwrTrait)); }