public ActionResult <Scene> AddScene(int FestivalId, string Nom, string Adresse, int Capacite, bool Accessibilite, string lieu, DateTime dateJour, string artiste)
{
SceneDAO sceneDAO = new SceneDAO();
Scene scene = new Scene();
sceneDAO.InsertScene(FestivalId, Nom, Adresse, Capacite, Accessibilite, lieu, dateJour, artiste);
scene = sceneDAO.GetScene_Nom(Nom);
return(scene);
}
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(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);
}
