public static ObservableCollection <CategorieDAO> selectCategories()
{
ObservableCollection <CategorieDAO> l = new ObservableCollection <CategorieDAO>();
string query = "SELECT * FROM Categorie;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataReader reader = null;
try
{
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
CategorieDAO p = new CategorieDAO(reader.GetInt32(0), reader.GetString(1));
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 CategorieViewModel getCategorie(int idCategorie)
{
CategorieDAO pDAO = CategorieDAO.getCategorie(idCategorie);
CategorieViewModel p = new CategorieViewModel(pDAO.idCategorieDAO, pDAO.nomDAO);
return(p);
}
public static ObservableCollection <CategorieDAO> getNomCategorie(int idCategorie)
{
ObservableCollection <CategorieDAO> l = new ObservableCollection <CategorieDAO>();
string query = "SELECT p.nom FROM produit_categorie c join categorie ca on ca.idCategorie=c.idCategorie join produit p on p.idProduit=c.idProduit WHERE ca.idCategorie =" + idCategorie + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataReader reader = null;
try
{
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
CategorieDAO p = new CategorieDAO(reader.GetString(0));
l.Add(p);
}
}
catch (Exception e)
{
MessageBox.Show("Il y a un problème dans la table CategorieProduit : {0}", e.StackTrace);
}
reader.Close();
return(l);
}
public static void updateCategorie(CategorieDAO p)
{
string query = "UPDATE Categorie set nom=\"" + p.nomDAO + "\"WHERE idCategorie = \"" + p.idCategorieDAO + "\";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertCategorie(CategorieDAO p)
{
int id = getMaxIdCategorie() + 1;
string query = "INSERT INTO Categorie (idCategorie, Nom) VALUES (\"" + id + "\",\"" + p.nomDAO + "\");";
MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static ObservableCollection <CategorieViewModel> listeCategories()
{
ObservableCollection <CategorieDAO> lDAO = CategorieDAO.listeCategories();
ObservableCollection <CategorieViewModel> l = new ObservableCollection <CategorieViewModel>();
foreach (CategorieDAO element in lDAO)
{
CategorieViewModel p = new CategorieViewModel(element.idCategorieDAO, element.nomDAO);
l.Add(p);
}
return(l);
}
public static ObservableCollection <CategorieViewModel> getNomCategorie(int idCategorie)
{
ObservableCollection <CategorieDAO> pDAO = CategorieDAO.getNomCategorie(idCategorie);
ObservableCollection <CategorieViewModel> p = new ObservableCollection <CategorieViewModel>();
foreach (CategorieDAO element in pDAO)
{
CategorieViewModel pr = new CategorieViewModel(element.nomDAO);
p.Add(pr);
}
return(p);
}
public static CategorieDAO getCategorie(int idCategorie)
{
string query = "SELECT * FROM Categorie WHERE id=" + idCategorie + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
CategorieDAO pers = new CategorieDAO(reader.GetInt32(0), reader.GetString(1));
reader.Close();
return(pers);
}
public static void insertCategorie(CategorieViewModel p)
{
CategorieDAO.insertCategorie(new CategorieDAO(p.idCategorieProperty, p.nomsProperty));
}
public static void supprimerCategorie(int id)
{
CategorieDAO.supprimerCategorie(id);
}
public static void insertCategorie(CategorieDAO p)
{
CategorieDAL.insertCategorie(p);
}
public static void updateCategorie(CategorieDAO p)
{
CategorieDAL.updateCategorie(p);
}
public static CategorieDAO getCategorie(int idCategorie)
{
CategorieDAO p = CategorieDAL.getCategorie(idCategorie);
return(p);
}
