public ActionResult <List <Scene> > Filter_Scene_Lieu(string search) { LieuDAO lieuDAO = new LieuDAO(); SceneDAO sceneDAO = new SceneDAO(); List <Scene> scenes = new List <Scene>(); int LieuId = lieuDAO.Return_IdLieu(search); scenes = sceneDAO.Display_By_Lieu(LieuId); return(scenes); }
public ActionResult <List <Scene> > Filter_Scene_Artiste_Style_Lieu(string search, string searchArtiste, string searchLieu) { LieuDAO lieuDAO = new LieuDAO(); StyleDAO styleDAO = new StyleDAO(); ArtisteDAO artisteDAO = new ArtisteDAO(); Festival_ArtisteDAO festival_ArtisteDAO = new Festival_ArtisteDAO(); SceneDAO sceneDAO = new SceneDAO(); List <Festival_Artiste> festival_Artistes = new List <Festival_Artiste>(); List <Scene> scenes = new List <Scene>(); int IdS = styleDAO.Return_IdStyle(search); int IdA = artisteDAO.Return_IdArtiste(searchArtiste); int LieuId = lieuDAO.Return_IdLieu(searchLieu); festival_Artistes = festival_ArtisteDAO.list_Festival_Artiste(IdS, IdA); scenes = sceneDAO.List_Scene_by_Artist_Lieu_Style(festival_Artistes, LieuId); return(scenes); }