public string getTop10Fabricantes() { string query = "SELECT NOME_PAIS_FABRIC, COUNT(NOME_PAIS_FABRIC) FROM anvisa_dados " + " GROUP BY NOME_PAIS_FABRIC ORDER BY COUNT(NOME_PAIS_FABRIC) DESC limit 10 "; MySqlConnection connection = new MySqlConnection(config); MySqlCommand command = new MySqlCommand(query, connection); connection.Open(); MySqlDataReader Reader = command.ExecuteReader(); var json = new List <FabricanteJSON>(); while (Reader.Read()) { FabricanteJSON obj = new FabricanteJSON(); obj.Nome = Reader[0].ToString(); obj.Count = Reader[1].ToString(); json.Add(obj); } connection.Close(); string jsonstring = JsonConvert.SerializeObject(json, Formatting.Indented); return(jsonstring); }
public string getRiscosPorVigencia() { string query = " SELECT VALIDADE_REGISTRO_CADASTRO, CLASSE_RISCO, COUNT(CLASSE_RISCO)" + "FROM anvisa_dados WHERE VALIDADE_REGISTRO_CADASTRO= 'VIGENTE' GROUP BY CLASSE_RISCO" + "ORDER BY COUNT(CLASSE_RISCO)DESC "; MySqlConnection connection = new MySqlConnection(config); MySqlCommand command = new MySqlCommand(query, connection); connection.Open(); MySqlDataReader Reader = command.ExecuteReader(); var json = new List <FabricanteJSON>(); while (Reader.Read()) { FabricanteJSON obj = new FabricanteJSON(); obj.Nome = Reader[0].ToString(); obj.Count = Reader[1].ToString(); json.Add(obj); } connection.Close(); string jsonstring = JsonConvert.SerializeObject(json, Formatting.Indented); return(jsonstring); }