public static void updateComptage(ComptageDAO p) { string query = "UPDATE comptage set idEtude=\"" + p.idEtude + "\", idPlage=\"" + p.idPlage + "\", date=\"" + p.date + "\", NbPersonnes=\"" + p.NbPersonnes + "\", Coord1Long=\"" + p.Coord1Long + "\", Coord1Larg=\"" + p.Coord1Larg + "\", Coord2Long=\"" + p.Coord2Long + "\", Coord2Larg=\"" + p.Coord2Larg + "\", Coord3Long=\"" + p.Coord3Long + "\", Coord3Larg=\"" + p.Coord3Larg + "\", Coord4Long=\"" + p.Coord4Long + "\", Coord4Larg=\"" + p.Coord4Larg + "\" where idComptage=" + p.id + "\";"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); }
public static ComptageViewModel getComptage(int idPersonne) { ComptageDAO pDAO = ComptageDAO.getComptage(idPersonne); //int idMetier = pDAO.idMetierPersonneDAO; //MetierViewModel m = MetierORM.getMetier(idMetier); ComptageViewModel p = new ComptageViewModel(pDAO.id, pDAO.idEtude, pDAO.idPlage, pDAO.date, pDAO.NbPersonnes, pDAO.Coord1Long, pDAO.Coord1Larg, pDAO.Coord2Long, pDAO.Coord2Larg, pDAO.Coord3Long, pDAO.Coord3Larg, pDAO.Coord4Long, pDAO.Coord4Larg); return(p); }
public static void insertComptage(ComptageDAO p) { int id = getMaxIdComptage() + 1; string query = "INSERT INTO comptage VALUES (\"" + id + "\",\"" + p.idEtude + "\",\"" + p.idPlage + "\",\"" + p.date + "\",\"" + p.NbPersonnes + "\",\"" + p.Coord1Long + "\",\"" + p.Coord1Larg + "\",\"" + p.Coord2Long + "\",\"" + p.Coord2Larg + "\",\"" + p.Coord3Long + "\",\"" + p.Coord3Larg + "\",\"" + p.Coord4Long + "\",\"" + p.Coord4Larg + "\");"; MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2); cmd2.ExecuteNonQuery(); }
private void OnPropertyChanged(string info) { PropertyChangedEventHandler handler = PropertyChanged; if (handler != null) { handler(this, new PropertyChangedEventArgs(info)); ComptageDAO.updateComptage(this); } }
public static ComptageDAO getComptage(int idComptage) { string query = "SELECT * FROM Comptage WHERE idComptage=" + idComptage + ";"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); ComptageDAO pers = new ComptageDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetInt32(8), reader.GetInt32(9), reader.GetInt32(10), reader.GetInt32(11), reader.GetInt32(12) /*, reader.GetInt32(3)*/); reader.Close(); return(pers); }
public static ObservableCollection <ComptageViewModel> listeComptages() { ObservableCollection <ComptageDAO> lDAO = ComptageDAO.listeComptages(); ObservableCollection <ComptageViewModel> l = new ObservableCollection <ComptageViewModel>(); foreach (ComptageDAO element in lDAO) { //int idMetier = element.idMetierPersonneDAO; //MetierDAO m = MetierDAO.getMetier(idMetier); //MetierViewModel metier = new MetierViewModel(m.idMetierDAO, m.libMetierDAO); ComptageViewModel p = new ComptageViewModel(element.id, element.idEtude, element.idPlage, element.date, element.NbPersonnes, element.Coord1Long, element.Coord1Larg, element.Coord2Long, element.Coord2Larg, element.Coord3Long, element.Coord3Larg, element.Coord4Long, element.Coord4Larg); l.Add(p); } return(l); }
public static ObservableCollection <ComptageDAO> selectComptages() { ObservableCollection <ComptageDAO> l = new ObservableCollection <ComptageDAO>(); string query = "SELECT * FROM comptage;"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { ComptageDAO p = new ComptageDAO(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2), reader.GetDateTime(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetInt32(8), reader.GetInt32(9), reader.GetInt32(10), reader.GetInt32(11), reader.GetInt32(12)); l.Add(p); } reader.Close(); return(l); }