private IRemboursser GetAll(IDataReader dr) { IRemboursser rembouresser = new Remboursser(); rembouresser.Id = Convert.ToInt32(dr[""].ToString()); rembouresser.Nom = dr[""].ToString(); rembouresser.Postnom = dr[""].ToString(); rembouresser.Prenom = dr[""].ToString(); rembouresser.Montant = float.Parse(dr[""].ToString()); rembouresser.DateRembour = Convert.ToDateTime(dr[""].ToString()); return(rembouresser); }
public IRemboursser OneRembour(int id) { IRemboursser prets = new Remboursser(); if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = ""; cmd.CommandType = CommandType.StoredProcedure; IDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { prets = GetAll(dr); } dr.Close(); cmd.Dispose(); } ImplementeConnexion.Instance.Conn.Close(); return(prets); }