Example #1
0
        private void button2_Click(object sender, EventArgs e)
        {
            DAL           d = new DAL();
            Facture       f = new Facture();
            Class_Article a = new Class_Article();
            LigneFacture  c = new LigneFacture();

            f.Num_facture  = textBox1.Text;
            f.Date_facture = dateTimePicker1.Value;
            // int IdFact = d.Insert Facture(f);
            // if (IdFact > 0)
            // {
            MessageBox.Show("Facture Ajouté");

            foreach (DataGridViewRow r in dataGridView1.Rows)
            {
                c.Reference = textBox1.Text;
                //c.IdArticle = Convert.ToString(r.Cells[0].Value);
                c.Quantite = Convert.ToInt16(r.Cells[3].Value);
                d.Insert_Commande(c);

                int qte = Convert.ToInt16(r.Cells[3].Value);
                a = d.fill_art_ref(Convert.ToString(r.Cells[0].Value));
                // MessageBox.Show("" + a.Quantite1);
                a.Quantite1 = a.Quantite1 - qte;
                string refe = Convert.ToString(r.Cells[0].Value);
                d.UpDate_qte(a, refe);
            }

            MessageBox.Show("Facture n'est pas Ajouté");

            this.Hide();
        }
Example #2
0
        //Ajout Commande

        public Boolean Insert_Commande(LigneFacture c)
        {
            conn.Open();
            string     Marequet = "INSERT INTO LigneFacture (Reference , Id_act , Quantite) VALUES ( @Reference , @IdArticle , @Quantite )";
            SqlCommand cmd      = new SqlCommand(Marequet, conn);

            cmd.Parameters.AddWithValue("@Reference", c.Reference);
            cmd.Parameters.AddWithValue("@IdArticle", c.IdArticle);
            cmd.Parameters.AddWithValue("@IdArticle", c.Idfacture);
            cmd.Parameters.AddWithValue("@Quantite", c.Quantite);
            cmd.ExecuteNonQuery();
            conn.Close();
            return(true);
        }