Exemple #1
0
        private IPrets GetAll(IDataReader dr)
        {
            IPrets prets = new Prets();

            prets.Id          = Convert.ToInt32(dr["Numéro"].ToString());
            prets.Nom         = dr["Nom"].ToString();
            prets.Postnom     = dr["Postnom"].ToString();
            prets.Prenom      = dr["Prénom"].ToString();
            prets.Montant     = float.Parse(dr["Montantpret"].ToString());
            prets.Interet     = float.Parse(dr["Intéret"].ToString());
            prets.Montantpaye = float.Parse(dr["Montantpaye"].ToString());
            prets.DatePret    = Convert.ToDateTime(dr["Datepret"].ToString());
            prets.DateRembour = Convert.ToDateTime(dr["DateRembu"].ToString()).Date;
            return(prets);
        }
Exemple #2
0
        private IPrets GetAll_Rembou(IDataReader dr)
        {
            IPrets prets = new Prets();

            prets.Id          = Convert.ToInt32(dr["Numéro"].ToString());
            prets.Nom         = dr["Nom"].ToString();
            prets.Postnom     = dr["Postnom"].ToString();
            prets.Prenom      = dr["Prénom"].ToString();
            prets.Montant     = float.Parse(dr["montant"].ToString());
            prets.Montantpaye = float.Parse(dr["reste"].ToString());
            prets.DatePret    = Convert.ToDateTime(dr["DateRemb."].ToString());
            prets.RefCli      = Convert.ToInt32(dr["refcli"].ToString());

            return(prets);
        }
Exemple #3
0
        public IPrets OneCredit(int id)
        {
            IPrets prets = new Prets();

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