private IDetails_Sortie GetDetailSortie(IDataReader rd)
{
IDetails_Sortie detailsortie = new Detail_sortie_service();
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.Malade = rd["designation"].ToString();
detailsortie.Date_sortie = Convert.ToDateTime(rd["date_sortie"].ToString());
return(detailsortie);
}
public IDetails_Sortie OneProduitDetail(string produit)
{
IDetails_Sortie detailapprov = new Detail_sortie_service();
//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);
}
public IDetails_Sortie OneProduitDetail(int id)
{
IDetails_Sortie detailapprov = new Detail_sortie_service();
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "Procedure d'affichage des details d'un produit";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "refproduit", 4, DbType.Int32, id));
IDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
detailapprov = GetDetailSortie(dr);
}
dr.Dispose();
}
return(detailapprov);
}
