public List <SpeciesSim> GetSpeciesList() { List <SpeciesSim> ReturnObject = new List <SpeciesSim>(); SpeciesSim ins; DataBaseConnection dbConn = new DataBaseConnection(); using (var con = dbConn.SqlConn()) { con.Open(); using (SqlCommand cmd = new SqlCommand("exec " + CommonStrings.GetAnimalTypes, con)) { using (var drI = cmd.ExecuteReader()) { while (drI.Read()) { ins = new SpeciesSim(); ins.SpeciesId = Convert.ToInt32(drI["AnimalTypeId"]); ins.SpeciesName = drI["Description"].ToString(); ReturnObject.Add(ins); } } } } return(ReturnObject); }
public List<SpeciesSim> GetSpeciesList() { List<SpeciesSim> ReturnObject = new List<SpeciesSim>(); SpeciesSim ins; DataBaseConnection dbConn = new DataBaseConnection(); using (var con = dbConn.SqlConn()) { con.Open(); using (SqlCommand cmd = new SqlCommand("exec " + CommonStrings.GetAnimalTypes, con)) { using (var drI = cmd.ExecuteReader()) { while (drI.Read()) { ins = new SpeciesSim(); ins.SpeciesId = Convert.ToInt32(drI["AnimalTypeId"]); ins.SpeciesName = drI["Description"].ToString(); ReturnObject.Add(ins); } } } } return ReturnObject; }