SisuDataQuery.cs

using OpenQA.Selenium;
using OpenQA.Selenium.Chrome;
using HtmlAgilityPack;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

#pragma warning disable

class SisuDataQuery
{
    public static List<Institution> listInstitutions = new List<Institution>();
    public static List<Course> listIesCourses = new List<Course>();
    public static Course course;
    public static CourseWeights courseWeights;
    public static MinGrades minGrades;
    const int columnWidth = 35;

    public class Institution
    {
        public Institution(string coIes, string sgIes, string noIes, string noMunicipio)
        {
            this.institutionCode = coIes;
            this.institutionSg = sgIes;
            this.institutionName = noIes;
            this.institutionCity = noMunicipio;
        }

        public string? institutionCode { get; set; }
        public string? institutionSg { get; set; }
        public string? institutionName { get; set; }
        public string? institutionCity { get; set; }

        public override string ToString()
        {
            return $"| {institutionCode,-10} | {institutionSg,-15} | {institutionName,-columnWidth} | {institutionCity,-25} |";
        }
    }
    public class Course
    {
        public Course(string co_oferta, string co_curso, string no_curso, string no_grau, string no_turno, string no_campus, string no_municipio_campus)
        {
            this.offerCode = co_oferta;
            this.courseCode = co_curso;
            this.courseName = no_curso;
            this.courseDegree = no_grau;
            this.courseShift = no_turno;
            this.campusName = no_campus;
            this.campusCity = no_municipio_campus;
        }

        public string? offerCode { get; set; }
        public string? courseCode { get; set; }
        public string? courseName { get; set; }
        public string? courseDegree { get; set; }
        public string? courseShift { get; set; }
        public string? campusName { get; set; }
        public string? campusCity { get; set; }

        public override string ToString()
        {
            return $"| {courseCode,-10} | {courseName,-columnWidth} | {courseDegree,-20} | {courseShift,-15} | {campusName,-30} | {campusCity,-25} |";
        }
    }
    public class CourseWeights
    {
        public CourseWeights(string cnPeso, string chPeso, string lngPeso, string mtmPeso, string redPeso)
        {
            this.natSciWeight = cnPeso;
            this.hmnSciWeight = chPeso;
            this.langSciWeight = lngPeso;
            this.mtmWeight = mtmPeso;
            this.disWeight = redPeso;
        }

        public string? natSciWeight { get; set; }
        public string? hmnSciWeight { get; set; }
        public string? langSciWeight { get; set; }
        public string? mtmWeight { get; set; }
        public string? disWeight { get; set; }
        public override string ToString()
        {
            string header = $"| {"Peso CN",-15} | {"Peso CH",-15} | {"Peso Linguagens",-15} | {"Peso Matemática",-15} | {"Peso Redação",-15} |\n";
            string values = $"| {natSciWeight,-15} | {hmnSciWeight,-15} | {langSciWeight,-15} | {mtmWeight,-15} | {disWeight,-15} |";
            return header + new string('-', header.Length - 1) + "\n" + values;
        }
    }
    public class MinGrades
    {
        public MinGrades(string cnMin, string chMin, string lngMin, string mtmMin, string redMin)
        {
            this.natSciMin = cnMin;
            this.hmnSciMin = chMin;
            this.langSciMin = lngMin;
            this.mtmMin = mtmMin;
            this.disMin = redMin;
        }

        public string? natSciMin { get; set; }
        public string? hmnSciMin { get; set; }
        public string? langSciMin { get; set; }
        public string? mtmMin { get; set; }
        public string? disMin { get; set; }
        public override string ToString()
        {
            string header = $"| {"Nota Mínima CN",-20} | {"Nota Mínima CH",-20} | {"Nota Mínima Ling",-20} | {"Nota Mínima Mat",-20} | {"Nota Mínima Red",-20} |\n";
            string values = $"| {natSciMin,-20} | {hmnSciMin,-20} | {langSciMin,-20} | {mtmMin,-20} | {disMin,-20} |";
            return header + new string('-', header.Length - 1) + "\n" + values;
        }
    }

    static void Main(string[] args)
    {
        Console.WriteLine("=============== SISU DATA QUERY ===============\n");
        var options = new ChromeOptions();
        options.AddArgument("--headless");
        IWebDriver driver = new ChromeDriver(options);
        GetIes(driver);

        bool exit = false;
        while (!exit)
        {
            Console.WriteLine("\nEscolha uma opção:");
            Console.WriteLine("1. Procurar por instituição");
            Console.WriteLine("2. Sair");
            Console.Write("Opção: ");
            string choice = Console.ReadLine();

            switch (choice)
            {
                case "1":
                    SearchInstitution(driver);
                    break;
                case "2":
                    exit = true;
                    break;
                default:
                    Console.WriteLine("Opção inválida. Tente novamente.");
                    break;
            }
        }

        driver.Quit();
    }

    public static void SearchInstitution(IWebDriver driver)
    {
        Console.WriteLine("\n**INSIRA A SIGLA DA INSTITUIÇÃO DESEJADA:");
        string siglaIes = Console.ReadLine();
        Institution selectedInstitution = null;

        foreach (Institution i in listInstitutions)
        {
            if (siglaIes.ToUpper().Trim() == i.institutionSg)
            {
                selectedInstitution = i;
                Console.WriteLine(new string('-', 120));
                Console.WriteLine($"| {"Código",-10} | {"Sigla",-15} | {"Nome",-columnWidth} | {"Município",-25} |");
                Console.WriteLine(new string('-', 120));
                Console.WriteLine(i);
                Console.WriteLine(new string('-', 120));
                Console.WriteLine("\nProcurando cursos da instituição...\n");
                getCourses(driver, i.institutionCode);
                break;
            }
        }

        if (selectedInstitution != null)
        {
            SearchCourse(driver);
        }
        else
        {
            Console.WriteLine("Instituição não encontrada.");
        }
    }

    public static void SearchCourse(IWebDriver driver)
    {
        Console.WriteLine("\n**INSIRA O CÓDIGO DO CURSO:");
        string courseCode = Console.ReadLine();
        course = null;

        foreach (Course c in listIesCourses)
        {
            if (courseCode.Trim() == c.courseCode)
            {
                course = c;
                Console.WriteLine(new string('-', 160));
                Console.WriteLine($"| {"Código",-10} | {"Nome",-columnWidth} | {"Grau",-20} | {"Turno",-15} | {"Campus",-30} | {"Município",-25} |");
                Console.WriteLine(new string('-', 160));
                Console.WriteLine(c);
                Console.WriteLine(new string('-', 160));
                Console.WriteLine("\nRecolhendo informações do curso...\n");
                getCourseWeights(driver, course.offerCode);
                getMinGrades(driver, course.offerCode);
                break;
            }
        }

        if (course == null)
        {
            Console.WriteLine("Curso não encontrado.");
        }
    }

    public static void GetIes(IWebDriver driver)
    {
        driver.Navigate().GoToUrl("https://sisu-api.sisu.mec.gov.br/api/v1/oferta/instituicoes/uf");
        System.Threading.Thread.Sleep(2000);
        var htmlContent = driver.PageSource;
        var htmlDocument = new HtmlDocument();
        htmlDocument.LoadHtml(htmlContent);
        var preNode = htmlDocument.DocumentNode.SelectSingleNode("//pre");

        if (preNode != null)
        {
            var jsonContent = preNode.InnerText;
            var data = JsonConvert.DeserializeObject<Dictionary<string, object>>(jsonContent);

            foreach (var state in data)
            {
                var stateValue = state.Value?.ToString();

                if (stateValue != null)
                {
                    var institutions = JsonConvert.DeserializeObject<List<Dictionary<string, string>>>(stateValue);

                    foreach (var institution in institutions)
                    {
                        var coIes = institution.GetValueOrDefault("co_ies");
                        var sgIes = institution.GetValueOrDefault("sg_ies");
                        var noIes = institution.GetValueOrDefault("no_ies");
                        var noMunicipio = institution.GetValueOrDefault("no_municipio");

                        if (coIes != null && noIes != null && sgIes != null && noMunicipio != null)
                        {
                            Institution _institution = new Institution(coIes, sgIes, noIes, noMunicipio);
                            listInstitutions.Add(_institution);
                        }
                    }
                }
            }
        }
        else
        {
            Console.WriteLine("Não foi encontrado o elemento <pre> no HTML.");
        }
    }
    public static void getCourses(IWebDriver driver, string iesCode)
    {
        listIesCourses.Clear();
        driver.Navigate().GoToUrl($"https://sisu-api.sisu.mec.gov.br/api/v1/oferta/instituicao/{iesCode}");
        System.Threading.Thread.Sleep(2000);
        var htmlContent = driver.PageSource;
        var htmlDocument = new HtmlDocument();
        htmlDocument.LoadHtml(htmlContent);
        var preNode = htmlDocument.DocumentNode.SelectSingleNode("//pre");

        if (preNode != null)
        {
            var jsonContent = preNode.InnerText;
            var cleanedJsonContent = CleanJson(jsonContent);

            if (!string.IsNullOrEmpty(cleanedJsonContent))
            {
                var data = JsonConvert.DeserializeObject<Dictionary<string, object>>(cleanedJsonContent);
                data.Remove("search_rule");

                Console.WriteLine(new string('-', 160));
                Console.WriteLine($"| {"Código",-10} | {"Nome",-columnWidth} | {"Grau",-20} | {"Turno",-15} | {"Campus",-30} | {"Município",-25} |");
                Console.WriteLine(new string('-', 160));

                for (int i = 0; i < data.Count; i++)
                {
                    var courseKey = i.ToString();
                    if (data.ContainsKey(courseKey))
                    {
                        var courseValue = data[courseKey]?.ToString();

                        if (courseValue != null)
                        {
                            var courseDetails = JsonConvert.DeserializeObject<Dictionary<string, string>>(courseValue);

                            var coOferta = courseDetails.GetValueOrDefault("co_oferta");
                            var coCurso = courseDetails.GetValueOrDefault("co_curso");
                            var noCurso = courseDetails.GetValueOrDefault("no_curso");
                            var noGrau = courseDetails.GetValueOrDefault("no_grau");
                            var noTurno = courseDetails.GetValueOrDefault("no_turno");
                            var noCampus = courseDetails.GetValueOrDefault("no_campus");
                            var noMunicipioCampus = courseDetails.GetValueOrDefault("no_municipio_campus");

                            if (coCurso != null && noCurso != null && noTurno != null && noCampus != null && noMunicipioCampus != null)
                            {
                                Course _course = new Course(coOferta, coCurso, noCurso, noGrau, noTurno, noCampus, noMunicipioCampus);
                                listIesCourses.Add(_course);
                                Console.WriteLine(_course);
                            }
                        }
                    }
                }
                Console.WriteLine(new string('-', 160));
            }
        }
    }
    public static void getCourseWeights(IWebDriver driver, string offerCode)
    {
        driver.Navigate().GoToUrl($"https://sisu-api.sisu.mec.gov.br/api/v1/oferta/{offerCode}/modalidades");
        System.Threading.Thread.Sleep(2000);
        var htmlContent = driver.PageSource;
        var htmlDocument = new HtmlDocument();
        htmlDocument.LoadHtml(htmlContent);
        var preNode = htmlDocument.DocumentNode.SelectSingleNode("//pre");
        if (preNode != null)
        {
            var jsonContent = preNode.InnerText;
            var cleanedJsonContent = CleanJson(jsonContent);
            if (!string.IsNullOrEmpty(cleanedJsonContent))
            {
                var data = JsonConvert.DeserializeObject<Dictionary<string, object>>(cleanedJsonContent);
                if (data.ContainsKey("oferta"))
                {
                    var oferta = data["oferta"] as JObject;
                    if (oferta != null)
                    {
                        var nuPesoCn = oferta["nu_peso_cn"]?.ToString();
                        var nuPesoCh = oferta["nu_peso_ch"]?.ToString();
                        var nuPesoL = oferta["nu_peso_l"]?.ToString();
                        var nuPesoM = oferta["nu_peso_m"]?.ToString();
                        var nuPesoR = oferta["nu_peso_r"]?.ToString();

                        courseWeights = new CourseWeights(nuPesoCn, nuPesoCh, nuPesoL, nuPesoM, nuPesoR);
                        Console.WriteLine("Pesos:");
                        Console.WriteLine(courseWeights);

                    }
                }
            }
        }
    }
    public static void getMinGrades(IWebDriver driver, string offerCode)
    {
        driver.Navigate().GoToUrl($"https://sisu-api.sisu.mec.gov.br/api/v1/oferta/{offerCode}/modalidades");
        System.Threading.Thread.Sleep(2000);
        var htmlContent = driver.PageSource;
        var htmlDocument = new HtmlDocument();
        htmlDocument.LoadHtml(htmlContent);
        var preNode = htmlDocument.DocumentNode.SelectSingleNode("//pre");
        if (preNode != null)
        {
            var jsonContent = preNode.InnerText;
            var cleanedJsonContent = CleanJson(jsonContent);
            if (!string.IsNullOrEmpty(cleanedJsonContent))
            {
                var data = JsonConvert.DeserializeObject<Dictionary<string, object>>(cleanedJsonContent);
                if (data.ContainsKey("oferta"))
                {
                    var oferta = data["oferta"] as JObject;
                    if (oferta != null)
                    {
                        var nMinCn = oferta["nu_nmin_cn"]?.ToString();
                        var nMinCh = oferta["nu_nmin_ch"]?.ToString();
                        var nMinL = oferta["nu_nmin_l"]?.ToString();
                        var nMinM = oferta["nu_nmin_m"]?.ToString();
                        var nMinR = oferta["nu_nmin_r"]?.ToString();

                        minGrades = new MinGrades(nMinCn, nMinCh, nMinL, nMinM, nMinR);
                        Console.WriteLine("\nNotas Mínimas:");
                        Console.WriteLine(minGrades);
                    }
                }
            }
        }
    }
    public static string CleanJson(string jsonContent)
    {
        var trimmedJson = jsonContent.Trim();

        if (trimmedJson.EndsWith(","))
        {
            trimmedJson = trimmedJson.Substring(0, trimmedJson.Length - 1);
        }
        return trimmedJson;
    }
}