public ActionResult <List <Scene> > Filter_Scene_Artiste_Style(string search, string searchArtiste)
{
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);
festival_Artistes = festival_ArtisteDAO.list_Festival_Artiste(IdS, IdA);
scenes = sceneDAO.List_Scene(festival_Artistes);
return(scenes);
}
public ActionResult <List <Scene> > Filter_Scene_Artiste(string search)
{
StyleDAO styleDAO = new StyleDAO();
ArtisteDAO artisteDAO = new ArtisteDAO();
Festival_ArtisteDAO festival_ArtisteDAO = new Festival_ArtisteDAO();
SceneDAO sceneDAO = new SceneDAO();
List <Artiste> artistes = new List <Artiste>();
List <int> list_IdScene = new List <int>();
List <Scene> scenes = new List <Scene>();
int Id = styleDAO.Return_IdStyle(search);
artistes = artisteDAO.Return_Artiste_By_Style(Id);
list_IdScene = festival_ArtisteDAO.List_Id_Scene(artistes);
scenes = sceneDAO.List_Scene_Id(list_IdScene);
return(scenes);
}