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