private void toolStripButtonMuacaAdd_Click(object sender, EventArgs e) { FormMuaca formMuaca = new FormMuaca(); DialogResult result = formMuaca.ShowDialog(this); if (result == DialogResult.Cancel) { return; } Regional_Council muaca = new Regional_Council(); int muaca_ezorit_code; bool converted = Int32.TryParse(formMuaca.textBoxMuacaCode.Text, out muaca_ezorit_code); if (converted == false) { return; } muaca.Regional_Council_Code = muaca_ezorit_code; muaca.Regional_Council_Name = formMuaca.textBoxMuacaName.Text; db.Regional_Councils.Add(muaca); db.SaveChanges(); MessageBox.Show("New object added"); }
private void toolStripButtonMuacaEdit_Click(object sender, EventArgs e) { if (dataGridViewMuacot.SelectedRows.Count > 0) { int index = dataGridViewMuacot.SelectedRows[0].Index; int muaca_ezorit_code; bool converted = Int32.TryParse(dataGridViewMuacot[0, index].Value.ToString(), out muaca_ezorit_code); if (converted == false) { return; } Regional_Council muaca = db.Regional_Councils.Find(muaca_ezorit_code); FormMuaca formMuaca = new FormMuaca(); formMuaca.textBoxMuacaCode.Text = muaca.Regional_Council_Code.ToString(); formMuaca.textBoxMuacaName.Text = muaca.Regional_Council_Name; formMuaca.textBoxMuacaCode.Enabled = false; DialogResult result = formMuaca.ShowDialog(this); if (result == DialogResult.Cancel) { return; } muaca.Regional_Council_Name = formMuaca.textBoxMuacaName.Text; db.SaveChanges(); dataGridViewMuacot.Refresh(); // обновляем грид MessageBox.Show("Object updated"); } }
private void toolStripButtonMuacaRemove_Click(object sender, EventArgs e) { if (dataGridViewMuacot.SelectedRows.Count > 0) { int index = dataGridViewMuacot.SelectedRows[0].Index; int muaca_ezorit_code = 0; bool converted = Int32.TryParse(dataGridViewMuacot[0, index].Value.ToString(), out muaca_ezorit_code); if (converted == false) { return; } Regional_Council muaca = db.Regional_Councils.Find(muaca_ezorit_code); db.Regional_Councils.Remove(muaca); db.SaveChanges(); MessageBox.Show("Object removed"); } }
private static void LoadCitiesFromXmlByXmlDocument(string fileName) { XmlDocument xmlDocument = new XmlDocument(); List <Country_Region> regions = new List <Country_Region>(); List <Lishkat_Mana> lishkot = new List <Lishkat_Mana>(); List <Regional_Council> muacot = new List <Regional_Council>(); List <City> cities = new List <City>(); SplashScreen.SetStatus("Loading XML " + fileName); xmlDocument.Load(fileName); SplashScreen.SetStatus(fileName + " XML Loaded"); SplashScreen.SetStatus("Parsing XML"); foreach (XmlNode node in xmlDocument.DocumentElement) { //foreach (XmlNode child in node.ChildNodes) //{ // //} Country_Region region = new Country_Region { Country_Region_Code = int.Parse(node.ChildNodes[4].InnerText), Country_Region_Name = node.ChildNodes[5].InnerText.Trim() }; if (!regions.Exists(x => x.Country_Region_Code == region.Country_Region_Code)) { regions.Add(region); } Lishkat_Mana lishka = new Lishkat_Mana { Lishkat_Mana_Code = int.Parse(node.ChildNodes[6].InnerText), Lishkat_Mana_Name = node.ChildNodes[7].InnerText.Trim() }; if (!lishkot.Exists(x => x.Lishkat_Mana_Code == lishka.Lishkat_Mana_Code)) { lishkot.Add(lishka); } Regional_Council muaca = new Regional_Council { Regional_Council_Code = int.Parse(node.ChildNodes[8].InnerText), Regional_Council_Name = node.ChildNodes[9].InnerText.Trim() }; if (!muacot.Exists(x => x.Regional_Council_Code == muaca.Regional_Council_Code)) { muacot.Add(muaca); } City city = new City { //Table = node.ChildNodes[0].InnerText, City_Code = int.Parse(node.ChildNodes[1].InnerText), City_Name = node.ChildNodes[2].InnerText.Trim(), City_Name_En = node.ChildNodes[3].InnerText.Trim(), Country_Region_Code = int.Parse(node.ChildNodes[4].InnerText), //Region_name = node.ChildNodes[5].InnerText, Lishkat_Mana_Code = int.Parse(node.ChildNodes[6].InnerText), //Lishka_Name = node.ChildNodes[7].InnerText, Regional_Council_Code = int.Parse(node.ChildNodes[8].InnerText), //Muaca_Izorit_Name = node.ChildNodes[9].InnerText }; if (!cities.Exists(x => x.City_Code == city.City_Code)) { cities.Add(city); } /* * if (db.Country_Regions.Find(region.Country_Region_Code) == null) * db.Country_Regions.Add(region); * //db.SaveChanges(); * * if (db.Lishkot_Mana.Find(lishka.Lishkat_Mana_Code) == null) * db.Lishkot_Mana.Add(lishka); * //db.SaveChanges(); * * if (muaca.Regional_Council_Code != 0 || db.Regional_Councils.Find(muaca.Regional_Council_Code) == null) * db.Regional_Councils.Add(muaca); * //db.SaveChanges(); * * if (db.Cities.Find(city.City_Code) == null) * db.Cities.Add(city); * //db.SaveChanges(); */ } SplashScreen.SetStatus("XML Parsed"); SplashScreen.SetStatus("Conecting to db"); using (WorldGeoDataDB db = new WorldGeoDataDB()) { SplashScreen.SetStatus("Ading data to DB"); SplashScreen.SetStatus("Ading regions"); db.Country_Regions.AddRange(regions); db.SaveChanges(); SplashScreen.SetStatus("Country_Regions Added"); SplashScreen.SetStatus("Ading lishkot"); db.Lishkot_Mana.AddRange(lishkot); db.SaveChanges(); SplashScreen.SetStatus("Lishkot_Mana Added"); SplashScreen.SetStatus("Ading muacot"); db.Regional_Councils.AddRange(muacot); db.SaveChanges(); SplashScreen.SetStatus("Muacot Added"); SplashScreen.SetStatus("Ading cities"); db.Cities.AddRange(cities); db.SaveChanges(); SplashScreen.SetStatus("Cities Added"); } }