private void Button_Click(object sender, RoutedEventArgs e)
{
try
{
using (ModelBD model = new ModelBD())
{
Apartaments apartaments = new Apartaments
{
StreetName = STNameText.Text,
HouseNumber = HousNumText.Text,
ApartamentNumber = int.Parse(APNumText.Text),
SquareApartament = double.Parse(SquareText.Text),
AmountRoom = int.Parse(AmountRoomText.Text),
Price = decimal.Parse(PriceText.Text)
};
model.Apartaments.Add(apartaments);
model.SaveChanges();
MessageBox.Show("Квартира успешно добавлена");
ClearTextBox();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void SaveAP(object sender, RoutedEventArgs e)
{
try
{
using (ModelBD model = new ModelBD())
{
int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault();
int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]);
Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault();
apartament.StreetName = STNameText.Text;
apartament.HouseNumber = HouseNumText.Text;
apartament.ApartamentNumber = int.Parse(APNumText.Text);
apartament.SquareApartament = double.Parse(SquareText.Text);
apartament.AmountRoom = int.Parse(AmountRoomText.Text);
apartament.Price = decimal.Parse(PriceText.Text);
model.Entry(apartament).State = System.Data.Entity.EntityState.Modified;
model.SaveChanges();
SetChangeComboBox(realtors, apartament);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void DeleteAP(object sender, RoutedEventArgs e)
{
try
{
using (ModelBD model = new ModelBD())
{
int idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
Apartaments apartaments = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault();
model.Apartaments.Remove(apartaments);
model.SaveChanges();
int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]);
Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault();
int? idAPart = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
Apartaments apartament = model.Apartaments.Where(p => p.ID == idAPart).FirstOrDefault();
SetChangeComboBox(realtors, apartament);
ClearTextBoxAP();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void APComb_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
if (APComb.SelectedItem != null && FIOComb.SelectedItem != null)
{
using (ModelBD model = new ModelBD())
{
int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault();
STNameText.Text = apartament.StreetName;
HouseNumText.Text = apartament.HouseNumber;
APNumText.Text = apartament.ApartamentNumber.ToString();
SquareText.Text = apartament.SquareApartament.ToString();
AmountRoomText.Text = apartament.AmountRoom.ToString();
PriceText.Text = apartament.Price.ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void SaveAgent(object sender, RoutedEventArgs e)
{
try
{
using (ModelBD model = new ModelBD())
{
int? idComb = int.Parse(FIOComb.SelectedItem.ToString().Split(':')[1]);
Realtors realtors = model.Realtors.Where(p => p.ID == idComb).FirstOrDefault();
int? idAP = int.Parse(APComb.SelectedItem.ToString().Split(':')[1]);
Apartaments apartament = model.Apartaments.Where(p => p.ID == idAP).FirstOrDefault();
realtors.FIO = FIOText.Text;
realtors.Percent = int.Parse(PercentText.Text);
model.Entry(realtors).State = System.Data.Entity.EntityState.Modified;
model.SaveChanges();
SetChangeComboBox(realtors, apartament);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void SetChangeComboBox(Realtors realtors, Apartaments apartament)
{
try
{
APComb.Items.Clear();
FIOComb.Items.Clear();
SetComboBox();
using (ModelBD model = new ModelBD())
{
FIOComb.SelectedItem = realtors.FIO + " - ID: " + realtors.ID;
APComb.SelectedItem = apartament.StreetName + " - ID: " + apartament.ID;
}
}
catch (Exception ex)
{
}
}
