public List <avis> SelectAll()
{
List <avis> listAvis = new List <avis>();
foreach (DataRow r in _dbal.SelectAll("avis").Rows)
{
listAvis.Add(new avis((int)r["idAvis"], (Clients)r["idClient"], (salles)r["idSalle"], (string)r["avis"]));
}
return(listAvis);
}
public List <theme> SelectAll()
{
List <theme> listFromage = new List <theme>();
foreach (DataRow r in _dbal.SelectAll("theme").Rows)
{
listFromage.Add(new theme((int)r["idTheme"], (string)r["theme"]));
}
return(listFromage);
}
public List <salles> SelectAll()
{
List <salles> listSalles = new List <salles>();
foreach (DataRow r in _dbal.SelectAll("salles").Rows)
{
listSalles.Add(new salles((int)r["idSalle"], (string)r["ville"], (theme)r["idSalle"]));
}
return(listSalles);
}
public List <Obstacle> SelectAll()
{
List <Obstacle> uneListeObstacle = new List <Obstacle>();
DataTable uneDataTable = _DBAL.SelectAll("Obstacle");
foreach (DataRow dtr in uneDataTable.Rows)
{
Obstacle unObstacle = new Obstacle((string)dtr["nom"], (string)dtr["UneDefinition"], (string)dtr["Photo"], (string)dtr["typeObstacle"]);
uneListeObstacle.Add(unObstacle);
}
return(uneListeObstacle);
}
public List <Reservation> SelectAll()
{
List <Reservation> uneListeReservation = new List <Reservation>();
DataTable uneDataTable = _DBAL.SelectAll("Reservation");
foreach (DataRow dtr in uneDataTable.Rows)
{
Reservation uneReservation = new Reservation((int)dtr["idReservation"], (Clients)dtr["idClient"], (salles)dtr["idSalle"], (Transactions)dtr["idTransaction"], (DateTime)dtr["dateReservation"], (int)dtr["nbJoueurs"], (int)dtr["nbObstacles"]);
uneListeReservation.Add(uneReservation);
}
return(uneListeReservation);
}
public List <PositionObstacle> SelectAll()
{
List <PositionObstacle> uneListePositionObstacle = new List <PositionObstacle>();
DataTable uneDataTable = _DBAL.SelectAll("PositionObstacle");
foreach (DataRow dtr in uneDataTable.Rows)
{
PositionObstacle unePositionObstacle = new PositionObstacle((int)dtr["idPositionObstacle"], (Obstacle)dtr["nomObstacle"], (Reservation)dtr["idReservation"], (int)dtr["positionObstacle"]);
uneListePositionObstacle.Add(unePositionObstacle);
}
return(uneListePositionObstacle);
}
public List <Utilisateurs> SelectAll()
{
List <Utilisateurs> listeAll = new List <Utilisateurs>();
foreach (DataRow r in _dbal.SelectAll("Utilisateur").Rows)
{
listeAll.Add(new Utilisateurs
((string)r["Login"],
(string)r["MotDePasse"]));
}
return(listeAll);
}
public List <Transactions> SelectAll()
{
List <Transactions> listeAll = new List <Transactions>();
foreach (DataRow r in _dbal.SelectAll("Transactions").Rows)
{
Clients monClient = this.TheDaoCLient.SelectById((int)r["id"]);
listeAll.Add
(new Transactions
((int)r["idTransaction"],
monClient,
(double)r["MontantTransaction"]));
}
return(listeAll);
}
public List <Clients> SelectAll()
{
List <Clients> listeAll = new List <Clients>();
foreach (DataRow r in _dbal.SelectAll("Client").Rows)
{
listeAll.Add(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"]));
}
return(listeAll);
}
