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();
}
