public JsonResult GetStatCommandesAnnule(string dateDebut, string dateFin) { try { StatCommande statDuree = new StatCommande(); StatCommande reponse = statDuree.GetStatCommandesAnnule(dateDebut, dateFin); return(Json(reponse)); } catch (Exception exception) { return(Json(exception.Message)); } }
public StatCommande GetStatCommandesAnnule(string dateDebut, string dateFin) { Connexion connexion = new Connexion(); string query = ""; if (dateDebut == "" && dateFin == "") { query = "SELECT count(*) as total FROM commande where ETAT='000' and client='1'"; } else { query = "SELECT count(*) as total FROM commande where ETAT='000' and date_commande<='" + dateFin + "' and date_commande>='" + dateDebut + "' and client='1'"; } MySqlCommand command = new MySqlCommand(query, connexion.GetConnection()); AccesSageDAO accesSageDAO = new AccesSageDAO(); MySqlDataReader dataReader; //Creation d'une liste StatCommande reponse = new StatCommande(); 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()) { StatCommande stat = new StatCommande(); stat.Nombre = Int32.Parse(dataReader["total"].ToString()); reponse = stat; } dataReader.Close(); } //return return(reponse); } catch (Exception exception) { throw exception; } finally { connexion.CloseAll(command, null, connexion.GetConnection()); } }