private Contenance reader2Contenance(IDataReader reader)
{
Contenance c = new Contenance();
c.Id = Convert.ToInt32(reader["IdContenance"]);
c.Valeur = Convert.ToInt32(reader["valeur"]);
return(c);
}
public void Supprimer(Contenance c)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "DELETE FROM Contenance WHERE IdContenance=" + c.Id.ToString();
com.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Sauver(Contenance c)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "UPDATE Contenance SETvaleur='" + c.Valeur + "' WHERE IdContenance=" + c.Id.ToString();
com.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Relire(Contenance c)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Contenance WHERE IdContenance=" + c.Id.ToString();
IDataReader reader = com.ExecuteReader();
if (reader.Read())
{
c.Valeur = Convert.ToInt32(reader["valeur"]);
}
}
finally
{
con.Close();
}
}
public void Créer(Contenance c)
{
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "INSERT INTO Contenance(valeur) VALUES('" + c.Valeur + "');";
com.ExecuteNonQuery();
com.CommandText = "SELECT LAST_INSERT_ID() FROM Contenance;";
IDataReader reader = com.ExecuteReader();
int id = 1;
if (reader.Read())
{
id = Convert.ToInt32(reader[0]);
}
c.Id = id;
}
finally
{
con.Close();
}
}
public Bouteilles Lister(Contenance c)
{
Bouteilles liste = new Bouteilles();
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Bouteille WHERE IdContenance=" + c.Id.ToString();
IDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Bouteille b = reader2Bouteille(reader);
liste.Ajouter(b);
}
}
finally
{
con.Close();
}
return(liste);
}
public Contenances Lister()
{
Contenances liste = new Contenances();
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Contenance";
IDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Contenance c = reader2Contenance(reader);
liste.Ajouter(c);
}
}
finally
{
con.Close();
}
return(liste);
}
public Contenance Chercher(int val, string name)
{
Contenance c = null;
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Contenance WHERE valeur='" + val + "'";
IDataReader reader = com.ExecuteReader();
if (reader.Read())
{
c = reader2Contenance(reader);
}
}
finally
{
con.Close();
}
return(c);
}
public Contenance Chercher(int ID)
{
Contenance c = null;
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Contenance WHERE IdContenance=" + ID.ToString();
IDataReader reader = com.ExecuteReader();
if (reader.Read())
{
c = reader2Contenance(reader);
}
}
finally
{
con.Close();
}
return(c);
}
private Bouteille reader2BouteilleRecherche(IDataReader reader)
{
Bouteille bouteille = new Bouteille();
bouteille.Texte = reader[1].ToString();
bouteille.Id = Convert.ToInt32(reader[0]);
bouteille.PosX = Convert.ToInt32(reader[3]);
bouteille.PosY = Convert.ToInt32(reader[4]);
bouteille.Bue = Convert.ToBoolean(reader[2]);
Casier c = new Casier();
c.Id = Convert.ToInt32(reader[5]);
c.Nom = reader[16].ToString();
bouteille.Casier = c;
Metier.Type t = new Metier.Type();
t.Id = Convert.ToInt32(reader[6]);
t.NomType = reader[21].ToString();
bouteille.Type = t;
try
{
Region r = new Region();
r.Id = Convert.ToInt32(reader[7]);
r.NomRegion = reader[24].ToString();
bouteille.Region = r;
}
catch { }
try
{
Pays p = new Pays();
p.Id = Convert.ToInt32(reader[8]);
p.NomPays = reader[26].ToString();
bouteille.Pays = p;
}
catch { }
try
{
Domaine d = new Domaine();
d.Id = Convert.ToInt32(reader[9]);
d.NomDomaine = reader[28].ToString();
bouteille.Domaine = d;
}
catch { }
try
{
Contenance co = new Contenance();
co.Id = Convert.ToInt32(reader[10]);
co.Valeur = Convert.ToInt32(reader[30]);
bouteille.Contenance = co;
}
catch { }
try
{
Cru cr = new Cru();
cr.Id = Convert.ToInt32(reader[11]);
cr.NomCru = reader[32].ToString();
bouteille.Cru = cr;
}
catch { }
try
{
Millesime m = new Millesime();
m.Id = Convert.ToInt32(reader[12]);
m.NomMillesime = reader[34].ToString();
bouteille.Millesime = m;
}
catch { }
try
{
Type_vinification tv = new Type_vinification();
tv.Id = Convert.ToInt32(reader[13]);
tv.NomVinif = reader[36].ToString();
bouteille.Type_vinification = tv;
}
catch { }
try
{
Appelation a = new Appelation();
a.Id = Convert.ToInt32(reader[14]);
a.NomAppelation = reader[38].ToString();
bouteille.Appelation = a;
}
catch { }
return(bouteille);
}
