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;
}
}
