/// <summary>
/// Lit les données capturé par les requêtes
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private Type_vinification reader2Type_vinif(IDataReader reader)
{
{
Type_vinification t = new Type_vinification();
t.Id = Convert.ToInt32(reader["IdVinif"]);
t.NomVinif = reader["NomVinif"].ToString();
return(t);
}
}
/// <summary>
/// met à jour les données d'un type_vignification
/// </summary>
/// <param name="p"></param>
public void Sauver(Type_vinification p)
{
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "UPDATE Type_vinification SET NomVinif='" + p.NomVinif + "' WHERE IdVinif=" + p.Id.ToString();
com.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
}
/// <summary>
/// Supprime de la base un type_vignification
/// </summary>
/// <param name="p"></param>
public void Supprimer(Type_vinification p)
{
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "DELETE FROM Type_vinification WHERE IdVinif=" + p.Id.ToString();
com.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
}
/// <summary>
/// charge le type_vignification en question
/// </summary>
/// <param name="p"></param>
public void Relire(Type_vinification p)
{
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Type_vinification WHERE IdVinif=" + p.Id.ToString();
IDataReader reader = com.ExecuteReader();
if (reader.Read())
{
p.NomVinif = reader["NomVinif"].ToString();
}
}
finally
{
con.Close();
}
}
}
/// <summary>
/// chercher un type_vignifaication en fonction de son ID
/// </summary>
/// <param name="ID">Identifiant à rechercher</param>
/// <returns></returns>
public Type_vinification Chercher(string nom)
{
Type_vinification t = null;
try
{
con.Open();
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Type_vinification WHERE NomVinif = '" + nom + "'";
IDataReader reader = com.ExecuteReader();
if (reader.Read())
{
t = reader2Type_vinif(reader);
}
}
finally
{
con.Close();
}
return(t);
}
/// <summary>
/// chercher un type_vignifaication en fonction de son ID
/// </summary>
/// <param name="ID">Identifiant à rechercher</param>
/// <returns></returns>
public Type_vinification Chercher(int ID)
{
Type_vinification t = null;
try
{
con.Open();
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT idVinif FROM Type_Vinification WHERE IdVinif = " + ID.ToString();
IDataReader reader = com.ExecuteReader();
if (reader.Read())
{
t = reader2Type_vinif(reader);
}
}
finally
{
con.Close();
}
return(t);
}
/// <summary>
/// Créé un noveau type_vignification
/// </summary>
/// <param name="p"></param>
public void Créer(Type_vinification p)
{
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "INSERT INTO Type_vinification(NomVinif) VALUES('" + p.NomVinif + "');";
com.ExecuteNonQuery();
com.CommandText = "SELECT LAST_INSERT_ID() FROM Type_vignification;";
IDataReader reader = com.ExecuteReader();
int id = 1;
if (reader.Read())
{
id = Convert.ToInt32(reader[0]);
}
p.Id = id;
}
finally
{
con.Close();
}
}
/// <summary>
/// liste tous les types_vignification
/// </summary>
/// <returns></returns>
public Type_vinifications Lister()
{
Type_vinifications liste = new Type_vinifications();
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Type_vinification";
IDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Type_vinification t = reader2Type_vinif(reader);
liste.Ajouter(t);
}
}
finally
{
con.Close();
}
return(liste);
}
public Bouteilles Lister(Type_vinification tp)
{
Bouteilles liste = new Bouteilles();
con.Open();
try
{
IDbCommand com = con.CreateCommand();
com.CommandText = "SELECT * FROM Bouteille WHERE IdVinif=" + tp.Id.ToString();
IDataReader reader = com.ExecuteReader();
while (reader.Read())
{
Bouteille b = reader2Bouteille(reader);
liste.Ajouter(b);
}
}
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);
}
