public PositionObstacle SelectById(int idPositionObstacle)
{
DataRow UneDataRow = _DBAL.SelectById("PositionObstacle", idPositionObstacle);
PositionObstacle unePositionObstacle = new PositionObstacle((int)UneDataRow["idPositionObstacle"], (Obstacle)UneDataRow["nomObstacle"], (Reservation)UneDataRow["idReservation"], (int)UneDataRow["PositionObstacle"]);
return(unePositionObstacle);
}
public Reservation SelectById(int idReservation)
{
DataRow UneDataRow = _DBAL.SelectById("Reservation", idReservation);
Reservation uneReservation = new Reservation((int)UneDataRow["idReservation"], (Clients)UneDataRow["idClient"], (salles)UneDataRow["idSalle"], (Transactions)UneDataRow["idTransaction"], (DateTime)UneDataRow["dateReservation"], (int)UneDataRow["nbJoueurs"], (int)UneDataRow["nbObstacles"]);
return(uneReservation);
}
public Utilisateurs SelectById(int id)
{
DataRow r = _dbal.SelectById("Utilisateur", id);
return(new Utilisateurs
((string)r["Login"],
(string)r["MotDePasse"]));
}
public Transactions SelectById(int id)
{
DataRow r = _dbal.SelectById("Utilisateur", id);
Clients monClient = this.TheDaoCLient.SelectById((int)r["id"]);
return(new Transactions
((int)r["idTransaction"],
monClient,
(double)r["MontantTransaction"]));
}
public Clients SelectById(int id)
{
DataRow r = _dbal.SelectById("Client", id);
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 SelectById(int idAvis)
{
DataRow r = _dbal.SelectById("avis", idAvis);
return(new avis((int)r["idAvis"], (Clients)r["idClient"], (salles)r["idSalle"], (string)r["avis"]));
}
public salles SelectById(int idSalle)
{
DataRow r = _dbal.SelectById("salles", idSalle);
return(new salles((int)r["idSalle"], (string)r["ville"], (theme)r["idSalle"]));
}
public theme SelectById(int idTheme)
{
DataRow r = _dbal.SelectById("theme", idTheme);
return(new theme((int)r["idTheme"], (string)r["theme"]));
}
public Joueur GetById(int id)
{
return(new Joueur(_dbal.SelectById("joueur", id), _daoAvis.GetByJoueurId(id)));
}
public Site GetById(int i)
{
return(new Site(_dbal.SelectById("site", i)));
}
public Horaire GetById(int id)
{
return(new Horaire(_dbal.SelectById("horaire", id)));
}