public void Enregistrer(IDetails_Sortie approv) { if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "INSERT_DETAIL_SORTIE_SERVICE"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, Id)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@quantite", 10, DbType.Int32, Quantite)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@pu", 10, DbType.Decimal, Pu)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@refprod", 5, DbType.Int32, Ref_Produit)); cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@refentete", 5, DbType.Int32, Ref_Entete)); cmd.ExecuteNonQuery(); MessageBox.Show("Enregistrement reussie !!!", "Reussite", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
void RefreshData(IDetails_Sortie detail) { dataGridView1.DataSource = detail.DetailsSorties(); }