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);
}
