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