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