public List<RegionCategAnimal> selectNbreTeteCategRegion(int idCategAnimal, int idRegion) { SqlConnection cnx = AccesBDD.GetInstance().GetSqlConnexion(); SqlCommand maCommand = new SqlCommand(); maCommand.Parameters.Clear(); maCommand.Connection = cnx; maCommand.CommandType = System.Data.CommandType.StoredProcedure; maCommand.CommandText = "SelectNbreTetePourUneCategRegion"; maCommand.Parameters.Add("idCategAnimal", System.Data.SqlDbType.Int); maCommand.Parameters[0].Value = idRegion; maCommand.Parameters.Add("idRegion", System.Data.SqlDbType.Int); maCommand.Parameters[1].Value = idRegion; List<RegionCategAnimal> lesTeteCategRegion = new List<RegionCategAnimal>(); SqlDataReader monLecteur = maCommand.ExecuteReader(); while (monLecteur.Read()) { RegionCategAnimal unNbreTeteCategAnimal = new RegionCategAnimal((int)monLecteur["nbreTete"]); lesTeteCategRegion.Add(unNbreTeteCategAnimal); } return lesTeteCategRegion; }
public int CreerRegionCategAnimal(int nbTete,int idRegion,int idCategAnimal) { Region laRegion = new Region(idRegion); CategAnimal laCategAnimal = new CategAnimal(idCategAnimal); RegionCategAnimal laRegionCategAnimal = new RegionCategAnimal(nbTete, laRegion, laCategAnimal); return RegionCategAnimalDAO.GetInstanceDAORegionCategAnimal().AjoutRegionCategAnimal(laRegionCategAnimal); }
public int AjoutRegionCategAnimal(RegionCategAnimal uneRegionCategAnimal) { SqlConnection cnx = AccesBDD.GetInstance().GetSqlConnexion(); SqlCommand maCommand = new SqlCommand(); maCommand.Parameters.Clear(); maCommand.Connection = cnx; maCommand.CommandType = System.Data.CommandType.StoredProcedure; maCommand.CommandText = "AjoutRegionCategAnimal"; maCommand.Parameters.Add("NbreTete", System.Data.SqlDbType.Int); maCommand.Parameters[0].Value = uneRegionCategAnimal.NbreTete; maCommand.Parameters.Add("idRegion", System.Data.SqlDbType.Int); maCommand.Parameters[1].Value = uneRegionCategAnimal.UneRegion.IdRegion; maCommand.Parameters.Add("idCategAnimal", System.Data.SqlDbType.Int); maCommand.Parameters[2].Value = uneRegionCategAnimal.UneCategAnimal.IdCateg; return maCommand.ExecuteNonQuery(); }