public void ReadAdressFile() { string text = System.IO.File.ReadAllText(@"C:\Users\GodOfWar\Desktop\db.sql"); text = text.Replace("\n", ""); text = text.Replace("'", ""); string[] CRC = text.Split(new string[] { "INSERT INTO" }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < CRC.Length; i++) { CRC[i] = CRC[i].Split(new string[] { "VALUES" }, StringSplitOptions.RemoveEmptyEntries)[1]; } using (var context = new EstablishmentContext()) { string[] cities = CRC[0].Split(new string[] { ")," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < cities.Length; i++) { string[] element = cities[i].Split(new string[] { "," }, StringSplitOptions.None); element[0] = element[0].Replace("(", ""); City city = new City() { Id_City = int.Parse(element[0].Replace(" ", "")), Id_Region = int.Parse(element[1].Replace(" ", "")), Id_Country = int.Parse(element[2].Replace(" ", "")), Name = element[3] != "" ? element[3] : "--" }; context.Cityes.Add(city); } string[] countries = CRC[1].Split(new string[] { ")," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < countries.Length; i++) { string[] element = countries[i].Split(new string[] { "," }, StringSplitOptions.None); element[0] = element[0].Replace("(", ""); Countrie countrie = new Countrie() { Id_Country = int.Parse(element[0].Replace(" ", "")), Name = element[1] != "" ? element[1] : "--" }; context.Countries.Add(countrie); } string[] regions = CRC[2].Split(new string[] { ")," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < regions.Length; i++) { string[] element = regions[i].Split(new string[] { "," }, StringSplitOptions.None); element[0] = element[0].Replace("(", ""); Region region = new Region() { Id_Region = int.Parse(element[0].Replace(" ", "")), Id_Country = int.Parse(element[1].Replace(" ", "")), Name = element[2] != "" ? element[2] : "--" }; context.Regions.Add(region); } context.SaveChanges(); } }
private void buttonRemoveEstablishment_Click(object sender, EventArgs e) { using (var context = new EstablishmentContext()) { var establishments = (from es in context.Establishments where es.Number == establishmentId select es).ToArray(); if (establishments.Length == 0) { return; } Establishment establishment = establishments[0]; context.Establishments.Remove(establishment); context.SaveChanges(); DataGridViewEstablishment_Refresh(context); } }
private void buttonAddRoom_Click(object sender, EventArgs e) { using (var context = new EstablishmentContext()) { using (var transaction = context.Database.BeginTransaction()) { try { int placeCount, area; if (textBox3.Text == "" || (!int.TryParse(textBox1.Text, out placeCount) && textBox1.Text == "") || !int.TryParse(textBox2.Text, out area)) { throw new Exception(); } int number, length; if ((length = context.Rooms.ToArray().Length) == 0) { number = 0; } else { number = context.Rooms.ToArray()[length - 1].RoomId; } Room room = new Room() { RoomId = number + 1, EstablishmentId = establishmentId, RoomType = textBox3.Text, PlaceCount = placeCount, Area = area }; context.Rooms.Add(room); context.SaveChanges(); transaction.Commit(); } catch { transaction.Rollback(); } DataGridViewRoom_Refresh(context, establishmentId); } } }
private void buttonAddEstablishment_Click(object sender, EventArgs e) { using (var context = new EstablishmentContext()) { using (var transaction = context.Database.BeginTransaction()) { try { if (textBoxEstablishmentName.Text == "" || comboBoxEstablishmentType.SelectedIndex == -1 || comboBoxCities.SelectedIndex == -1 || textBoxAdress.Text == "") { throw new Exception(); } int number, length; if ((length = context.Establishments.ToArray().Length) == 0) { number = 0; } else { number = context.Establishments.ToArray()[length - 1].Number; } Establishment establishment = new Establishment() { Number = number + 1, EstablishmentName = textBoxEstablishmentName.Text, EstablishmentType = comboBoxEstablishmentType.SelectedItem.ToString(), EstablishmentAdress = "м." + comboBoxCities.SelectedItem.ToString() + " " + textBoxAdress.Text, }; context.Establishments.Add(establishment); context.SaveChanges(); transaction.Commit(); } catch { transaction.Rollback(); } DataGridViewEstablishment_Refresh(context); } } }
private void buttonRemoveRoom_Click(object sender, EventArgs e) { if (dataGridViewRoom.SelectedRows.Count == 0) { return; } using (var context = new EstablishmentContext()) { string roomType = dataGridViewRoom.SelectedRows[0].Cells[0].Value.ToString(); var rooms = (from r in context.Rooms where r.RoomType == roomType select r).ToArray(); if (rooms.Length == 0) { return; } Room room = rooms[0]; context.Rooms.Remove(room); context.SaveChanges(); DataGridViewRoom_Refresh(context, establishmentId); } }