private void Add_Apartment_Click(object sender, RoutedEventArgs e)
{
using (ApartmentContext db1 = new ApartmentContext())
{
using (var transaction = db1.Database.BeginTransaction())
{
try
{
var adresses = db1.Adresses;
Adress adress1 = new Adress();
foreach (Adress adr in adresses)
{
if (TextBox_AddApartment.Text == adr.City)
{
adress1 = adr;
}
}
if (adress1 != null)
{
Apartment apart1 = new Apartment(int.Parse(Area.Text), int.Parse(CountRoom.Text), DateTime.Parse(YearsBuilder.Text), TypeMaterial.Text, int.Parse(Floor.Text), adress1);
db1.Apartments.Add(apart1);
db1.SaveChanges();
transaction.Commit();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
transaction.Rollback();
}
}
}
}
private void Add_Adress_Click(object sender, RoutedEventArgs e)
{
using (ApartmentContext db1 = new ApartmentContext())
{
Adress adress1 = new Adress(Country.Text, Town.Text);
db1.Adresses.Add(adress1);
db1.SaveChanges();
}
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
using (ApartmentContext db1 = new ApartmentContext())
{
var apartment = db1.Apartments;
foreach (Apartment apart in apartment)
{
if (int.Parse(TextBox_DeleteId.Text) == apart.Id)
{
db1.Entry(apart).State = EntityState.Deleted;
}
}
db1.SaveChanges();
}
}
private void Add_Changes_Click(object sender, RoutedEventArgs e)
{
using (ApartmentContext db1 = new ApartmentContext())
{
var apartment = db1.Apartments;
foreach (Apartment apart in apartment)
{
if (int.Parse(TextBox_ChangeApartment.Text) == apart.Id)
{
apart.Area = int.Parse(Area.Text);
apart.CountRoom = int.Parse(CountRoom.Text);
apart.YearsBuilder = DateTime.Parse(YearsBuilder.Text);
apart.TypeMaterial = TypeMaterial.Text;
apart.Floor = int.Parse(Floor.Text);
db1.Entry(apart).State = EntityState.Modified;
}
}
db1.SaveChanges();
}
}