public static ObservableCollection <LieuDAO> selectLieu()
{
ObservableCollection <LieuDAO> l = new ObservableCollection <LieuDAO>();
string query = "SELECT * FROM lieu;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataReader reader = null;
try
{
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
LieuDAO p = new LieuDAO(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3), reader.GetString(4));
l.Add(p);
}
}
catch (Exception e)
{
MessageBox.Show("Il y a un problème dans la table Categorie : {0}", e.StackTrace);
}
reader.Close();
return(l);
}
public static LieuViewModel getLieu(int idLieu)
{
LieuDAO pDAO = LieuDAO.getLieu(idLieu);
LieuViewModel p = new LieuViewModel(pDAO.id, pDAO.nom, pDAO.adresse, pDAO.ville, pDAO.code_postal);
return(p);
}
public static LieuViewModel getLieu(int idLieu)
{
LieuDAO pDAO = LieuDAO.getLieu(idLieu);
LieuViewModel p = new LieuViewModel(pDAO.idLieuDAO, pDAO.villeLieuDAO, pDAO.adresseLieuDAO, pDAO.codePostalLieuDAO, pDAO.departementLieuDAO);
return(p);
}
public static void updateLieu(LieuDAO p)
{
string query = "UPDATE lieu set ville=\"" + p.villeLieuDAO + "\", adresse=\"" + p.adresseLieuDAO + "\", codePostal=\"" + p.codePostalLieuDAO + "\", departement=\"" + p.departementLieuDAO + "\" where id=" + p.idLieuDAO + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void updateLieu(LieuDAO p)
{
string query = "UPDATE lieu set nom=\"" + p.nom + "\", adresse=\"" + p.adresse + "\", ville=\"" + p.ville + "\", code_postal=\"" + p.code_postal + "\" where id_Lieu=" + p.id + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertLieu(LieuDAO p)
{
int id = getMaxIdLieu() + 1;
string query = "INSERT INTO lieu VALUES (\"" + id + "\",\"" + p.villeLieuDAO + "\",\"" + p.adresseLieuDAO + "\",\"" + p.codePostalLieuDAO + "\",\"" + p.departementLieuDAO + "\");";
MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
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 static ObservableCollection <LieuViewModel> listeLieux()
{
ObservableCollection <LieuDAO> lDAO = LieuDAO.listeLieux();
ObservableCollection <LieuViewModel> l = new ObservableCollection <LieuViewModel>();
foreach (LieuDAO element in lDAO)
{
LieuViewModel p = new LieuViewModel(element.id, element.nom, element.adresse, element.ville, element.code_postal);
l.Add(p);
}
return(l);
}
public static ObservableCollection <LieuViewModel> listeLieu()
{
ObservableCollection <LieuDAO> lDAO = LieuDAO.listeLieu();
ObservableCollection <LieuViewModel> l = new ObservableCollection <LieuViewModel>();
foreach (LieuDAO element in lDAO)
{
LieuViewModel p = new LieuViewModel(element.idLieuDAO, element.villeLieuDAO, element.adresseLieuDAO, element.codePostalLieuDAO, element.departementLieuDAO);
l.Add(p);
}
return(l);
}
public static LieuDAO getLieu(int id)
{
string query = "SELECT * FROM lieu WHERE id=" + id + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
LieuDAO cat = new LieuDAO(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3), reader.GetString(4));
reader.Close();
return(cat);
}
private async void editModel()
{
LieuDAO lDao = new LieuDAO();
await lDao.deleteLieux();
foreach (Feature f in data.features)
{
Lieu l = new Lieu();
short[] coordonnees = new short[2];
DonneesGeographiques.calculerCoordonnees((float)f.geometry.coordinates[0], (float)f.geometry.coordinates[1], coordonnees);
await lDao.addLieu(l.createLieu(f, coordonnees));
}
}
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);
}
public static void insertLieu(LieuViewModel p)
{
LieuDAO.insertLieu(new LieuDAO(p.id, p.nom, p.adresse, p.ville, p.code_postal));
}
public static void supprimerLieu(int id)
{
LieuDAO.supprimerLieu(id);
}
public static void insertLieu(LieuViewModel p)
{
LieuDAO.insertLieu(new LieuDAO(p.idLieuProperty, p.villeLieuProperty, p.adresseLieuProperty, p.codePostalLieuProperty, p.departementLieuProperty));
}