private void CreateProtocol(object selectedItems) { IList items = (IList)selectedItems; List <Device> devices = new List <Device>(items.Cast <Device>()); for (int i = 0; i < devices.Count(); i++) { ScannedDevices.Remove(devices[i]); } items.Clear(); Protocol protocol = new Protocol { Tester = Tester, DateTime = DateTime.Now, Devices = new ObservableCollection <Device>(devices) }; context.Attach(protocol); context.SaveChanges(); //context.Entry(protocol.Devices).State = EntityState.Detached; Services.Excel.Export.ProtocolToXlsx(ProtocolPath, protocol); }
public T Delete(int id, string netid) { var delete = System.Activator.CreateInstance <T>(); delete.Id = id; delete.Deleted = true; delete.DateUpdated = now; delete.UpdatedBy = netid; var entity = _context.Attach(delete); entity.Property(x => x.Deleted).IsModified = true; entity.Property(x => x.UpdatedBy).IsModified = true; entity.Property(x => x.DateUpdated).IsModified = true; return(entity.Entity); }
public async Task <IActionResult> Edit(int id, RolePermissionViewModel role_permissions) { if (id != role_permissions.Role.id) { return(NotFound()); } if (role_permissions.Permissions == null) { return(NotFound()); } var role = new sys_role() { id = role_permissions.Role.id, //usercode = role_permissions.Role.usercode, rolename = role_permissions.Role.rolename }; _context.Attach(role); _context.Entry(role).CurrentValues.SetValues(role_permissions.Role); var web_role_permission = _context.sys_role_permission.Where(x => x.sys_role_id == id); _context.sys_role_permission.RemoveRange(web_role_permission); List <sys_role_permission> role_permission_list = new List <sys_role_permission>(); var permissions = role_permissions.Permissions; if (permissions.Count() > 0) { foreach (var item in permissions) { if (item.Selected == true) { role_permission_list.Add( new sys_role_permission() { sys_role_id = id, sys_permission_id = item.permission_id } ); } } } _context.AddRange(role_permission_list); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!sys_roleExists(role_permissions.Role.id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); }
public async Task <IActionResult> Edit(int id, UserRoleViewModel user_roles) { if (id != user_roles.User.id) { return(NotFound()); } if (user_roles.Roles == null) { return(NotFound()); } if (user_roles.User.password == null) { var user = new sys_user() { id = user_roles.User.id, usercode = user_roles.User.usercode, password = user_roles.User.password }; _context.Attach(user); _context.Entry(user).CurrentValues.SetValues(user_roles.User); } else { var user = new sys_user() { id = user_roles.User.id, usercode = user_roles.User.usercode }; var password_hash = PasswordHash(user_roles.User.password); user_roles.User.password = password_hash; _context.Attach(user); _context.Entry(user).CurrentValues.SetValues(user_roles.User); //_context.Update(user_roles.User); } var web_user_role = _context.sys_user_role.Where(x => x.sys_user_id == id); _context.sys_user_role.RemoveRange(web_user_role); List <sys_user_role> user_role_list = new List <sys_user_role>(); var roles = user_roles.Roles; if (roles.Count() > 0) { foreach (var item in roles) { if (item.Selected == true) { user_role_list.Add( new sys_user_role() { sys_user_id = id, sys_role_id = item.role_id } ); } } } _context.AddRange(user_role_list); try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!sys_userExists(user_roles.User.id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); }