private void ListViewRealEstateSet_Land_SelectedIndexChanged(object sender, EventArgs e)
{
//если выбран один элемент
if (listViewRealEstateSet_Land.SelectedItems.Count == 1)
{
//ищем элемент из таблицы по тегу
RealEstateSet realEstate = listViewRealEstateSet_Land.SelectedItems[0].Tag as RealEstateSet;
//указываем, что может быть изменено
textBoxAddress_City.Text = realEstate.Address_City;
textBoxAddress_Street.Text = realEstate.Address_Street;
textBoxAddress_House.Text = realEstate.Adress_House;
textBoxAddress_Number.Text = realEstate.Address_Number;
textBoxCoordinate_latitude.Text = realEstate.Coordinate_latitude.ToString();
textBoxCoordinate_longitude.Text = realEstate.Coordinate_longitude.ToString();
textBoxTotalArea.Text = realEstate.TotalArea.ToString();
}
else
{
//если не выбран ни один элемент, задаём пустые поля
textBoxAddress_City.Text = "";
textBoxAddress_House.Text = "";
textBoxAddress_Street.Text = "";
textBoxAddress_Number.Text = "";
textBoxCoordinate_latitude.Text = "";
textBoxCoordinate_longitude.Text = "";
textBoxTotalArea.Text = "";
}
}
private void listViewRealEstateSet_House_SelectedIndexChanged(object sender, EventArgs e)
{
//если выбран 1 элемент
if (listViewRealEstateSet_House.SelectedItems.Count == 1)
{
RealEstateSet realEstate = listViewRealEstateSet_House.SelectedItems[0].Tag as RealEstateSet;
textBoxAddress_City.Text = realEstate.Address_City;
textBoxAddress_Street.Text = realEstate.Address_Street;
textBoxAddress_House.Text = realEstate.Address_House;
textBoxAddress_Number.Text = realEstate.Address_Number;
textBoxCoordinate_latitude.Text = realEstate.Coordinate_latitude.ToString();
textBoxCoordinate_longitude.Text = realEstate.Coordinate_longitude.ToString();
textBoxTotalArea.Text = realEstate.TotalArea.ToString();
textBoxTotalFloors.Text = realEstate.Floor.ToString();
}
else // если не выбран ни один элемент
{
textBoxAddress_City.Text = "";
textBoxAddress_Street.Text = "";
textBoxAddress_House.Text = "";
textBoxAddress_Number.Text = "";
textBoxCoordinate_latitude.Text = "";
textBoxCoordinate_longitude.Text = "";
textBoxTotalArea.Text = "";
textBoxTotalFloors.Text = "";
}
}
private void buttonDel_Click(object sender, EventArgs e)
{
try
{
if (comboBoxType.SelectedIndex == 0)
{
if (listViewRealEstateSet_Apartment.SelectedItems.Count == 1)
{
RealEstateSet realEstate = listViewRealEstateSet_Apartment.SelectedItems[0].Tag as RealEstateSet;
Program.esoft_Project.RealEstateSet.Remove(realEstate);
Program.esoft_Project.SaveChanges();
ShowRealEstateSet();
}
textBoxAddress_City.Text = "";
textBoxAddress_Street.Text = "";
textBoxAddress_House.Text = "";
textBoxAddress_Number.Text = "";
textBoxCoordinate_latitude.Text = "";
textBoxCoordinate_longitude.Text = "";
textBoxTotalArea.Text = "";
textBoxRooms.Text = "";
textBoxFloor.Text = "";
}
else if (comboBoxType.SelectedIndex == 1)
{
if (listViewRealEstateSet_House.SelectedItems.Count == 1)
{
RealEstateSet realEstate = listViewRealEstateSet_House.SelectedItems[0].Tag as RealEstateSet;
Program.esoft_Project.RealEstateSet.Remove(realEstate);
Program.esoft_Project.SaveChanges();
ShowRealEstateSet();
}
textBoxAddress_City.Text = "";
textBoxAddress_Street.Text = "";
textBoxAddress_House.Text = "";
textBoxAddress_Number.Text = "";
textBoxCoordinate_latitude.Text = "";
textBoxCoordinate_longitude.Text = "";
textBoxTotalArea.Text = "";
textBoxTotalFloors.Text = "";
}
else
{
if (listViewRealEstateSet_Land.SelectedItems.Count == 1)
{
RealEstateSet realEstate = listViewRealEstateSet_Land.SelectedItems[0].Tag as RealEstateSet;
Program.esoft_Project.RealEstateSet.Remove(realEstate);
Program.esoft_Project.SaveChanges();
ShowRealEstateSet();
}
}
}
catch
{
MessageBox.Show("Невозможно удалить, эта запись используется!", "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ButtonAdd_Click(object sender, EventArgs e)
{
//Создаём новый экземпляр класса "Объект недвижимости"
RealEstateSet realEstate = new RealEstateSet();
// Делаем ссылку на объект, который хранится в textBox-ax (сначала общие поля)
realEstate.Address_City = textBoxAddress_City.Text;
realEstate.Adress_House = textBoxAddress_House.Text;
realEstate.Address_Street = textBoxAddress_Street.Text;
realEstate.Address_Number = textBoxAddress_Number.Text;
realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text);
realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text);
realEstate.TotalArea = Convert.ToDouble(textBoxTotalArea.Text);
//Дополнительные поля для типа "Квартира"
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;
}
//Добавляем в таблицу RealEstateSet новый объект недвижимости realEstate
Program.wftDb.RealEstateSet.Add(realEstate);
//Сохраняем изменения в модели wftDb
Program.wftDb.SaveChanges();
ShowRealEstateSet();
}
private void buttonEdit_Click(object sender, EventArgs e)
{
//выбран тип "Квартира", работа с listViewRealEstateSet_Apartment
if (comboBoxType.SelectedIndex == 0)
{
//если в listView выбран элемент
if (listViewRealEstateSet_Apartment.SelectedItems.Count == 1)
{
//Ищем элементы из таблицы по тегу
RealEstateSet realEstate = listViewRealEstateSet_Apartment.SelectedItems[0].Tag as RealEstateSet;
//указываем что может быть изменено
realEstate.Address_City = textBoxAddress_City.Text;
realEstate.Address_House = textBoxAddress_House.Text;
realEstate.Address_Street = textBoxAddress_Street.Text;
realEstate.Address_Number = textBoxAddress_Number.Text;
if (textBoxCoordinate_latitude.Text != "")
{
realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text);
}
else
{
realEstate.Coordinate_latitude = null;
}
if (realEstate.Coordinate_latitude < -90)
{
realEstate.Coordinate_latitude = -90;
textBoxCoordinate_latitude.Text = "-90";
}
if (realEstate.Coordinate_latitude > 90)
{
realEstate.Coordinate_latitude = 90;
textBoxCoordinate_latitude.Text = "90";
}
if (textBoxCoordinate_longitude.Text != "")
{
realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text);
}
else
{
realEstate.Coordinate_longitude = null;
}
if (realEstate.Coordinate_longitude < -180)
{
realEstate.Coordinate_longitude = -180;
textBoxCoordinate_longitude.Text = "-180";
}
if (realEstate.Coordinate_longitude > 180)
{
realEstate.Coordinate_longitude = 180;
textBoxCoordinate_longitude.Text = "180";
}
if (textBoxTotalArea.Text != "")
{
realEstate.TotalArea = Convert.ToDouble(textBoxTotalArea.Text);
}
else
{
realEstate.TotalArea = null;
}
if (textBoxRooms.Text != "")
{
realEstate.Rooms = Convert.ToInt32(textBoxRooms.Text);
}
else
{
realEstate.Rooms = null;
}
if (textBoxFloor.Text != "")
{
realEstate.Floor = Convert.ToInt32(textBoxFloor.Text);
}
else
{
realEstate.Floor = null;
}
//save
Program.esoft_Project.SaveChanges();
//отображаем в listViewRealEstateSet_Apartment
ShowRealEstateSet();
}
}
//выбран тип "Дом"
else if (comboBoxType.SelectedIndex == 1)
{
//если в listView выбран элемент
if (listViewRealEstateSet_House.SelectedItems.Count == 1)
{
//ищем по тегу
RealEstateSet realEstate = listViewRealEstateSet_House.SelectedItems[0].Tag as RealEstateSet;
//указываем, что может быть изменено
realEstate.Address_City = textBoxAddress_City.Text;
realEstate.Address_House = textBoxAddress_House.Text;
realEstate.Address_Street = textBoxAddress_Street.Text;
realEstate.Address_Number = textBoxAddress_Number.Text;
if (textBoxCoordinate_latitude.Text != "")
{
realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text);
}
else
{
realEstate.Coordinate_latitude = null;
}
if (realEstate.Coordinate_latitude < -90)
{
realEstate.Coordinate_latitude = -90;
textBoxCoordinate_latitude.Text = "-90";
}
if (realEstate.Coordinate_latitude > 90)
{
realEstate.Coordinate_latitude = 90;
textBoxCoordinate_latitude.Text = "90";
}
if (textBoxCoordinate_longitude.Text != "")
{
realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text);
}
else
{
realEstate.Coordinate_longitude = null;
}
if (realEstate.Coordinate_longitude < -180)
{
realEstate.Coordinate_longitude = -180;
textBoxCoordinate_longitude.Text = "-180";
}
if (realEstate.Coordinate_longitude > 180)
{
realEstate.Coordinate_longitude = 180;
textBoxCoordinate_longitude.Text = "180";
}
if (textBoxTotalArea.Text != "")
{
realEstate.TotalArea = Convert.ToDouble(textBoxTotalArea.Text);
}
else
{
realEstate.TotalArea = null;
}
if (textBoxTotalFloors.Text != "")
{
realEstate.TotalFloors = Convert.ToInt32(textBoxTotalFloors.Text);
}
else
{
realEstate.TotalFloors = null;
}
//save
Program.esoft_Project.SaveChanges();
ShowRealEstateSet();
}
}
else
{
if (listViewRealEstateSet_Land.SelectedItems.Count == 1)
{
RealEstateSet realEstate = listViewRealEstateSet_Land.SelectedItems[0].Tag as RealEstateSet;
realEstate.Address_City = textBoxAddress_City.Text;
realEstate.Address_House = textBoxAddress_House.Text;
realEstate.Address_Street = textBoxAddress_Street.Text;
realEstate.Address_Number = textBoxAddress_Number.Text;
if (textBoxCoordinate_latitude.Text != "")
{
realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text);
}
else
{
realEstate.Coordinate_latitude = null;
}
if (realEstate.Coordinate_latitude < -90)
{
realEstate.Coordinate_latitude = -90;
textBoxCoordinate_latitude.Text = "-90";
}
if (realEstate.Coordinate_latitude > 90)
{
realEstate.Coordinate_latitude = 90;
textBoxCoordinate_latitude.Text = "90";
}
if (textBoxCoordinate_longitude.Text != "")
{
realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text);
}
else
{
realEstate.Coordinate_longitude = null;
}
if (realEstate.Coordinate_longitude < -180)
{
realEstate.Coordinate_longitude = -180;
textBoxCoordinate_longitude.Text = "-180";
}
if (realEstate.Coordinate_longitude > 180)
{
realEstate.Coordinate_longitude = 180;
textBoxCoordinate_longitude.Text = "180";
}
if (textBoxTotalArea.Text != "")
{
realEstate.TotalArea = Convert.ToDouble(textBoxTotalArea.Text);
}
else
{
realEstate.TotalArea = null;
}
Program.esoft_Project.SaveChanges();
ShowRealEstateSet();
}
}
}
private void buttonAdd_Click(object sender, EventArgs e)
{
//создаем новый экземпляр класса "Объект недвижимости"
RealEstateSet realEstate = new RealEstateSet();
//делаем ссылку на объект, который хранится в textBox-ах
realEstate.Address_City = textBoxAddress_City.Text;
realEstate.Address_House = textBoxAddress_House.Text;
realEstate.Address_Street = textBoxAddress_Street.Text;
realEstate.Address_Number = textBoxAddress_Number.Text;
if (textBoxCoordinate_latitude.Text != "")
{
realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text);
}
if (realEstate.Coordinate_latitude < -90)
{
realEstate.Coordinate_latitude = -90;
textBoxCoordinate_latitude.Text = "-90";
}
if (realEstate.Coordinate_latitude > 90)
{
realEstate.Coordinate_latitude = 90;
textBoxCoordinate_latitude.Text = "90";
}
if (textBoxCoordinate_longitude.Text != "")
{
realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text);
}
if (realEstate.Coordinate_longitude < -180)
{
realEstate.Coordinate_longitude = -180;
textBoxCoordinate_longitude.Text = "-180";
}
if (realEstate.Coordinate_longitude > 180)
{
realEstate.Coordinate_longitude = 180;
textBoxCoordinate_longitude.Text = "180";
}
if (textBoxTotalArea.Text != "")
{
realEstate.TotalArea = Convert.ToDouble(textBoxTotalArea.Text);
}
//дополнительные поля для типа "Квартира"
if (comboBoxType.SelectedIndex == 0)
{
realEstate.Type = 0;
if (textBoxRooms.Text != "")
{
realEstate.Rooms = Convert.ToInt32(textBoxRooms.Text);
}
;
if (textBoxFloor.Text != "")
{
realEstate.Floor = Convert.ToInt32(textBoxFloor.Text);
}
}
//дополнительные поля для типа "Дом"
else if (comboBoxType.SelectedIndex == 1)
{
realEstate.Type = 1;
if (textBoxTotalFloors.Text != "")
{
realEstate.TotalFloors = Convert.ToInt32(textBoxTotalFloors.Text);
}
}
//дополнительные поля для типа "Земля"
else
{
realEstate.Type = 2;
}
//добавляем в таблицу RealEstateSet новый объект недвижимости realEstate
Program.esoft_Project.RealEstateSet.Add(realEstate);
//сохраняем изменения
Program.esoft_Project.SaveChanges();
ShowRealEstateSet();
}
private void ButtonDel_Click(object sender, EventArgs e)
{
//попробуем совершить действие
try
{
//выбран тип "Квартира", работа с listViewRealEstateSet_Apartment
if (comboBoxType.SelectedIndex == 0)
{
//если в listView выбран элемент
if (listViewRealEstateSet_Apartment.SelectedItems.Count == 1)
{
//ищем этот эелмент в базе по тегу
RealEstateSet realEstate = listViewRealEstateSet_Apartment.SelectedItems[0].Tag as RealEstateSet;
//удаляем из модели базы данных
Program.wftDb.RealEstateSet.Remove(realEstate);
//сохраняем изменения
Program.wftDb.SaveChanges();
//отображаем обновлённый список
ShowRealEstateSet();
}
//очищаем текстовые поля
textBoxAddress_City.Text = "";
textBoxAddress_House.Text = "";
textBoxAddress_Street.Text = "";
textBoxAddress_Number.Text = "";
textBoxCoordinate_latitude.Text = "";
textBoxCoordinate_longitude.Text = "";
textBoxTotalArea.Text = "";
textBoxRooms.Text = "";
textBoxFloor.Text = "";
}
else if (comboBoxType.SelectedIndex == 1)
{
//если в listView выбран элемент
if (listViewRealEstateSet_House.SelectedItems.Count == 1)
{
//ищем этот элемент в базе по тегу
RealEstateSet realEstate = listViewRealEstateSet_House.SelectedItems[0].Tag as RealEstateSet;
//удаляем из модели базы данных
Program.wftDb.RealEstateSet.Remove(realEstate);
//сохраняем изменения
Program.wftDb.SaveChanges();
//отображаем обновлённый список
ShowRealEstateSet();
}
//очищаем текстовые поля
textBoxAddress_City.Text = "";
textBoxAddress_House.Text = "";
textBoxAddress_Street.Text = "";
textBoxAddress_Number.Text = "";
textBoxCoordinate_latitude.Text = "";
textBoxCoordinate_longitude.Text = "";
textBoxTotalArea.Text = "";
textBoxTotalFloors.Text = "";
}
//выбрпан тип "Земля", работа с listViewRealEstateSet_Land
else
{
//если в listView выбран элемент
if (listViewRealEstateSet_Land.SelectedItems.Count == 1)
{
//ищем этот элемент базе по тегу
RealEstateSet realEstate = listViewRealEstateSet_Land.SelectedItems[0].Tag as RealEstateSet;
//удаляем из модели базы данных
Program.wftDb.RealEstateSet.Remove(realEstate);
//сохраняем изменения
Program.wftDb.SaveChanges();
//отображаем обновлённый список
ShowRealEstateSet();
}
//очищаем текстовые поля
textBoxAddress_City.Text = "";
textBoxAddress_House.Text = "";
textBoxAddress_Street.Text = "";
textBoxAddress_Number.Text = "";
textBoxCoordinate_latitude.Text = "";
textBoxCoordinate_longitude.Text = "";
}
}
//если возникает какая-то ошибка
catch
{
MessageBox.Show("Невозможно удалить, эта запись используется", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void ButtonEdit_Click(object sender, EventArgs e)
{
//выбран тип "квартира", работа с listViewRealEstateSet_Apartment
if (comboBoxType.SelectedIndex == 0)
{
//если в listView выбран элементы
if (listViewRealEstateSet_Apartment.SelectedItems.Count == 1)
{
//Ищем элемент из таблицы по тегу
RealEstateSet realEstate = listViewRealEstateSet_Apartment.SelectedItems[0].Tag as RealEstateSet;
//указываем, что может быть изменено
realEstate.Address_City = textBoxAddress_City.Text;
realEstate.Adress_House = textBoxAddress_House.Text;
realEstate.Address_Street = textBoxAddress_Street.Text;
realEstate.Address_Number = textBoxAddress_Number.Text;
realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text);
realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text);
realEstate.TotalArea = Convert.ToInt32(textBoxRooms.Text);
realEstate.Floor = Convert.ToInt32(textBoxFloor.Text);
//сохраняем изменения в модели wftDb
Program.wftDb.SaveChanges();
//отображаем в listViewRealEstateSet_Apartment
ShowRealEstateSet();
}
//выбран тип "Дом", работа с listViewRealEstateSet_House
else if (comboBoxType.SelectedIndex == 1)
{
//если в listView выбран элемент
if (listViewRealEstateSet_House.SelectedItems.Count == 1)
{
//Ищем элемент из таблицы по тегу
RealEstateSet realEstate = listViewRealEstateSet_House.SelectedItems[0].Tag as RealEstateSet;
//указываем, что может быть изменено
realEstate.Address_City = textBoxAddress_City.Text;
realEstate.Adress_House = textBoxAddress_House.Text;
realEstate.Address_Street = textBoxAddress_Street.Text;
realEstate.Address_Number = textBoxAddress_Number.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);
//сохраняем изменения в модели wftDb
Program.wftDb.SaveChanges();
//отображаем в listViewRealEstateSet_House
ShowRealEstateSet();
}
}
//Выбран тип "Земля", работа с listViewRealEstateSet_Land
else
{
//если в listView выбран элемент
if (listViewRealEstateSet_Land.SelectedItems.Count == 1)
{
//Ишем элемент из таблицы по тегу
RealEstateSet realEstate = listViewRealEstateSet_Land.SelectedItems[0].Tag as RealEstateSet;
//указываем, что может быть изменено
realEstate.Address_City = textBoxAddress_City.Text;
realEstate.Adress_House = textBoxAddress_House.Text;
realEstate.Address_Street = textBoxAddress_Street.Text;
realEstate.Address_Number = textBoxAddress_Number.Text;
realEstate.Coordinate_latitude = Convert.ToDouble(textBoxCoordinate_latitude.Text);
realEstate.Coordinate_longitude = Convert.ToDouble(textBoxCoordinate_longitude.Text);
realEstate.TotalArea = Convert.ToDouble(textBoxTotalArea.Text);
//сохраняем изменения в модели wftDb
Program.wftDb.SaveChanges();
//отображаем в listViewRealEstateSet_House
ShowRealEstateSet();
}
}
}
}
