private void listViewRealEstateSet_House_SelectedIndexChanged(object sender, EventArgs e) { if (listViewRealEstateSet_House.SelectedItems.Count == 1) { Недвижимость realEstate = listViewRealEstateSet_House.SelectedItems[0].Tag as Недвижимость; textBoxAddress_City.Text = realEstate.Address_City; textBoxAddress_Number.Text = realEstate.Address_House; textBoxAddress_House.Text = realEstate.Address_Number; textBoxAddress_Street.Text = realEstate.Address_Street; textBoxCoordinate_latitude.Text = realEstate.Coordinate_latitude.ToString(); textBoxCoordinate_longitude.Text = realEstate.Coordinate_longitude.ToString(); textBoxTotalArea.Text = realEstate.TotalArea.ToString(); textBoxTotalFloors.Text = realEstate.TotalFloors.ToString(); } else { textBoxAddress_City.Text = ""; textBoxAddress_Number.Text = ""; textBoxAddress_House.Text = ""; textBoxAddress_Street.Text = ""; textBoxCoordinate_latitude.Text = ""; textBoxCoordinate_longitude.Text = ""; textBoxTotalArea.Text = ""; textBoxTotalFloors.Text = ""; } }
private void buttonEdit_Click(object sender, EventArgs e) { if (comboBoxType.SelectedIndex == 0) { if (listViewRealEstateSet_Apartment.SelectedItems.Count == 1) { Недвижимость realEstate = listViewRealEstateSet_Apartment.SelectedItems[0].Tag as Недвижимость; realEstate.Address_City = textBoxAddress_City.Text; realEstate.Address_House = textBoxAddress_Number.Text; realEstate.Address_Street = textBoxAddress_Street.Text; realEstate.Address_Number = textBoxAddress_House.Text; realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text); realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text); realEstate.TotalArea = Convert.ToDouble(textBoxTotalArea.Text); realEstate.Rooms = Convert.ToInt32(textBoxRooms.Text); realEstate.Floor = Convert.ToInt32(textBoxFloor.Text); Program.wftDb.SaveChanges(); ShowRealEstateSet(); } } if (comboBoxType.SelectedIndex == 1) { if (listViewRealEstateSet_House.SelectedItems.Count == 1) { Недвижимость realEstate = listViewRealEstateSet_House.SelectedItems[0].Tag as Недвижимость; realEstate.Address_City = textBoxAddress_City.Text; realEstate.Address_House = textBoxAddress_Number.Text; realEstate.Address_Street = textBoxAddress_Street.Text; realEstate.Address_Number = textBoxAddress_House.Text; realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text); realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text); realEstate.TotalArea = Convert.ToDouble(textBoxTotalArea.Text); realEstate.TotalFloors = Convert.ToInt32(textBoxTotalFloors.Text); Program.wftDb.SaveChanges(); ShowRealEstateSet(); } } else { if (listViewRealEstateSet_Land.SelectedItems.Count == 1) { Недвижимость realEstate = listViewRealEstateSet_Land.SelectedItems[0].Tag as Недвижимость; realEstate.Address_City = textBoxAddress_City.Text; realEstate.Address_House = textBoxAddress_Number.Text; realEstate.Address_Street = textBoxAddress_Street.Text; realEstate.Address_Number = textBoxAddress_House.Text; realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text); realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text); realEstate.TotalArea = Convert.ToDouble(textBoxTotalArea.Text); Program.wftDb.SaveChanges(); ShowRealEstateSet(); } } }
private void buttonAdd_Click(object sender, EventArgs e) { try { Недвижимость realEstate = new Недвижимость(); realEstate.Address_City = textBoxAddress_City.Text; realEstate.Address_House = textBoxAddress_Number.Text; realEstate.Address_Street = textBoxAddress_Street.Text; realEstate.Address_Number = textBoxAddress_House.Text; realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text); realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text); realEstate.TotalArea = Convert.ToDouble(textBoxTotalArea.Text); if (realEstate.Coordinate_latitude > 90 || realEstate.Coordinate_latitude < -90) { throw new Exception("Значение широты должно быть не меньше -90 и не больше 90"); } if (realEstate.Coordinate_longitude > 180 || realEstate.Coordinate_longitude < -180) { throw new Exception("Значение долготы должно быть не меньше -180 и не больше 180"); } if (comboBoxType.SelectedIndex == 0) { realEstate.Type = 0; realEstate.Rooms = Convert.ToInt32(textBoxRooms.Text); realEstate.Floor = Convert.ToInt32(textBoxFloor.Text); } else if (comboBoxType.SelectedIndex == 1) { realEstate.Type = 1; realEstate.TotalFloors = Convert.ToInt32(textBoxTotalFloors.Text); } else { realEstate.Type = 2; } Program.wftDb.Недвижимость.Add(realEstate); Program.wftDb.SaveChanges(); ShowRealEstateSet(); } catch (Exception re) { MessageBox.Show("" + re.Message, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonDel_Click(object sender, EventArgs e) { try { if (comboBoxType.SelectedIndex == 0) { if (listViewRealEstateSet_Apartment.SelectedItems.Count == 1) { Недвижимость realEstate = listViewRealEstateSet_Apartment.SelectedItems[0].Tag as Недвижимость; Program.wftDb.Недвижимость.Remove(realEstate); Program.wftDb.SaveChanges(); ShowRealEstateSet(); } textBoxAddress_City.Text = ""; textBoxAddress_Number.Text = ""; textBoxAddress_House.Text = ""; textBoxAddress_Street.Text = ""; textBoxCoordinate_latitude.Text = ""; textBoxCoordinate_longitude.Text = ""; textBoxTotalArea.Text = ""; textBoxRooms.Text = ""; textBoxFloor.Text = ""; } else if (comboBoxType.SelectedIndex == 1) { if (listViewRealEstateSet_House.SelectedItems.Count == 1) { Недвижимость realEstate = listViewRealEstateSet_House.SelectedItems[0].Tag as Недвижимость; Program.wftDb.Недвижимость.Remove(realEstate); Program.wftDb.SaveChanges(); ShowRealEstateSet(); } textBoxAddress_City.Text = ""; textBoxAddress_Number.Text = ""; textBoxAddress_House.Text = ""; textBoxAddress_Street.Text = ""; textBoxCoordinate_latitude.Text = ""; textBoxCoordinate_longitude.Text = ""; textBoxTotalArea.Text = ""; textBoxTotalFloors.Text = ""; } else { if (listViewRealEstateSet_Land.SelectedItems.Count == 1) { Недвижимость realEstate = listViewRealEstateSet_Land.SelectedItems[0].Tag as Недвижимость; Program.wftDb.Недвижимость.Remove(realEstate); Program.wftDb.SaveChanges(); ShowRealEstateSet(); } textBoxAddress_City.Text = ""; textBoxAddress_Number.Text = ""; textBoxAddress_House.Text = ""; textBoxAddress_Street.Text = ""; textBoxCoordinate_latitude.Text = ""; textBoxCoordinate_longitude.Text = ""; textBoxTotalArea.Text = ""; } } catch { MessageBox.Show("Невозможно удалить, эта запись используется!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }