public static VilleViewModel getVille(int idVille)
{
VilleDAO pDAO = VilleDAO.getVille(idVille);
VilleViewModel p = new VilleViewModel(pDAO.idVilleDAO, pDAO.nomVilleDAO, pDAO.nomSpecialisteDAO, pDAO.idDepartementDAO);
return(p);
}
public static void updateVille(VilleDAO p)
{
string query = "UPDATE ville set idVille=\"" + p.idVilleDAO + "\", nomSpecialiste=\"" + p.nomSpecialisteDAO + "\", idDepartement=\"" + p.idDepartementDAO + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertVille(VilleDAO p)
{
int id = getMaxIdVille() + 1;
string query = "INSERT INTO ville VALUES (\"" + id + "\",\"" + p.idVilleDAO + "\",\"" + p.nomSpecialisteDAO + "\",\"" + p.idDepartementDAO + "\"); ";
MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.connection);
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static ObservableCollection <VilleViewModel> listeVilles()
{
ObservableCollection <VilleDAO> lDAO = VilleDAO.listeVilles();
ObservableCollection <VilleViewModel> l = new ObservableCollection <VilleViewModel>();
foreach (VilleDAO element in lDAO)
{
VilleViewModel p = new VilleViewModel(element.idVilleDAO, element.nomVilleDAO, element.nomSpecialisteDAO, element.idDepartementDAO);
l.Add(p);
}
return(l);
}
public static VilleDAO getVille(int idVille)
{
string query = "SELECT * FROM ville WHERE id=" + idVille + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.connection);
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
VilleDAO vil = new VilleDAO(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3));
reader.Close();
return(vil);
}
public static ObservableCollection <VilleDAO> selectVilles()
{
ObservableCollection <VilleDAO> l = new ObservableCollection <VilleDAO>();
string query = "SELECT * FROM ville;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
try
{
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
VilleDAO p = new VilleDAO(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3));
l.Add(p);
}
reader.Close();
}
catch (Exception)
{
MessageBox.Show("La base de données n'est pas connectée");
}
return(l);
}
//appel de la couche DAL pour récupérer une collection de clients
public List <Ville> GetVilles()
{
//ici on peut appliquer des règles métier
return(VilleDAO.GetInstance().GetVilles());
}
public static void insertVille(VilleViewModel p)
{
VilleDAO.insertVille(new VilleDAO(p.idVilleProperty, p.nomVilleProperty, p.nomSpecialisteProperty, p.idDepartementProperty));
}
public static void supprimerVille(int id)
{
VilleDAO.supprimerVille(id);
}
