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