/* Last Commande Inserted */ public static Commande lastCommande() { int cmd_id = 0; try { //connection à la base de données MySqlCommand cmd = new MySqlCommand(Bdd.lastCommande, Bdd.connexion()); //Execute la commandekkke MySqlDataReader msdr = cmd.ExecuteReader(); while (msdr.Read()) { cmd_id = Int32.Parse(msdr["cmd_id"].ToString()); } msdr.Dispose(); Bdd.deconnexion(); return(CommandeDAO.selectCommandeById(cmd_id, false, false, false)); } catch (Exception Ex) { MessageBox.Show("ERREUR BDD : lastCommande"); Bdd.deconnexion(); return(null); } }
/* Selectionner les articles rendu en fonction de la date * @Param plage date : * 1 : par jour * 2 : par semaine * 3 : par mois * 4 : par année */ public static List <Article> selectArticlePayeeByDateNoCleanWay(int plageDate) { int test = 0; try { List <Article> requestResult = new List <Article>(); List <Article> retour = new List <Article>(); List <int> ifpayee = new List <int>(); //connection à la base de données MySqlCommand cmd = new MySqlCommand(Bdd.selectArticlePayeeByDate, Bdd.connexion()); #region ajout des parametres switch (plageDate) { //par jour case 1: cmd.Parameters.AddWithValue("startTime", new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0)); cmd.Parameters.AddWithValue("endTime", new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59)); break; //par semaine case 2: cmd.Parameters.AddWithValue("startTime", new DateTime(SecondaryDateTime.GetMonday(DateTime.Now).Year, SecondaryDateTime.GetMonday(DateTime.Now).Month, SecondaryDateTime.GetMonday(DateTime.Now).Day, 0, 0, 0)); cmd.Parameters.AddWithValue("endTime", new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59)); break; //par mois case 3: cmd.Parameters.AddWithValue("startTime", new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0)); cmd.Parameters.AddWithValue("endTime", new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59)); break; //par année case 4: cmd.Parameters.AddWithValue("startTime", new DateTime(DateTime.Now.Year, 1, 1, 0, 0, 0)); cmd.Parameters.AddWithValue("endTime", new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 23, 59, 59)); break; } #endregion #region récupération depuis la BDD des articles //Execute la commande MySqlDataReader msdr = cmd.ExecuteReader(); //Article article; while (msdr.Read()) { Article article = new Article(); article.id = Int32.Parse(msdr["art_id"].ToString()); article.photo = msdr["art_photo"].ToString(); article.commentaire = msdr["art_commentaire"].ToString(); article.ifRendu = bool.Parse(msdr["art_rendu"].ToString()); article.TVA = float.Parse(msdr["art_TVA"].ToString()); article.TTC = float.Parse(msdr["art_TTC"].ToString()); article.type = new TypeArticle(Int32.Parse(msdr["art_typ_id"].ToString()), null, 0, 0, 0, null); if (msdr["art_conv_id"].ToString().Equals("") || msdr["art_conv_id"].ToString() == null) { article.convoyeur = new PlaceConvoyeur(0, 0, 0); } else { article.convoyeur = new PlaceConvoyeur(Int32.Parse(msdr["art_conv_id"].ToString()), 0, 0); } article.fk_commande = Int32.Parse(msdr["art_cmd_id"].ToString()); if (!msdr["art_date_payee"].ToString().Equals("")) { article.date_payee = DateTime.Parse(msdr["art_date_payee"].ToString()); } requestResult.Add(article); } msdr.Dispose(); Bdd.deconnexion(); #endregion Commande commande; foreach (Article art in requestResult) { if (art.id == 564) { test = art.id; } commande = CommandeDAO.selectCommandeById(art.fk_commande, true, false, false); if (commande.listPayements.Count != 0) { if (commande.listPayements[0] != null) { //si l'article n'a pas été payée par cleanWay if (!(commande.listPayements[0].typePaiement.Equals("CleanWay"))) { retour.Add(art); } } } } #region ajout des types, des departements et des places convoyeurs foreach (Article art in retour) { art.type = TypeArticleDAO.selectTypesById(art.type.id); art.convoyeur = PlaceConvoyeurDAO.selectConvoyeurById(art.convoyeur.id); } #endregion return(retour); } catch (Exception Ex) { MessageBox.Show("ERREUR BDD : selectArticlePayeeByDateNoCleanWay : " + Ex); Bdd.deconnexion(); return(null); } }