public List <C_DesiterataVoiture> Lire(string Index)
{
CreerCommande("SelectionnerDesiterataVoiture");
Commande.Parameters.AddWithValue("@Index", Index);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
List <C_DesiterataVoiture> res = new List <C_DesiterataVoiture>();
while (dr.Read())
{
C_DesiterataVoiture tmp = new C_DesiterataVoiture();
tmp.idDesiterata = int.Parse(dr["idDesiterata"].ToString());
tmp.idClient = int.Parse(dr["idClient"].ToString());
tmp.idMarque = int.Parse(dr["idMarque"].ToString());
if (dr["idModele"] != DBNull.Value)
{
tmp.idModele = int.Parse(dr["idModele"].ToString());
}
if (dr["idCat"] != DBNull.Value)
{
tmp.idCat = int.Parse(dr["idCat"].ToString());
}
if (dr["kilometrageMax"] != DBNull.Value)
{
tmp.kilometrageMax = int.Parse(dr["kilometrageMax"].ToString());
}
if (dr["idCouleur"] != DBNull.Value)
{
tmp.idCouleur = int.Parse(dr["idCouleur"].ToString());
}
if (dr["idCarburant"] != DBNull.Value)
{
tmp.idCarburant = int.Parse(dr["idCarburant"].ToString());
}
if (dr["anneeMin"] != DBNull.Value)
{
tmp.anneeMin = int.Parse(dr["anneeMin"].ToString());
}
res.Add(tmp);
}
dr.Close();
Commande.Connection.Close();
return(res);
}
public C_DesiterataVoiture Lire_ID(int idDesiterata)
{
CreerCommande("SelectionnerDesiterataVoiture_ID");
Commande.Parameters.AddWithValue("@idDesiterata", idDesiterata);
Commande.Connection.Open();
SqlDataReader dr = Commande.ExecuteReader();
C_DesiterataVoiture res = new C_DesiterataVoiture();
while (dr.Read())
{
res.idDesiterata = int.Parse(dr["idDesiterata"].ToString());
res.idClient = int.Parse(dr["idClient"].ToString());
res.idMarque = int.Parse(dr["idMarque"].ToString());
if (dr["idModele"] != DBNull.Value)
{
res.idModele = int.Parse(dr["idModele"].ToString());
}
if (dr["idCat"] != DBNull.Value)
{
res.idCat = int.Parse(dr["idCat"].ToString());
}
if (dr["kilometrageMax"] != DBNull.Value)
{
res.kilometrageMax = int.Parse(dr["kilometrageMax"].ToString());
}
if (dr["idCouleur"] != DBNull.Value)
{
res.idCouleur = int.Parse(dr["idCouleur"].ToString());
}
if (dr["idCarburant"] != DBNull.Value)
{
res.idCarburant = int.Parse(dr["idCarburant"].ToString());
}
if (dr["anneeMin"] != DBNull.Value)
{
res.anneeMin = int.Parse(dr["anneeMin"].ToString());
}
}
dr.Close();
Commande.Connection.Close();
return(res);
}
