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