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