public Bouteilles Lister(Pays p) { Bouteilles liste = new Bouteilles(); con.Open(); try { IDbCommand com = con.CreateCommand(); com.CommandText = "SELECT * FROM Bouteille WHERE IdCasier=" + p.Id.ToString(); IDataReader reader = com.ExecuteReader(); while (reader.Read()) { Bouteille b = reader2Bouteille(reader); liste.Ajouter(b); } } finally { con.Close(); } return(liste); }
public Bouteilles Chercher(Bouteille b) { Bouteilles liste = new Bouteilles(); String IdType = null; if (b.IdType != 0) { IdType = b.IdType.ToString(); } String IdRegion = null; if (b.IdRegion != 0) { IdRegion = b.IdRegion.ToString(); } String IdDomaine = null; if (b.IdDomaine != 0) { IdDomaine = b.IdDomaine.ToString(); } String IdContenance = null; if (b.IdContenance != 0) { IdContenance = b.IdContenance.ToString(); } String IdCru = null; if (b.IdCru != 0) { IdCru = b.IdCru.ToString(); } String IdMillesime = null; if (b.IdMillesime != 0) { IdMillesime = b.IdMillesime.ToString(); } String IdType_vinification = null; if (b.IdType_vinification != 0) { IdType_vinification = b.IdType_vinification.ToString(); } String IdAppelation = null; if (b.IdAppelation != 0) { IdAppelation = b.IdAppelation.ToString(); } String IdPays = null; if (b.IdPays != 0) { IdPays = b.IdPays.ToString(); } con.Open(); try { IDbCommand com = con.CreateCommand(); com.CommandText = "SELECT * FROM Bouteille LEFT JOIN Casier ON(Bouteille.IdCasier = Casier.idCasier) LEFT JOIN Type ON(Bouteille.IdType = Type.idType) LEFT JOIN Region ON(Bouteille.IdRegion = Region.IdRegion) LEFT JOIN Pays ON(Bouteille.IdPays = Pays.idPays) LEFT JOIN Domaine ON(Bouteille.IdPays = Pays.idPays) LEFT JOIN Contenance ON(Bouteille.IdContenance = Contenance.idContenance) LEFT JOIN Cru ON(Bouteille.IdCru = Cru.idCru) LEFT JOIN Millesime ON(Bouteille.IdMillesime = Millesime.idMillesime) LEFT JOIN Type_vinification ON(Bouteille.IdVinif = Type_vinification.IdVinif) LEFT JOIN Appelation ON(Bouteille.IdAppelation = Appelation.idAppelation) Where "; if (b.IdType != 0) { com.CommandText += " Bouteille.`IdType` = " + IdType + " AND "; } if (b.IdRegion != 0) { com.CommandText += " Bouteille.`IdRegion` = '" + IdRegion + "' AND "; } if (b.IdDomaine != 0) { com.CommandText += " Bouteille.`IdDomaine`= '" + IdDomaine + "' AND "; } if (b.IdContenance != 0) { com.CommandText += " Bouteille.`IdContenance` = '" + IdContenance + "' AND "; } if (b.IdCru != 0) { com.CommandText += " Bouteille.`IdCru` = '" + IdCru + "' AND "; } if (b.IdMillesime != 0) { com.CommandText += " Bouteille.`IdMillesime` = '" + IdMillesime + "' AND "; } if (b.IdType_vinification != 0) { com.CommandText += " Bouteille.`IdVinif` = '" + IdType + "' AND "; } if (b.IdAppelation != 0) { com.CommandText += " Bouteille.`IdAppelation` = '" + IdType_vinification + "' AND "; } if (b.IdPays != 0) { com.CommandText += " Bouteille.`IdPays` = '" + IdPays + "' AND "; } com.CommandText += "1 = 1;"; IDataReader reader = com.ExecuteReader(); while (reader.Read()) { Bouteille bo = reader2BouteilleRecherche(reader); liste.Ajouter(bo); } } finally { con.Close(); } return(liste); }