public List <DTOSalle> SelectAllSalle() { DataTable table = _dbal.SelectAll("Salle"); List <DTOSalle> listSalles = new List <DTOSalle>(); for (int i = 0; i < table.Rows.Count; i++) { DAOxTheme dAOxTheme = new DAOxTheme(_dbal); DTOTheme theme = dAOxTheme.SelectByIdTheme(Convert.ToInt32(table.Rows[i][0])); DAOxVille dAOxVille = new DAOxVille(_dbal); DTOVille ville = dAOxVille.SelectByIdVille(Convert.ToInt32(table.Rows[i][0])); DataRow row = table.Rows[0]; DTOSalle salle = new DTOSalle(Convert.ToInt32(table.Rows[i]["id"]), Convert.ToString(table.Rows[i]["nom"]), theme, ville, Convert.ToString(table.Rows[i]["heure_ouverture"]), Convert.ToString(table.Rows[i]["heure_fermeture"])); listSalles.Add(salle); } return(listSalles); }
public List <DTOParties> SelectAllPartie() { DataTable table = _dbal.SelectAll("Parties"); List <DTOParties> listpartie = new List <DTOParties>(); for (int i = 0; i < table.Rows.Count; i++) { DAOxClients dAOxClients = new DAOxClients(_dbal); DTOClients client = dAOxClients.SelectByIdClients(Convert.ToString(table.Rows[i]["pseudo_client"])); DAOxSalle dAOxSalle = new DAOxSalle(_dbal); DTOSalle salle = dAOxSalle.SelectByIdSalle(Convert.ToInt32(table.Rows[i]["idSalle"])); DataRow row = table.Rows[0]; DTOParties partie = new DTOParties(Convert.ToInt32(table.Rows[i]["id"]), Convert.ToDateTime(table.Rows[i]["date"]), Convert.ToString(table.Rows[i]["heure"]), Convert.ToInt32(table.Rows[i]["nbjoueur"]), client, salle); listpartie.Add(partie); } return(listpartie); }