private void toolStripButtonLishkaAdd_Click(object sender, EventArgs e) { FormLishka formLishka = new FormLishka(); DialogResult result = formLishka.ShowDialog(this); if (result == DialogResult.Cancel) { return; } Lishkat_Mana lishka = new Lishkat_Mana(); int lishkat_mana_code; bool converted = Int32.TryParse(formLishka.textBoxLishkaCode.Text, out lishkat_mana_code); if (converted == false) { return; } lishka.Lishkat_Mana_Code = lishkat_mana_code; lishka.Lishkat_Mana_Name = formLishka.textBoxLishkaName.Text; db.Lishkot_Mana.Add(lishka); db.SaveChanges(); MessageBox.Show("New object added"); }
private void toolStripButtonLishkaEdit_Click(object sender, EventArgs e) { if (dataGridViewLishkot.SelectedRows.Count > 0) { int index = dataGridViewLishkot.SelectedRows[0].Index; int lishkat_mana_code; bool converted = Int32.TryParse(dataGridViewLishkot[0, index].Value.ToString(), out lishkat_mana_code); if (converted == false) { return; } Lishkat_Mana lishka = db.Lishkot_Mana.Find(lishkat_mana_code); FormLishka formLishka = new FormLishka(); formLishka.textBoxLishkaCode.Text = lishka.Lishkat_Mana_Code.ToString(); formLishka.textBoxLishkaName.Text = lishka.Lishkat_Mana_Name; formLishka.textBoxLishkaCode.Enabled = false; DialogResult result = formLishka.ShowDialog(this); if (result == DialogResult.Cancel) { return; } lishka.Lishkat_Mana_Name = formLishka.textBoxLishkaName.Text; db.SaveChanges(); dataGridViewLishkot.Refresh(); // обновляем грид MessageBox.Show("Object updated"); } }
private void toolStripButtonLishkaRemove_Click(object sender, EventArgs e) { if (dataGridViewLishkot.SelectedRows.Count > 0) { int index = dataGridViewLishkot.SelectedRows[0].Index; int lishkat_mana_code = 0; bool converted = Int32.TryParse(dataGridViewLishkot[0, index].Value.ToString(), out lishkat_mana_code); if (converted == false) { return; } Lishkat_Mana lishka = db.Lishkot_Mana.Find(lishkat_mana_code); db.Lishkot_Mana.Remove(lishka); 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"); } }