public static void insertCommune(DAOCommune c) { string query = "INSERT INTO Commune (`nom`,`idDepartement`) VALUES (\"" + c.nomDAOCommune + "\",\"" + c.idDAOCommune + "\"); "; MySqlCommand cmd2 = new MySqlCommand(query, connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2); cmd2.ExecuteNonQuery(); }
public static void updateCommune(DAOCommune c) { string query = "UPDATE commune set nom=\"" + c.nomDAOCommune + "\",idCommune=\"" + c.idDepartementDAOCommune + "\" where idCommune=" + c.idDAOCommune + ";"; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); }
public static CommuneViewModel getCommune(int idCommune) { DAOCommune cDAO = DAOCommune.getCommune(idCommune); int idDep = cDAO.idDepartementDAOCommune; DepartementViewModel d = DepartementORM.getDepartement(idDep); CommuneViewModel c = new CommuneViewModel(cDAO.idDAOCommune, cDAO.nomDAOCommune, d); return(c); }
private void OnPropertyChanged(string info) { PropertyChangedEventHandler handler = PropertyChanged; if (handler != null) { handler(this, new PropertyChangedEventArgs(info)); DAOCommune.updateCommune(this); } }
public static DAOCommune getCommune(int idDAOCommune) { string query = "SELECT * FROM commune WHERE idCommune=" + idDAOCommune + ";"; MySqlCommand cmd = new MySqlCommand(query, connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); DAOCommune com = new DAOCommune(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2)); reader.Close(); return(com); }
public static ObservableCollection <CommuneViewModel> listeCommune() { ObservableCollection <DAOCommune> lDAO = DAOCommune.listeCommune(); ObservableCollection <CommuneViewModel> l = new ObservableCollection <CommuneViewModel>(); foreach (DAOCommune element in lDAO) { int idDep = element.idDepartementDAOCommune; DepartementViewModel d = DepartementORM.getDepartement(idDep); // Plus propre que d'aller chercher le métier dans la DAO. CommuneViewModel c = new CommuneViewModel(element.idDAOCommune, element.nomDAOCommune, d); l.Add(c); } return(l); }
public static ObservableCollection <DAOCommune> selectCommune() { ObservableCollection <DAOCommune> l = new ObservableCollection <DAOCommune>(); string query = "SELECT * FROM Commune;"; MySqlCommand cmd = new MySqlCommand(query, connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DAOCommune c = new DAOCommune(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2)); l.Add(c); } reader.Close(); return(l); }
public static DAOCommune getCommune(int idCommune) { DAOCommune commune = DALCommune.getCommune(idCommune); return(commune); }
public static void supprimerCommune(CommuneViewModel commune) { DAOCommune.deleteCommune(commune.idCommuneProperty); }
public static void insertCommune(CommuneViewModel commune) { DAOCommune.insertCommune(commune); }