public void ModifierVariete(Models.Variete V)
{
conx.Query(@"update Variete set nomVariete=@2,numCulture=@3
where num=@1 ");
conx.cmd.Parameters.AddWithValue("@2", V._nomVariete);
conx.cmd.Parameters.AddWithValue("@3", V._culture._numCulture);
conx.cmd.Parameters.AddWithValue("@1", V._num);
conx.ExecuteNonQuery();
}
/* ajout*/
public void AjouterVariete(Models.Variete V)
{
conx.Query("insert into Variete values (@1,@2,@3,@4,@5)");
conx.cmd.Parameters.AddWithValue("@1", V._num);
conx.cmd.Parameters.AddWithValue("@2", V._nomVariete);
conx.cmd.Parameters.AddWithValue("@3", V._culture._numCulture);
conx.ExecuteNonQuery();
}
public void SupprimerVariete(Models.Variete V)
{
conx.Query(@"delete from culture where num=@1 ");
conx.cmd.Parameters.AddWithValue("@1", V._num);
conx.ExecuteNonQuery();
}
