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();
}
