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