/* private void AddIngredientClick(object sender, EventArgs e)
* {
* if (!ajoutIngredientControl1.Visible)
* ajoutIngredientControl1.Show();
* else
* {
* ajoutIngredientControl1.Hide();
* Utilities.ResetAllControls(ajoutIngredientControl1);
* }
* }
*/
public void InitializeListView()
{
ingredientsListView.View = View.Details;
ColumnHeader header1 = ingredientsListView.Columns.Add("Ingrédient", 50 * Convert.ToInt32(ingredientsListView.Font.SizeInPoints), HorizontalAlignment.Center);
ColumnHeader header2 = ingredientsListView.Columns.Add("Quantité", 20 * Convert.ToInt32(ingredientsListView.Font.SizeInPoints), HorizontalAlignment.Center);
//ColumnHeader header3 = ingredientsListView.Columns.Add("Supprimer", 10 * Convert.ToInt32(ingredientsListView.Font.SizeInPoints), HorizontalAlignment.Center);
OracleDataReader vuesDifficulte = interfaceBD.envoyerRequeteSelection("SELECT * FROM DIFFICULTE_VIEW");
while (vuesDifficulte.Read())
{
difficulteComboBox.Items.Add(vuesDifficulte.GetValue(0));
}
OracleDataReader vuesTypeRepas = interfaceBD.envoyerRequeteSelection("SELECT * FROM TYPE_REPAS_VIEW");
while (vuesTypeRepas.Read())
{
typeRepasComboBox.Items.Add(vuesTypeRepas.GetValue(0));
}
OracleDataReader vuesTypeIngredient =
interfaceBD.envoyerRequeteSelection("SELECT * FROM TYPE_INGREDIENT_VIEW");
while (vuesTypeIngredient.Read())
{
typeComboBox.Items.Add(vuesTypeIngredient.GetValue(0));
}
}
public void AfficheRecette(int position)
{
OracleDataReader recetteNomSelection = interfaceBD.envoyerRequeteSelection("SELECT NOM FROM RECETTE WHERE RECETTE_ID = '"+position+"'");
while (recetteNomSelection.Read())
{
nomRecetteLabel.Text = (recetteNomSelection.GetValue(0)).ToString();
}
OracleDataReader recetteNombrePersonnes = interfaceBD.envoyerRequeteSelection("SELECT NB_PERSONNE FROM RECETTE WHERE RECETTE_ID = '" + position + "'");
while (recetteNombrePersonnes.Read())
{
nomPersonneValeurLabel.Text = (recetteNombrePersonnes.GetValue(0)).ToString();
}
OracleDataReader recetteType = interfaceBD.envoyerRequeteSelection("SELECT TYPE_RECETTE FROM RECETTE WHERE RECETTE_ID = '" + position + "'");
while (recetteType.Read())
{
typeRepasValeurLabel.Text = (recetteType.GetValue(0)).ToString();
}
OracleDataReader tempsPreparation = interfaceBD.envoyerRequeteSelection("SELECT TEMPS_PREPARATION FROM RECETTE WHERE RECETTE_ID = '" + position + "'");
while (tempsPreparation.Read())
{
tempsPreparationValeurLabel.Text = (tempsPreparation.GetValue(0)).ToString();
}
OracleDataReader tempsCuisson = interfaceBD.envoyerRequeteSelection("SELECT TEMPS_CUISSON FROM RECETTE WHERE RECETTE_ID = '" + position + "'");
while (tempsCuisson.Read())
{
tempsCuissonValeurLabel.Text = (tempsCuisson.GetValue(0)).ToString();
}
OracleDataReader difficulte = interfaceBD.envoyerRequeteSelection("SELECT NOM FROM DIFFICULTE WHERE DIFFICULTE_ID = (SELECT DIFFICULTE FROM RECETTE WHERE RECETTE_ID = '" + position + "')");/**/
while (difficulte.Read())
{
difficulteValeurLabel.Text = (difficulte.GetValue(0)).ToString();
}
OracleDataReader ingredients = interfaceBD.envoyerRequeteSelection("SELECT DISTINCT INGREDIENT.NOM, RECETTE_INGREDIENT.QUANTITE FROM INGREDIENT INNER JOIN RECETTE_INGREDIENT ON INGREDIENT.INGREDIENT_ID = RECETTE_INGREDIENT.INGREDIENT_ID WHERE RECETTE_INGREDIENT.RECETTE_ID = '" + position + "'");
ingredientsListView.Items.Clear();
while (ingredients.Read())
{
string[] row1 = { ingredients.GetValue(0).ToString() };
ingredientsListView.Items.Add(ingredients.GetValue(1).ToString()).SubItems.AddRange(row1);
}
OracleDataReader etapes = interfaceBD.envoyerRequeteSelection("SELECT INSTRUCTIONS FROM RECETTE WHERE RECETTE_ID = '" + position + "'");
while (etapes.Read())
{
EtapeRecetteTextBox.Text = (etapes.GetValue(0)).ToString();
}
}