private IDetails_Sortie GetDetailSortie(IDataReader rd)
{
IDetails_Sortie detailsortie = new Detail_Sortie_Facture();
detailsortie.Id = Convert.ToInt32(rd["iddetail"].ToString());
detailsortie.Produit = rd["designationprod"].ToString();
detailsortie.Dosage = rd["dosage"].ToString();
detailsortie.Quantite = Convert.ToInt32(rd["Quantite"].ToString());
detailsortie.Pu = Convert.ToDecimal(rd["PU"].ToString());
detailsortie.Pt = Convert.ToDecimal(rd["PT"].ToString());
detailsortie.Date_sortie = Convert.ToDateTime(rd["date_sortie"].ToString());
detailsortie.Malade = rd["noms"].ToString();
return(detailsortie);
}
public IDetails_Sortie OneProduitDetail(string produit)
{
IDetails_Sortie detailapprov = new Detail_Sortie_Facture();
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "SELECT_ONE_PRODUIT_SORTIE_DETAILS";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@produit", 4, DbType.String, produit));
IDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
detailapprov = GetDetailSortie(dr);
}
dr.Dispose();
}
return(detailapprov);
}
