public List <StatEmplacement> GetStatEmplacements() { Connexion connexion = new Connexion(); string query = "select emplacement, count(*) as total from detail_commande join commande on commande.id_commande=detail_commande.id_commande where commande.client = '1' and commande.etat='111' group by emplacement"; MySqlCommand command = new MySqlCommand(query, connexion.GetConnection()); MySqlDataReader dataReader; //Creation d'une liste List <StatEmplacement> reponse = new List <StatEmplacement>(); try { //Ouverture connexion if (connexion.OpenConnection() == true) { //Excecution de la commande dataReader = command.ExecuteReader(); //Lecture des donnees et stockage dans la liste while (dataReader.Read()) { StatEmplacement stat = new StatEmplacement(); if (dataReader["emplacement"].ToString() == "0") { stat.Emplacement = new Emplacement("0", "Stock"); } else { stat.Emplacement = GetEmplacementsByNumero(dataReader["emplacement"].ToString()); } stat.Quantite = Int32.Parse(dataReader["total"].ToString()); reponse.Add(stat); } dataReader.Close(); } //return return(reponse); } catch (Exception exception) { throw exception; } finally { if (command != null) { command.Dispose(); } if (connexion.GetConnection() != null) { connexion.GetConnection().Close(); } } }
public JsonResult GetStatistiques() { try { StatEmplacement stat = new StatEmplacement(); List <StatEmplacement> liste = stat.GetStatEmplacements(); return(Json(liste)); } catch (Exception exception) { return(Json(exception.Message)); } }
public JsonResult GetStatistiquesEntreDeuxDates(string dateDebut, string dateFin) { try { StatEmplacement stat = new StatEmplacement(); List <StatEmplacement> liste = stat.GetStatEmplacementsEntreDeuxDates(dateDebut, dateFin); return(Json(liste)); } catch (Exception exception) { return(Json(exception.Message)); } }