private void btnDelete_Click(object sender, EventArgs e) { CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities(); int userRoleID = int.Parse(listViewUserRole.Items[listViewUserRole.SelectedIndices[0]].SubItems[0].Text); tblUserRole oldUserRole = entity.tblUserRoles.Where(x => x.ID == userRoleID).FirstOrDefault(); entity.tblUserRoles.Remove(oldUserRole); entity.SaveChanges(); MessageBox.Show("User Role Deleted"); }
private void btnUpdate_Click(object sender, EventArgs e) { CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities(); int userRoleID = int.Parse(listViewUserRole.Items[listViewUserRole.SelectedIndices[0]].SubItems[0].Text); tblUserRole oldUserRole = entity.tblUserRoles.Where(x => x.ID == userRoleID).FirstOrDefault(); tblUserRole newUserRole = new Condominium_Management_System.tblUserRole(); newUserRole.ID = userRoleID; newUserRole.UserID = int.Parse(cboUser.SelectedValue.ToString()); newUserRole.RoleID = int.Parse(cboRole.SelectedValue.ToString()); entity.Entry(oldUserRole).CurrentValues.SetValues(newUserRole); entity.SaveChanges(); MessageBox.Show("User Role Updated"); }