public static List <ArticleCommande> getArticlesFromCommande(int noCom) { List <ArticleCommande> articles = new List <ArticleCommande>(); DataTable dt; ArticleCommande article; Serreurs er = new Serreurs("Erreur sur lecture des articles de la commande.", "ArticlesList.getArticles()"); try { String mysql = "SELECT NO_ARTICLE, QTE_CDEE, LIVREE FROM detail_cde " + "WHERE NO_COMMAND = " + noCom + " ORDER BY NO_ARTICLE"; dt = DBInterface.Lecture(mysql, er); foreach (DataRow dataRow in dt.Rows) { article = new ArticleCommande(); article.QuantiteCommandee = int.Parse(dataRow[1].ToString()); article.Livree = dataRow[2].ToString(); article.Article = Article.getArticle(int.Parse(dataRow[0].ToString())); ((List <ArticleCommande>)articles).Add(article); } return(articles); } catch (MonException e) { throw new MonException(er.MessageUtilisateur(), er.MessageApplication(), e.Message); } catch (MySqlException e) { throw new MonException(er.MessageUtilisateur(), er.MessageApplication(), e.Message); } }
public static void updateArticleInCommande(int id, ArticleCommande art) { Serreurs er = new Serreurs("Erreur sur l'écriture d'une commande.", "Commande.update()"); String requete = "UPDATE detail_cde SET " + " QTE_CDEE = " + art.QuantiteCommandee + ", LIVREE = '" + art.Livree + "'" + " WHERE NO_COMMAND = " + id + " and NO_ARTICLE = " + art.Article.NoArticle; try { DBInterface.Insertion_Donnees(requete); } catch (MonException erreur) { throw erreur; } catch (MySqlException e) { throw new MonException(er.MessageUtilisateur(), er.MessageApplication(), e.Message); } }
public static void addArticleInCommande(int id, ArticleCommande art) { Serreurs er = new Serreurs("Erreur sur l'insertion d'un article dans une commande.", "Commande.insertArticle()"); String requete = "INSERT INTO detail_cde (NO_COMMAND, NO_ARTICLE, QTE_CDEE, LIVREE) VALUES " + "('" + id + "'" + ",'" + art.Article.NoArticle + "'" + ",'" + art.QuantiteCommandee + "'" + ",'" + art.Livree + "')"; try { DBInterface.Insertion_Donnees(requete); } catch (MonException erreur) { throw erreur; } catch (MySqlException e) { throw new MonException(er.MessageUtilisateur(), er.MessageApplication(), e.Message); } }