예제 #1
0
        public C_AchatVenteVoiture Lire_ID(int idOperation)
        {
            CreerCommande("SelectionnerAchatVenteVoiture_ID");
            Commande.Parameters.AddWithValue("@idOperation", idOperation);
            Commande.Connection.Open();
            SqlDataReader       dr  = Commande.ExecuteReader();
            C_AchatVenteVoiture res = new C_AchatVenteVoiture();

            while (dr.Read())
            {
                res.idOperation   = int.Parse(dr["idOperation"].ToString());
                res.idVoiture     = int.Parse(dr["idVoiture"].ToString());
                res.idClient      = int.Parse(dr["idClient"].ToString());
                res.prixOperation = int.Parse(dr["prixOperation"].ToString());
                res.dateOperation = DateTime.Parse(dr["dateOperation"].ToString());
                res.idPaiement    = int.Parse(dr["idPaiement"].ToString());
                res.typeOperation = dr["typeOperation"].ToString();
            }
            dr.Close();
            Commande.Connection.Close();
            return(res);
        }
예제 #2
0
        public List <C_AchatVenteVoiture> Lire(string Index)
        {
            CreerCommande("SelectionnerAchatVenteVoiture");
            Commande.Parameters.AddWithValue("@Index", Index);
            Commande.Connection.Open();
            SqlDataReader dr = Commande.ExecuteReader();
            List <C_AchatVenteVoiture> res = new List <C_AchatVenteVoiture>();

            while (dr.Read())
            {
                C_AchatVenteVoiture tmp = new C_AchatVenteVoiture();
                tmp.idOperation   = int.Parse(dr["idOperation"].ToString());
                tmp.idVoiture     = int.Parse(dr["idVoiture"].ToString());
                tmp.idClient      = int.Parse(dr["idClient"].ToString());
                tmp.prixOperation = int.Parse(dr["prixOperation"].ToString());
                tmp.dateOperation = DateTime.Parse(dr["dateOperation"].ToString());
                tmp.idPaiement    = int.Parse(dr["idPaiement"].ToString());
                tmp.typeOperation = dr["typeOperation"].ToString();
                res.Add(tmp);
            }
            dr.Close();
            Commande.Connection.Close();
            return(res);
        }