public static ObservableCollection <PhotoDAO> selectPhotos() { ObservableCollection <PhotoDAO> l = new ObservableCollection <PhotoDAO>(); string query = "SELECT * FROM photo;"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection()); MySqlDataReader reader = null; try { cmd.ExecuteNonQuery(); reader = cmd.ExecuteReader(); while (reader.Read()) { PhotoDAO p = new PhotoDAO(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3)); l.Add(p); } } catch (Exception e) { MessageBox.Show("Il y a un problème dans la table Photo : {0}", e.StackTrace); } reader.Close(); return(l); }
public static void updatePhoto(PhotoDAO p) { string query = "UPDATE photo set nomPhoto=\"" + p.nomPhotoDAO + "\", lienPhoto=\"" + p.lienPhotoDAO + "\", idProduit=\"" + p.idProduitDAO + "\" where idPhoto=" + p.idPhotoDAO + ";"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection()); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); }
public static void insertPhoto(PhotoDAO p) { int id = getMaxIdPhoto() + 1; string query = "INSERT INTO photo VALUES (\"" + id + "\",\"" + p.nomPhotoDAO + "\",\"" + p.lienPhotoDAO + "\",\"" + p.idProduitDAO + "\");"; MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.OpenConnection()); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2); cmd2.ExecuteNonQuery(); }
public static PhotoViewModel getPhoto(int idPhoto) { PhotoDAO phDAO = PhotoDAO.getPhoto(idPhoto); int idProduit = phDAO.idProduitDAO; ProduitViewModel pro = ProduitORM.getProduit(idProduit); PhotoViewModel ph = new PhotoViewModel(phDAO.idPhotoDAO, phDAO.nomPhotoDAO, phDAO.lienPhotoDAO, pro); return(ph); }
public static PhotoDAO getPhoto(int idPhoto) { string query = "SELECT * FROM photo WHERE id=" + idPhoto + ";"; MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection()); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); PhotoDAO pers = new PhotoDAO(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3)); reader.Close(); return(pers); }
public static ObservableCollection <PhotoViewModel> listePhotos() { ObservableCollection <PhotoDAO> lDAO = PhotoDAO.listePhotos(); ObservableCollection <PhotoViewModel> l = new ObservableCollection <PhotoViewModel>(); foreach (PhotoDAO element in lDAO) { int idProduit = element.idProduitDAO; ProduitViewModel pro = ProduitORM.getProduit(idProduit); PhotoViewModel ph = new PhotoViewModel(element.idPhotoDAO, element.nomPhotoDAO, element.lienPhotoDAO, pro); l.Add(ph); } return(l); }
public static void insertPhoto(PhotoViewModel ph) { PhotoDAO.insertPhoto(new PhotoDAO(ph.idPhotoProperty, ph.nomPhotoProperty, ph.lienPhotoProperty, ph.idProduitProperty.idProduitProperty)); }
public static void supprimerPhoto(int id) { PhotoDAO.supprimerPhoto(id); }
public static void insertPhoto(PhotoDAO p) { PhotoDAL.insertPhoto(p); }
public static void updatePhoto(PhotoDAO p) { PhotoDAL.updatePhoto(p); }
public static PhotoDAO getPhoto(int idPhoto) { PhotoDAO p = PhotoDAL.getPhoto(idPhoto); return(p); }