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