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);
}
}
