private void button4_Click(object sender, EventArgs e) { using (var fd = new FolderBrowserDialog()) { if (fd.ShowDialog() == System.Windows.Forms.DialogResult.OK && !string.IsNullOrWhiteSpace(fd.SelectedPath)) { textBox1.Text = fd.SelectedPath; } } XmlDocument doc = new XmlDocument(); String value = textBox1.Text; doc.Load(value); XmlNodeList xStores = doc.GetElementsByTagName("tiendas"); XmlNodeList stores = ((XmlElement)xStores[0]).GetElementsByTagName("tienda"); foreach (var item in stores) { Departament departament = new Departament(); XmlNodeList nameDepartament = ((XmlElement)item).GetElementsByTagName("departamento"); foreach (XmlElement nodo in nameDepartament) { departament.name_departament = nodo.InnerText; } departamentLogic.AddDepartament(departament); int idDepartament = departamentLogic.getIdDepartament(departament.name_departament); Municipality municipality = new Municipality(); XmlNodeList nameMunicipality = ((XmlElement)item).GetElementsByTagName("municipio"); foreach (XmlElement nodo in nameMunicipality) { municipality.name_municipality = nodo.InnerText; } municipality.departament.id_departament = idDepartament; municipalityLogic.AddMunicipality(municipality); int idMunicipality = municipalityLogic.getIdMunicipality(municipality.name_municipality); Detail_Ubication detail_Ubication = new Detail_Ubication(); XmlNodeList nameAddress = ((XmlElement)item).GetElementsByTagName("ubicacion"); foreach (XmlElement nodo in nameAddress) { detail_Ubication.address = nodo.InnerText; } detail_Ubication.municipality.id_municipality = idMunicipality; detailLocationLogic.AddDetailUbication(detail_Ubication); int idAddress = detailLocationLogic.getIdMunicipality(detail_Ubication.address); Store store = new Store(); XmlNodeList idsStores = ((XmlElement)item).GetElementsByTagName("id"); XmlNodeList phoneStores = ((XmlElement)item).GetElementsByTagName("telefono"); foreach (XmlElement nodo in idsStores) { store.id_store = Convert.ToInt32(nodo.InnerText); } foreach (XmlElement nodo in phoneStores) { store.phone = nodo.InnerText; } store.detail_ubication.id_detail_ubication = idAddress; if (storeLogic.AddStores(store)) { this.Close(); } } }