private void SetLastMaleSocialGroup() { this.LastSocialGroupMales = new List <SocialGroupMales>(); SocialGroupMales ins; SqlConnection sqlConn = DataBaseConnection.SqlConn(); using (var con = sqlConn) { con.Open(); using (SqlCommand cmd = new SqlCommand("exec " + StoredProcedures.GetAIHistory + " @AnimalId", con)) { cmd.Parameters.AddWithValue("@AnimalId", this.AnimalId); using (var drI = cmd.ExecuteReader()) { while (drI.Read()) { ins = new SocialGroupMales(); ins.MaleId = Convert.ToInt32(drI["AnimalId"]); ins.Tag = drI["TagNumber"].ToString(); this.LastSocialGroupMales.Add(ins); } } } con.Close(); con.Dispose(); } }
private void SetLastMaleSocialGroup() { this.LastSocialGroupMales = new List<SocialGroupMales>(); SocialGroupMales ins; SqlConnection sqlConn = DataBaseConnection.SqlConn(); using (var con = sqlConn) { con.Open(); using (SqlCommand cmd = new SqlCommand("exec " + StoredProcedures.GetAIHistory + " @AnimalId", con)) { cmd.Parameters.AddWithValue("@AnimalId", this.AnimalId); using (var drI = cmd.ExecuteReader()) { while (drI.Read()) { ins = new SocialGroupMales(); ins.MaleId = Convert.ToInt32(drI["AnimalId"]); ins.Tag = drI["TagNumber"].ToString(); this.LastSocialGroupMales.Add(ins); } } } con.Close(); con.Dispose(); } }