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 btnDelete_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
int userID = int.Parse(listViewUser.Items[listViewUser.SelectedIndices[0]].SubItems[0].Text);
tblUser oldUser = entity.tblUsers.Where(x => x.ID == userID).FirstOrDefault();
entity.tblUsers.Remove(oldUser);
entity.SaveChanges();
MessageBox.Show("User Deleted");
}
private void btnSave_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
tblRole role = new Condominium_Management_System.tblRole();
role.Title = txtTitle.Text;
entity.tblRoles.Add(role);
entity.SaveChanges();
MessageBox.Show("Role Saved");
}
private void btnSave_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
tblUserRole userRole = new Condominium_Management_System.tblUserRole();
userRole.UserID = int.Parse(cboUser.SelectedValue.ToString());
userRole.RoleID = int.Parse(cboRole.SelectedValue.ToString());
entity.tblUserRoles.Add(userRole);
entity.SaveChanges();
MessageBox.Show("User Role Saved");
}
private void btnSave_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
tblUser user = new Condominium_Management_System.tblUser();
user.Fullname = txtFullname.Text;
user.Username = txtUsername.Text;
user.Password = txtPassword.Text;
entity.tblUsers.Add(user);
entity.SaveChanges();
MessageBox.Show("User Saved");
}
private void btnUpdate_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
int roleID = int.Parse(listViewRole.Items[listViewRole.SelectedIndices[0]].SubItems[0].Text);
tblRole oldRole = entity.tblRoles.Where(x => x.ID == roleID).FirstOrDefault();
tblRole newRole = new Condominium_Management_System.tblRole();
newRole.ID = roleID;
newRole.Title = txtTitle.Text;
entity.Entry(oldRole).CurrentValues.SetValues(newRole);
entity.SaveChanges();
MessageBox.Show("Role Updated");
}
private void btnUpdate_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
int userID = int.Parse(listViewUser.Items[listViewUser.SelectedIndices[0]].SubItems[0].Text);
tblUser oldUser = entity.tblUsers.Where(x => x.ID == userID).FirstOrDefault();
tblUser newUser = new Condominium_Management_System.tblUser();
newUser.ID = userID;
newUser.Fullname = txtFullname.Text;
newUser.Username = txtUsername.Text;
newUser.Password = txtPassword.Text;
entity.Entry(oldUser).CurrentValues.SetValues(newUser);
entity.SaveChanges();
MessageBox.Show("User Updated");
}