private void toolStripButtonSave_Click(object sender, EventArgs e) { try { CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities(); tblHouse house = new tblHouse(); house.RegionID = int.Parse(cboRegion.SelectedValue.ToString()); house.SubCityID = int.Parse(cboSubCity.SelectedValue.ToString()); house.WoredaID = int.Parse(cboWoreda.SelectedValue.ToString()); house.BlockNumber = txtBlockNumber.Text; house.FloorNumber = int.Parse(txtFloorNumber.Text); house.HouseNumber = txtHouseNumber.Text; house.GovernmentTransferedDate = dtpGovernmentTrasferedDate.Value; house.SiteName = txtSiteName.Text; entity.tblHouses.Add(house); entity.SaveChanges(); MessageBox.Show("Saved"); } catch (Exception) { MessageBox.Show("Save Failed"); } }
private void toolStripButtonUpdate_Click(object sender, EventArgs e) { CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities(); int houseId = int.Parse(listViewHouse.Items[listViewHouse.SelectedIndices[0]].SubItems[0].Text); tblHouse oldHouse = entity.tblHouses.Where(x => x.ID == houseId).FirstOrDefault(); tblHouse newHouse = new tblHouse(); newHouse.ID = houseId; newHouse.RegionID = int.Parse(cboRegion.SelectedValue.ToString()); newHouse.SubCityID = int.Parse(cboSubCity.SelectedValue.ToString()); newHouse.WoredaID = int.Parse(cboWoreda.SelectedValue.ToString()); newHouse.BlockNumber = txtBlockNumber.Text; newHouse.FloorNumber = int.Parse(txtFloorNumber.Text); newHouse.HouseNumber = txtHouseNumber.Text; newHouse.GovernmentTransferedDate = dtpGovernmentTrasferedDate.Value; newHouse.SiteName = txtSiteName.Text; entity.Entry(oldHouse).CurrentValues.SetValues(newHouse); entity.SaveChanges(); MessageBox.Show("Updated"); }
private void toolStripButtonDelete_Click(object sender, EventArgs e) { CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities(); int houseId = int.Parse(listViewHouse.Items[listViewHouse.SelectedIndices[0]].SubItems[0].Text); tblHouse oldHouse = entity.tblHouses.Where(x => x.ID == houseId).FirstOrDefault(); entity.tblHouses.Remove(oldHouse); entity.SaveChanges(); MessageBox.Show("Deleted"); }
private void listViewHouse_SelectedIndexChanged(object sender, EventArgs e) { CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities(); if (listViewHouse.SelectedIndices.Count > 0) { int houseId = int.Parse(listViewHouse.Items[listViewHouse.SelectedIndices[0]].SubItems[0].Text); tblHouse house = entity.tblHouses.Where(x => x.ID == houseId).FirstOrDefault(); cboRegion.Text = house.tblRegion.TItle; cboSubCity.Text = house.tblSubCity.TItle; cboWoreda.Text = house.tblWoreda.TItle; txtBlockNumber.Text = house.BlockNumber; txtFloorNumber.Text = house.FloorNumber.ToString(); txtHouseNumber.Text = house.HouseNumber; dtpGovernmentTrasferedDate.Value = house.GovernmentTransferedDate; txtSiteName.Text = house.SiteName; } }