Exemple #1
0
        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();
            }
        }
Exemple #2
0
        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();
            }
        }