C#

Quote:

hello gentlemen and thank you to you who bring me your help. I am almost at the end of my program and I have an update problem. I don't see any change in my stock.
I have no error when I validate but the quantity does not change in the access database

for (int i = 0; i < dataGridView1.Rows.Count; i++) //Car tu fais une infériorité stricte
                               {
                                   ref_prod = Convert.ToString(dataGridView1.Rows[i].Cells[0].Value);
                                   Qte_prod = Convert.ToInt64(dataGridView1.Rows[i].Cells[1].Value);

                                   using (OleDbCommand cmd3 = sql_con.CreateCommand())
                                   {

                                       cmd3.CommandText = "INSERT INTO Detail_commandes (com_det, ref_det, qute_det) VALUES (@com_det,@ref_det,@qute_det)";
                                       cmd3.Parameters.AddWithValue("@com_det", TxtNunCmd.Text);
                                       cmd3.Parameters.AddWithValue("@ref_det", ref_prod);
                                       cmd3.Parameters.AddWithValue("@qute_det", Qte_prod);
                                       sql_con.Open();
                                       cmd3.ExecuteNonQuery();
                                       sql_con.Close();

                                   }

                                   using (OleDbCommand cmd4 = sql_con.CreateCommand())
                                   {
                                       //setConnection();
                                       OleDbCommand QteStock = sql_con.CreateCommand();
                                       QteStock.CommandText = "SELECT Quantite FROM Catalogue";
                                       sql_con.Open();
                                       int LastQteStock = Convert.ToInt32(QteStock.ExecuteScalar());
                                       sql_con.Close();
                                       cmd4.CommandText = "UPDATE Catalogue SET Quantite = @Quantite - @QteStc WHERE code_article = (@code_article)";
                                       cmd4.Parameters.AddWithValue("@Quantite", LastQteStock);
                                       cmd4.Parameters.AddWithValue("@QteStc", Qte_prod);
                                       cmd4.Parameters.AddWithValue("@code_article", TxtRefProduit.Text);
                                       sql_con.Open();
                                       cmd4.ExecuteNonQuery();
                                       sql_con.Close();

                                   }
                           }

the goal is to add and save later I can do it once when I want to do it for a second time I have an error: unable to find table 0, I must close the form and open it again so that I can do another one ... how to solve this problem without closing my form before?

  private void BtnAjouter_Click(object sender, EventArgs e)
        {
            int total;
            decimal total_achat;
            //si les champs sont vides
            if (TxtDesignation.Text == "" || TxtPrixUnitaire.Text == "" || TxtQteCmd.Text == "" || TxtQteStock.Text == "" || TxtRefProduit.Text == "")
            {
                MessageBox.Show("Rassurez vous que tous les champs ont bien été rempli.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                //Vérifier si la valeur saisie est numeric
                if (Int32.TryParse(TxtQteCmd.Text, out int value) && TxtRefProduit.Text != "")
                {
                    //Vérifier si la commande est inferieur ou egale au stock
                    int a = 0;
                    int b = 0;
                    int c;

                    //Convertire les textBox en int
                    int.TryParse(TxtQteCmd.Text.Trim(), out a);
                    int.TryParse(TxtQteStock.Text.Trim(), out b);
                    int.TryParse(TxtPrixUnitaire.Text.Trim(), out c);

                    if (a <= b)
                    {
                        total = a * c;
                        total_achat = 0;

                        try
                        {
            
                            setConnection();
                            sql_con.Open();
                            using (OleDbCommand cmd = sql_con.CreateCommand())
                            {
                                cmd.CommandText = "INSERT INTO Detail_temp (ref_det, qute_det, Designation, Prix_unitaire_HT, Prix_total_HT) VALUES (@ref_det,@qute_det,@Designation,@Prix_unitaire_HT,@Prix_total_HT)";
                                cmd.Parameters.AddWithValue("@ref_det", TxtRefProduit.Text);
                                cmd.Parameters.AddWithValue("@qute_det", TxtQteCmd.Text);
                                cmd.Parameters.AddWithValue("@Designation", TxtDesignation.Text);
                                cmd.Parameters.AddWithValue("@Prix_unitaire_HT", TxtPrixUnitaire.Text);
                                cmd.Parameters.AddWithValue("@Prix_total_HT", total);

                                cmd.ExecuteNonQuery();
                                DS.Reset();
                                DB.Fill(DS);
                                DT = DS.Tables[0]; (Problem is here):confused::confused:
                                dataGridView1.DataSource = DT;
                                cmd.Dispose();
                                sql_con.Close();
                             
                            }
                        }
                        catch(Exception ex)
                        {
                            MessageBox.Show(ex.ToString());
                        }
                        
Designation, Prix_unitaire_HT, Prix_total_HT) VALUES (@ref_det, @qute_det, @Designation, @Prix_unitaire_HT, @Prix_total_HT)";
                       
                

                        try
                        {

                            LoadDB();
                         
                            //ADDITIONNER UNE COLONNE DU DATAGRIDVIEW
                            for (int i = 0; i < dataGridView1.Rows.Count; i++) //Car tu fais une infériorité stricte
                            {
                                total_achat += Convert.ToDecimal(dataGridView1.Rows[i].Cells[4].Value);

                            }
                            TxtTotalCmd.Text = total_achat.ToString();//convertir total_achat en string^pour pouvoir l'afficher dans le textbox
                            vider();
                            
                          
                            
                        }
                       
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.ToString());
                            sql_con.Close();
                        }
                        finally
                        {
                            sql_con.Close();
                        }

                    }
                    else
                    {
                        MessageBox.Show("Veuillez verifier le stock du produit!!!");
                    }
                }

            }

        }

// Logic Behind this Kata
   // 1, 2,....100
   // take first example 36- 36 is a perfect square of 6 and it is divisble by 36,18,12,9,6,4,3,2,1 which is 9 Odd
   // take first example 25- 25 is a perfect square of 5 and it is divisble by 25,5,1 which is 3 Odd
   // If we talk about not perfect square then - 50 is divisble by 50,25,10,5,2,1 which is 6 Even
   // If we talk about not perfect square then - 8 is divisble by 8,4,2,1 which is 4 Even
   // Now take example of 25 => 25 (Open), 5(Close), 1 (Open)
   // Now 36 => 36(Open),18(Close),12(Open),9(Close),6(Open),4(Close),3(Open),2(Close),1 (Open)
   // It means every perfect square has Open door
   // And Every non perfect square has Closed Door

[TestMethod]
      public void TestIfAllDoorsAreClosedAtBiginning()
      {
          bool[] result = _100DoorsKata.CheckDoorState(0);
          for (int i = 1; i <= 100; i++)
          {
              Assert.IsFalse(result[i]);
          }
      }

      [TestMethod]
      public void TestIfAllDoorsAreOpenedAfterFirstRound()
      {
          bool[] result = _100DoorsKata.CheckDoorState(1);
          for (int i = 1; i <= 100; i++)
          {
              Assert.IsTrue(result[i]);
          }
      }

public bool[] CheckDoorState(int pass)
       {
           bool[] doors = new bool[101];
           for (int i = 1; i <= 100; i++)
           {
               if (pass == 0)
               {
                   doors[i] = false;
               }
               else
               {

                   doors[i] = true;

               }

           }
           return doors;

       }

good evening gentlemen and thank you to you who brought me help but I am continuing my project and I have a problem retrieving info from one table to insert it into another.
I have three tables which are related
1.product (article_ID, design, price_U, Qty)
2.order (com_number, com_date, com_amount)
3.detail_command (num_det, num_com, ID_article, qute_det)
I can't fill the detail_commende table. It must be said that I am lost. can you put me on the track please
I may have made a serious mistake in my codes.

private void BtnValider_Click(object sender, EventArgs e)
      {
          DialogResult dialogResult = MessageBox.Show("Voulez vous valider la facture?", "VALIDATION DE LA FACTURE", MessageBoxButtons.YesNo);
          if (dialogResult == DialogResult.Yes)
          {
              try
              {

                  setConnection();
                  sql_con.Open();

                  using (OleDbCommand cmd1 = sql_con.CreateCommand())
                  {

                      cmd1.CommandText = "INSERT INTO Commandes (montant_com) VALUES (@montant_com)";
                      cmd1.Parameters.AddWithValue("@montant_com", TxtTotalCmd.Text);
                      //sql_cmd = new OleDbCommand(CommandText, sql_con);
                      cmd1.ExecuteNonQuery();
                      //ADODB.Recordset dbrst = new ADODB.Recordset();
                  }

                  long Qte_prod, numCmd;
                  string ref_prod;


                  using (OleDbCommand cmd2 = sql_con.CreateCommand())
                  {
                      //setConnection();

                      cmd2.CommandText = "SELECT MAX(num_com) AS dernier_num FROM Commandes";
                      // cmd2.Connection.Open();
                     // sql_con.Open();
                      object result = cmd2.ExecuteScalar();
                      if (result is null || Convert.IsDBNull(result))
                      {
                          numCmd = 0;
                      }
                      else
                      {
                          numCmd = Convert.ToInt64(result);
                          TxtNunCmd.Text = numCmd.ToString();


                          //LoadDB();
                          //object result1 = cmd3.ExecuteScalar();
                          for (int i = 0; i < dataGridView1.Rows.Count; i++) //Car tu fais une infériorité stricte
                              {
                                  ref_prod = Convert.ToString(dataGridView1.Rows[i].Cells[0].Value);
                                  Qte_prod = Convert.ToInt64(dataGridView1.Rows[i].Cells[1].Value);

                                  using (OleDbCommand cmd3 = sql_con.CreateCommand())
                                  {

                                      cmd3.CommandText = "INSERT INTO * Detail_commandes (com_det, ref_det, qute_det) VALUES (@com_det,@ref_det,@qute_det)";
                                      cmd3.Parameters.AddWithValue("@com_det", TxtNunCmd.Text);
                                      cmd3.Parameters.AddWithValue("@ref_det", ref_prod);
                                      cmd3.Parameters.AddWithValue("@qute_det", Qte_prod);
                                      cmd3.ExecuteNonQuery(); //***I have an error at this level: INSERT INTO syntax error

                                  }

                                  using (OleDbCommand cmd4 = sql_con.CreateCommand())
                                  {
                                      setConnection();
                                      cmd4.CommandText = "UPDATE Catalogue SET Quantite = Quantite - (@Qte_cmd) WHERE code_article = (@code_article)";
                                      cmd4.Parameters.AddWithValue("@Qte_cmd", Qte_prod);
                                      cmd4.Parameters.AddWithValue("@code_article", TxtRefProduit.Text);
                                      cmd4.ExecuteNonQuery();

                                  }
                              }
                          sql_con.Close();
                          SupDetail_Temp();
                          //vider();
                          TxtTotalCmd.Text = "";



                      }
                  }

              }

              catch (Exception ex)
              {
                  MessageBox.Show(ex.ToString());
                  sql_con.Close();
              }
          }
          else if (dialogResult == DialogResult.No)
          {
              //do something else
          }

      }