public List <C_ClientsVoiture> Lire(string Index) { CreerCommande("SelectionnerClientsVoiture"); Commande.Parameters.AddWithValue("@Index", Index); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); List <C_ClientsVoiture> res = new List <C_ClientsVoiture>(); while (dr.Read()) { C_ClientsVoiture tmp = new C_ClientsVoiture(); tmp.idClient = int.Parse(dr["idClient"].ToString()); tmp.nomClient = dr["nomClient"].ToString(); tmp.prenomClient = dr["prenomClient"].ToString(); tmp.rueClient = dr["rueClient"].ToString(); tmp.numeroClient = int.Parse(dr["numeroClient"].ToString()); if (dr["boiteClient"] != DBNull.Value) { tmp.boiteClient = int.Parse(dr["boiteClient"].ToString()); } tmp.codePoClient = int.Parse(dr["codePoClient"].ToString()); tmp.localiteClient = dr["localiteClient"].ToString(); tmp.emailClient = dr["emailClient"].ToString(); res.Add(tmp); } dr.Close(); Commande.Connection.Close(); return(res); }
public C_ClientsVoiture Lire_ID(int idClient) { CreerCommande("SelectionnerClientsVoiture_ID"); Commande.Parameters.AddWithValue("@idClient", idClient); Commande.Connection.Open(); SqlDataReader dr = Commande.ExecuteReader(); C_ClientsVoiture res = new C_ClientsVoiture(); while (dr.Read()) { res.idClient = int.Parse(dr["idClient"].ToString()); res.nomClient = dr["nomClient"].ToString(); res.prenomClient = dr["prenomClient"].ToString(); res.rueClient = dr["rueClient"].ToString(); res.numeroClient = int.Parse(dr["numeroClient"].ToString()); if (dr["boiteClient"] != DBNull.Value) { res.boiteClient = int.Parse(dr["boiteClient"].ToString()); } res.codePoClient = int.Parse(dr["codePoClient"].ToString()); res.localiteClient = dr["localiteClient"].ToString(); res.emailClient = dr["emailClient"].ToString(); } dr.Close(); Commande.Connection.Close(); return(res); }