private void Update_Click(object sender, RoutedEventArgs e)
{
try
{
Entities db = new Entities();
db.apartments.Load();
var ap = Convert.ToInt64(UpdateId.Text);
apartments Apart = db.apartments.Where(p => p.Id == ap).FirstOrDefault();
if (AACU.Text != "")
{
Apart.Address_City = AACU.Text;
}
if (AAHU.Text != "")
{
Apart.Address_House = AAHU.Text;
}
if (AANU.Text != "")
{
Apart.Address_Number = AANU.Text;
}
if (AASU.Text != "")
{
Apart.Address_Street = AASU.Text;
}
if (AClU.Text != "")
{
Apart.Coordinate_latitude = AClU.Text;
}
if (ACloU.Text != "")
{
Apart.Coordinate_longitude = ACloU.Text;
}
if (AFU.Text != "")
{
Apart.Floor = AFU.Text;
}
if (ARU.Text != "")
{
Apart.Rooms = ARU.Text;
}
if (ATaU.Text != "")
{
Apart.TotalArea = ATaU.Text;
}
db.SaveChanges();
}
catch
{
}
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
try
{
Entities db = new Entities();
db.apartments.Load();
var ap = Convert.ToInt64(DeleteId.Text);
apartments dl = db.apartments.Where(p => p.Id == ap).FirstOrDefault();
db.apartments.Remove(dl);
db.SaveChanges();
}
catch
{
}
}
private void Update_ClickH(object sender, RoutedEventArgs e)
{
Entities db = new Entities();
db.apartments.Load();
var ap = Convert.ToInt64(UpdateId.Text);
apartments Apart = db.apartments.Where(p => p.Id == ap).FirstOrDefault();
if (HAcU.Text != "")
{
Apart.Address_City = HAcU.Text;
}
if (HAhU.Text != "")
{
Apart.Address_House = HAhU.Text;
}
if (HAnU.Text != "")
{
Apart.Address_Number = HAnU.Text;
}
if (HAsU.Text != "")
{
Apart.Address_Street = HAsU.Text;
}
if (HClU.Text != "")
{
Apart.Coordinate_latitude = HClU.Text;
}
if (HCloU.Text != "")
{
Apart.Coordinate_longitude = HCloU.Text;
}
if (HFU.Text != "")
{
Apart.Floor = HFU.Text;
}
if (HTaU.Text != "")
{
Apart.TotalArea = HTaU.Text;
}
db.SaveChanges();
}
private void Add_Click(object sender, RoutedEventArgs e)
{
try
{
Entities db = new Entities();
db.apartments.Load();
apartments Apart = new apartments();
Apart.Address_City = AAc.Text;
Apart.Address_House = AAh.Text;
Apart.Address_Street = AAs.Text;
Apart.Address_Number = AAn.Text;
Apart.Coordinate_latitude = ACl.Text;
Apart.Coordinate_longitude = AClo.Text;
Apart.Floor = AF.Text;
Apart.Rooms = AR.Text;
Apart.TotalArea = ATa.Text;
db.apartments.Add(Apart);
db.SaveChanges();
}
catch
{
}
}
