public Obstacle SelectByName(string nomObstacle)
{
DataTable uneDataTable = _DBAL.SelectByField("Obstacle", "nomObstacle = '" + nomObstacle + "';");
Obstacle unObstacle = new Obstacle((string)uneDataTable.Rows[0]["nom"], (string)uneDataTable.Rows[0]["UneDefinition"], (string)uneDataTable.Rows[0]["Photo"], (string)uneDataTable.Rows[0]["typeObstacle"]);
return(unObstacle);
}
public Utilisateurs SelectByName(string login)
{
DataRow r = _dbal.SelectByField("Utilisateur", "Login like '" + login + "'").Rows[0];
return(new Utilisateurs
((string)r["Login"],
(string)r["MotDePasse"]));
}
public Clients SelectByName(string nom)
{
DataRow r = _dbal.SelectByField("Client", "nom like '" + nom + "'").Rows[0];
return(new Clients
((int)r["id"],
(string)r["nom"],
(string)r["prenom"],
(string)r["photo"],
(string)r["adresse"],
(DateTime)r["DateNaissance"],
(string)r["Email"],
(string)r["TelephonePortable"]));
}
public avis SelectByName(string avis)
{
DataRow r = _dbal.SelectByField("avis", "avis like '" + avis + "'").Rows[0];
return(new avis((int)r["idAvis"], (Clients)r["idClient"], (salles)r["idSalle"], (string)r["avis"]));
}
public salles SelectByName(string salle)
{
DataRow r = _dbal.SelectByField("salles", "nom like '" + salle + "'").Rows[0];
return(new salles((int)r["idSalle"], (string)r["ville"], (theme)r["idSalle"]));
}
public theme SelectByName(string theme)
{
DataRow r = _dbal.SelectByField("theme", "nom like '" + theme + "'").Rows[0];
return(new theme((int)r["idTheme"], (string)r["theme"]));
}
