public void loadGrid_Categoric()
        {
            List <AllTowns> listTowns = new List <AllTowns>();
            List <Gmaps_Management.Model.Region> regions = colombia.Regions;

            foreach (Gmaps_Management.Model.Region currentRegion in regions)
            {
                string             region      = currentRegion.name;
                List <Departament> departments = currentRegion.departaments;
                foreach (Departament department in departments)
                {
                    string      nameDepartment = department.name;
                    int         idDept         = department.id;
                    List <Town> towns          = department.towns;
                    foreach (Town town in towns)
                    {
                        int      idTown      = town.id;
                        string   nameTown    = town.nameTown;
                        int      cantPeople  = town.cantPeople;
                        int      cantConfirm = town.cantConfirm;
                        string   covid       = town.covid;
                        double   latitud     = town.latitud;
                        double   longitud    = town.longitud;
                        AllTowns all         = new AllTowns(nameTown, idTown, nameDepartment, idDept, cantPeople, covid, cantConfirm, region, latitud, longitud);
                        listTowns.Add(all);
                    }
                }
            }

            dataGridView1.DataSource = listTowns;
            drawOnMap(listTowns);
        }
        private void cbCategories_SelectedIndexChanged(object sender, EventArgs e)
        {
            int index = cbCategories.SelectedIndex;

            if (index == 6)
            {
                loadGrid_Categoric();
            }
            else
            {
                List <AllTowns>    listTowns   = new List <AllTowns>();
                string             region      = colombia.Regions.ElementAt(index).name;
                List <Departament> departments = colombia.Regions.ElementAt(index).departaments;
                foreach (Departament department in departments)
                {
                    string      nameDepartment = department.name;
                    int         idDept         = department.id;
                    List <Town> towns          = department.towns;
                    foreach (Town town in towns)
                    {
                        int      idTown      = town.id;
                        string   nameTown    = town.nameTown;
                        int      cantPeople  = town.cantPeople;
                        int      cantConfirm = town.cantConfirm;
                        string   covid       = town.covid;
                        double   latitud     = town.latitud;
                        double   longitud    = town.longitud;
                        AllTowns all         = new AllTowns(nameTown, idTown, nameDepartment, idDept, cantPeople, covid, cantConfirm, region, latitud, longitud);
                        listTowns.Add(all);
                    }
                }
                dataGridView1.DataSource = listTowns;
                drawOnMap(listTowns);
            }
        }
        private void search_range_Click(object sender, EventArgs e)
        {
            try
            {
                int menor = Int32.Parse(tb_menor.Text);
                int mayor = Int32.Parse(tb_mayor.Text);
                if (menor > mayor)
                {
                    int aux = menor;
                    menor         = mayor;
                    mayor         = aux;
                    menor         = menor < 0 ? 0 : menor;
                    mayor         = mayor < 0 ? 0 : mayor;
                    tb_menor.Text = menor + "";
                    tb_mayor.Text = mayor + "";
                }

                List <AllTowns> listTowns = new List <AllTowns>();
                List <Gmaps_Management.Model.Region> regions = colombia.Regions;
                foreach (Gmaps_Management.Model.Region currentRegion in regions)
                {
                    string             region      = currentRegion.name;
                    List <Departament> departments = currentRegion.departaments;
                    foreach (Departament department in departments)
                    {
                        int         idDept         = department.id;
                        string      nameDepartment = department.name;
                        List <Town> towns          = department.towns;
                        foreach (Town town in towns)
                        {
                            if (town.cantConfirm >= menor && town.cantConfirm <= mayor)
                            {
                                int      idTown      = town.id;
                                string   nameTown    = town.nameTown;
                                int      cantPeople  = town.cantPeople;
                                int      cantConfirm = town.cantConfirm;
                                string   covid       = town.covid;
                                double   latitud     = town.latitud;
                                double   longitud    = town.longitud;
                                AllTowns all         = new AllTowns(nameTown, idTown, nameDepartment, idDept, cantPeople, covid, cantConfirm, region, latitud, longitud);
                                listTowns.Add(all);
                            }
                        }
                    }
                }
                dataGridView1.DataSource = listTowns;
                drawOnMap(listTowns);
            }
            catch (FormatException t)
            {
                Console.WriteLine(t.Message);
            }
        }
        public Form1()
        {
            Console.WriteLine("Entreee");
            InitializeComponent();
            colombia  = new Country();
            data      = new AllTowns();
            points    = new List <PointLatLng>();
            poligonos = new List <PointLatLng>();

            //Ubicacion del archivo a cargar
            path = @"..\..\Data";
            cbFilter1.Visible    = false;
            cbCategories.Visible = false;
        }
        private void loadGrid()
        {
            try
            {
                var    reader = new StreamReader(File.OpenRead(path));
                string line   = reader.ReadLine();
                line = reader.ReadLine();
                List <AllTowns> towns = new List <AllTowns>();
                while (!string.IsNullOrEmpty(line))
                {
                    try
                    {
                        string[] array           = line.Split(',');
                        string   nameTown        = (array[0]);
                        int      idTown          = Int32.Parse(array[1]);
                        string   nameDepartament = (array[2]);
                        int      idDept          = Int32.Parse(array[3]);
                        int      cantPeople      = Int32.Parse(array[4]);
                        string   covid           = (array[5]);
                        int      cantConfirm     = Int32.Parse(array[6]);
                        string   region          = (array[7]);
                        //Console.WriteLine(array[8]);
                        double latitud = array[8].ElementAt(0).Equals('#') ? 0 : Double.Parse(Regex.Replace(array[8], "[.,]", CultureInfo.CurrentCulture.NumberFormat.NumberDecimalSeparator));
                        //Console.WriteLine(array[8] + " " + latitud);
                        double   longitud = array[9].ElementAt(0).Equals('#') ? 0 : Double.Parse(Regex.Replace(array[9], "[.,]", CultureInfo.CurrentCulture.NumberFormat.NumberDecimalSeparator));
                        AllTowns all      = new AllTowns(nameTown, idTown, nameDepartament, idDept, cantPeople, covid, cantConfirm, region, latitud, longitud);

                        colombia.add(nameTown, idTown, nameDepartament, idDept, cantPeople, covid, cantConfirm, region, latitud, longitud);

                        //Console.WriteLine(all.ToString());

                        towns.Add(all);
                    }
                    catch (FormatException e)
                    {
                        Console.WriteLine(e.Message, "Line is empty");
                    }
                    line = reader.ReadLine();
                }
                dataGridView1.DataSource = towns;
                drawOnMap(towns);
                cbFilter1.Visible = true;
                cb_initialization();
            }
            catch (Exception alm)
            {
                Console.WriteLine(alm.ToString());
            }
        }
        private void button2_Click_2(object sender, EventArgs e)
        {
            string text = textBox1.Text.ToUpper();

            List <AllTowns> listTowns = new List <AllTowns>();
            List <Gmaps_Management.Model.Region> regions = colombia.Regions;

            foreach (Gmaps_Management.Model.Region currentRegion in regions)
            {
                string             region      = currentRegion.name;
                List <Departament> departments = currentRegion.departaments;
                foreach (Departament department in departments)
                {
                    int         idDept         = department.id;
                    string      nameDepartment = department.name;
                    List <Town> towns          = department.towns;
                    foreach (Town town in towns)
                    {
                        if (town.nameTown.Contains(text))
                        {
                            int      idTown      = town.id;
                            string   nameTown    = town.nameTown;
                            int      cantPeople  = town.cantPeople;
                            int      cantConfirm = town.cantConfirm;
                            string   covid       = town.covid;
                            double   latitud     = town.latitud;
                            double   longitud    = town.longitud;
                            AllTowns all         = new AllTowns(nameTown, idTown, nameDepartment, idDept, cantPeople, covid, cantConfirm, region, latitud, longitud);
                            listTowns.Add(all);
                        }
                    }
                }
            }
            dataGridView1.DataSource = listTowns;
            drawOnMap(listTowns);
        }
 public Form2(Country co)
 {
     InitializeComponent();
     Colombia = co;
     data     = new AllTowns();
 }