public Millesime Chercher(int nom, string car)
{
Millesime m = null;
if (con.State != ConnectionState.Open)
{
con.Open();
}
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Millesime WHERE NomMillesime='" + nom + "'";
IDataReader reader = com.ExecuteReader();
if (reader.Read())
{
m = reader2Millesime(reader);
}
}
finally
{
con.Close();
}
return(m);
}
private Millesime reader2Millesime(IDataReader reader)
{
Millesime m = new Millesime();
m.Id = Convert.ToInt32(reader["IdMillesime"]);
m.NomMillesime = reader["NomMillesime"].ToString();
return(m);
}
public void Supprimer(Millesime p)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "DELETE FROM Millesime WHERE IdMillesime=" + p.Id.ToString();
com.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Sauver(Millesime p)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "UPDATE Millesime SETNomMillesime='" + p.NomMillesime + "' WHERE IdMillesime=" + p.Id.ToString();
com.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
public void Relire(Millesime p)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Millesime WHERE IdMillesime=" + p.Id.ToString();
IDataReader reader = com.ExecuteReader();
if (reader.Read())
{
p.NomMillesime = reader["NomMillesime"].ToString();
}
}
finally
{
con.Close();
}
}
public Bouteilles Lister(Millesime m)
{
Bouteilles liste = new Bouteilles();
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Bouteille WHERE IdMillesime=" + m.Id.ToString();
IDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Bouteille b = reader2Bouteille(reader);
liste.Ajouter(b);
}
}
finally
{
con.Close();
}
return(liste);
}
public void Créer(Millesime p)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "INSERT INTO Millesime(NomMillesime) VALUES('" + p.NomMillesime + "');";
com.ExecuteNonQuery();
com.CommandText = "SELECT LAST_INSERT_ID() FROM Millesime;";
IDataReader reader = com.ExecuteReader();
int id = 1;
if (reader.Read())
{
id = Convert.ToInt32(reader[0]);
}
p.Id = id;
}
finally
{
con.Close();
}
}
public Millesimes Lister()
{
Millesimes liste = new Millesimes();
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Millesime";
IDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Millesime m = reader2Millesime(reader);
liste.Ajouter(m);
}
}
finally
{
con.Close();
}
return(liste);
}
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);
}
