//Fonction d'enregistrement des details d'approvisionnement
public void Enregistrer(IDetail_approv approv)
{
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "INSERT_DETAIL_APPROV";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, Id));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@quantite", 50, DbType.Int32, Quantite));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@pua", 50, DbType.Decimal, Pu));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@datefabric", 100, DbType.Date, DateFabric));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@date_expir", 100, DbType.Date, DateExpiration));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@refprod", 10, DbType.Int32, RefProduit));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@refapprov", 20, DbType.Int32, RefApprov));
cmd.ExecuteNonQuery();
MessageBox.Show("Enregistrement reussie !!!", "Reussite", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
void RefreshData(IDetail_approv detail)
{
dataGridView1.DataSource = detail.Approvisionnements();
}
void RefreshData(Fournisseurs four, IDetail_approv detail)
{
dataGridView3.DataSource = four.Fournisseur();
}
