private void BtnHouse_Click(object sender, EventArgs e) { try { Button btn = sender as Button; int houseID = int.Parse(btn.Tag.ToString()); House house = houseAccess.GetHouseByID(houseID); HouseHost houseHost = hostAccess.GetHostByID((int)house.HouseHostID); txtHouseNo.Tag = house.HouseID.ToString(); txtHouseNo.Text = house.HouseNo; txtHouseFloor.Text = house.HouseFloor; txtHostName.Tag = houseHost.HostID.ToString(); txtHostName.Text = houseHost.HostName; txtHostLastName.Text = houseHost.HostLastName; txtHostPhone.Text = houseHost.HostPhone; txtHostTC.Text = houseHost.HostTC; pbHouse.Visible = false; btnSaveHouse.Text = "Güncelle"; lblHouseText.Text = "Daire Bilgileri Güncelleniyor."; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void NewHost(HouseHost houseHost) { using (db = new ApartmentAutomationEntities()) { db.HouseHost.Add(houseHost); db.SaveChanges(); } }
public void UpdateHost(HouseHost houseHost) { using (db = new ApartmentAutomationEntities()) { HouseHost hostToUpdate = db.HouseHost.FirstOrDefault(hh => hh.HostID == houseHost.HostID); hostToUpdate.HostName = houseHost.HostName; hostToUpdate.HostLastName = houseHost.HostLastName; hostToUpdate.HostPhone = houseHost.HostPhone; hostToUpdate.HostTC = houseHost.HostTC; hostToUpdate.HostIsRemoved = false; db.SaveChanges(); } }
private void btnSaveHouse_Click(object sender, EventArgs e) { try { if (txtHostName.Text == string.Empty || txtHostLastName.Text == string.Empty || txtHostPhone.Text == string.Empty || txtHostTC.Text == string.Empty || txtHouseNo.Text == string.Empty || txtHouseFloor.Text == string.Empty) { throw new Exception("Tüm alanları doldurmalısınız."); } if (btnSaveHouse.Text == "Ekle") // Yeni Daire Ekleme { HouseHost houseHost = new HouseHost() { HostName = txtHostName.Text, HostLastName = txtHostLastName.Text, HostPhone = txtHostPhone.Text, HostTC = txtHostTC.Text, HostIsRemoved = false }; hostAccess.NewHost(houseHost); houseAccess.NewHouse(new House() { HouseNo = txtHouseNo.Text, HouseFloor = txtHouseFloor.Text, HouseHostID = houseHost.HostID }); MessageBox.Show("Yeni Daire Eklendi."); pbHouse.Visible = true; FillHousesToFlpHouses(); } else // Daire Bilgilerinin Güncellenmesi { hostAccess.UpdateHost(new HouseHost() { HostID = int.Parse(txtHouseNo.Tag.ToString()), HostName = txtHostName.Text, HostLastName = txtHostLastName.Text, HostPhone = txtHostPhone.Text, HostTC = txtHostTC.Text, HostIsRemoved = false }); houseAccess.UpdateHouse(new House() { HouseID = int.Parse(txtHouseNo.Tag.ToString()), HouseNo = txtHouseNo.Text, HouseFloor = txtHouseFloor.Text, HouseHostID = int.Parse(txtHouseNo.Tag.ToString()) }); MessageBox.Show("Daire Bilgileri GÜncellendi."); pbHouse.Visible = true; FillHousesToFlpHouses(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }