private Detail_Approvisionnement GetDetails(IDataReader dr)
{
Detail_Approvisionnement da = new Detail_Approvisionnement();
i = i + 1;
da.Num = i;
da.Code = dr["Code Article"].ToString();
da.Articles = dr["Articles"].ToString();
da.Categorie = dr["Catégorie"].ToString();
da.QuantiteA = dr["Quantité en stock"].ToString();
da.PAu = Convert.ToDouble(dr["PAu"].ToString());
da.DateApprov = Convert.ToDateTime(dr["Date_Approv"].ToString());
da.PAT = dr["PAt"].ToString();
return(da);
}
public void Enregistrer(Detail_Approvisionnement det)
{
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.AddParametres(cmd, "@id", 5, DbType.Int32, det.Id));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@quantite", 10, DbType.Double, det.Quantite));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@pa", 10, DbType.Double, det.PAu));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@refarticle", 5, DbType.String, det.RefArticle));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@refapprov", 5, DbType.String, det.RefApprov));
cmd.ExecuteNonQuery();
}
}
