public async Task <IActionResult> PutUserrole(int id, Userrole userrole)
{
if (id != userrole.Id)
{
return(BadRequest());
}
_context.Entry(userrole).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!UserroleExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ActionResult <Userrole> > PostUserrole(Userrole userrole)
{
_context.Userrole.Add(userrole);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetUserrole", new { id = userrole.Id }, userrole));
}
public async Task <Role> AddNewRole(string userId, string Id)
{
try
{
Userrole userrole = new Userrole {
RoleId = Id, UserId = userId
};
var role = db.Role.Where(O => O.Id == Id).FirstOrDefault();
if (role != null)
{
db.Userrole.Add(userrole);
await db.SaveChangesAsync();
return(role);
}
else
{
throw new SystemException("Role Tidak Ditemukan");
}
}
catch (Exception ex)
{
throw new SystemException(ex.Message);
}
}
/// <summary>
/// 添加人员 角色关联
/// </summary>
/// <param name="uid"></param>
/// <param name="role"></param>
/// <returns></returns>
public int AddUserrole(int uid, int[] role)
{
List <Userrole> rplist = new List <Userrole>();
for (int i = 0; i < role.Length; i++)
{
Userrole rp = new Userrole();
rp.UserId = uid;
rp.RoleId = role[i];
rplist.Add(rp);
}
db.Userrole.AddRange(rplist);
//db.Database.ExecuteSqlCommand("insert into rolepower(Role_Id,Power_Id) values(@RoleId,@RolePowerId)", rplist);
return(db.SaveChanges());
}
public async Task <bool> RemoveRole(string userId, string roleId)
{
try
{
Userrole userrole = db.Userrole.Where(x => x.RoleId == roleId && x.UserId == userId).FirstOrDefault();
if (userrole != null)
{
db.Userrole.Remove(userrole);
await db.SaveChangesAsync();
return(true);
}
else
{
throw new SystemException("Role Tidak Ditemukan");
}
}
catch (Exception ex)
{
throw new SystemException(ex.Message);
}
}
/// <summary>
/// 修改人员角色
/// </summary>
/// <param name="user"></param>
/// <param name="role"></param>
/// <returns></returns>
public int UpdateUser(User user, int[] role)
{
var tmpUser = db.User.Where(m => m.UserId == user.UserId).FirstOrDefault();
if (tmpUser != null)
{
tmpUser.UserRealName = user.UserRealName;
tmpUser.User_IdentityId = user.User_IdentityId;
tmpUser.UserRoleName = user.UserRoleName;
db.Database.ExecuteSqlCommand($"DELETE from Userrole where User_Id={user.UserId}");
List <Userrole> rplist = new List <Userrole>();
for (int i = 0; i < role.Length; i++)
{
Userrole rp = new Userrole();
rp.UserId = user.UserId;
rp.RoleId = role[i];
rplist.Add(rp);
}
db.Userrole.AddRange(rplist);
return(db.SaveChanges());
}
return(0);
}
/// <summary>
/// 添加角色
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public int AddUser(AddUser adduser)
{
User user = new User();
user.UserId = adduser.UserId;
user.UserName = adduser.UserName;
user.UserPass = adduser.UserPass;
user.UserRealName = adduser.UserRealName;
user.UserRoleName = adduser.UserRoleName;
user.UserIsEnable = adduser.UserIsEnable;
user.UserCreateTime = adduser.UserCreateTime;
Userrole userrole = new Userrole();
db.User.Add(user);
var query = db.SaveChanges();
userrole.UserId = user.UserId;
userrole.RoleId = adduser.userRoleid;
db.Userrole.Add(userrole);
db.SaveChanges();
return(query);
}
public bool IsAuthorized()
{
return(Userrole.IsAuthorized());
}
public void Update(User userParam, string password = null, List <string> departments = null, List <string> roles = null)
{
var user = GetById(userParam.UserId);
if (user == null)
{
throw new AppException("User not found");
}
if (userParam.UserName != user.UserName)
{
// username has changed so check if the new username is already taken
if (_context.User.Any(x => x.UserName == userParam.UserName))
{
throw new AppException("Username " + userParam.UserName + " is already taken");
}
}
// update user properties
user.FirstName = !string.IsNullOrEmpty(userParam.FirstName) ? userParam.FirstName : user.FirstName;
user.LastName = !string.IsNullOrEmpty(userParam.LastName) ? userParam.LastName : user.LastName;
user.UserName = !string.IsNullOrEmpty(userParam.UserName) ? userParam.UserName : user.UserName;
user.MobileNumber = userParam.MobileNumber.HasValue ? userParam.MobileNumber.Value : user.MobileNumber;
user.UserStatusId = userParam.UserStatusId.HasValue ? userParam.UserStatusId.Value : user.UserStatusId;
user.ModfiedDate = System.DateTime.Now;
// update password if it was entered
if (!string.IsNullOrWhiteSpace(password))
{
byte[] passwordHash, passwordSalt;
CreatePasswordHash(password, out passwordHash, out passwordSalt);
user.PasswordHash = passwordHash;
user.PasswordSalt = passwordSalt;
}
if (departments != null && departments.Count > 0)
{
foreach (string department in departments)
{
var dept = _context.Department.Where(r => r.DepartmentName.Equals(department, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (dept != null)
{
Userdepartment userDept = new Userdepartment();
userDept.UserId = user.UserId;
userDept.DepartmentId = dept.DepartmentId;
if (user.Userdepartment == null)
{
user.Userdepartment = new List <Userdepartment> {
userDept
};
}
else if (!user.Userdepartment.Any(d => d.DepartmentId == dept.DepartmentId))
{
user.Userdepartment.Add(userDept);
}
}
}
}
if (roles != null && roles.Count > 0)
{
foreach (string roleName in roles)
{
var role = _context.Role.Where(r => r.RoleName.Equals(roleName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (role != null)
{
Userrole userRole = new Userrole();
userRole.RoleId = role.RoleId;
userRole.UserId = user.UserId;
if (user.Userrole == null)
{
user.Userrole = new List <Userrole> {
userRole
};
}
else if (!user.Userrole.Any(r => r.RoleId == role.RoleId))
{
user.Userrole.Add(userRole);
}
}
}
}
_context.User.Update(user);
_context.SaveChanges();
}
public User Create(User user, string password, UserDto userDto)
{
// validation
if (string.IsNullOrWhiteSpace(password))
{
throw new AppException("Password is required");
}
User userDBObj = _context.User.Where(x => x.UserName == user.UserName).FirstOrDefault();
if (userDBObj != null)
{
throw new AppException("Username \"" + user.UserName + "\" is already taken");
}
byte[] passwordHash, passwordSalt;
CreatePasswordHash(password, out passwordHash, out passwordSalt);
user.PasswordHash = passwordHash;
user.PasswordSalt = passwordSalt;
user.UserStatusId = (int)UserStatus.Deactived;
user.IsVerified = 0;
user.UniqueId = Guid.NewGuid().ToString();
_context.User.Add(user);
_context.SaveChanges();
if (userDto.Department != null && userDto.Department.Count > 0)
{
foreach (string department in userDto.Department)
{
var dept = _context.Department.Where(r => r.DepartmentName.Equals(department, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (dept != null)
{
Userdepartment userDept = new Userdepartment();
userDept.UserId = user.UserId;
userDept.DepartmentId = dept.DepartmentId;
user.Userdepartment = new List <Userdepartment> {
userDept
};
}
}
}
if (userDto.Role != null && userDto.Role.Count > 0)
{
foreach (string roleName in userDto.Role)
{
var role = _context.Role.Where(r => r.RoleName.Equals(roleName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
if (role != null)
{
Userrole userRole = new Userrole();
userRole.RoleId = role.RoleId;
userRole.UserId = user.UserId;
user.Userrole = new List <Userrole> {
userRole
};
}
}
}
Institution institution = null;
if (userDto.InstitutionId > 0)
{
institution = _context.Institution.Where(i => i.InstitutionId == userDto.InstitutionId).FirstOrDefault();
}
else if (!string.IsNullOrEmpty(userDto.InstitutionName))
{
institution = _context.Institution.Where(i => i.InstitutionName.Contains(userDto.InstitutionName, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
}
else if (!string.IsNullOrEmpty(userDto.InstitutionUrl))
{
institution = _context.Institution.Where(i => i.InstitutionUrl.Contains(userDto.InstitutionUrl, StringComparison.OrdinalIgnoreCase)).FirstOrDefault();
}
Userinstitution userIns = new Userinstitution();
userIns.UserId = user.UserId;
userIns.InstitutionId = institution.InstitutionId;
user.Userinstitution = new List <Userinstitution> {
userIns
};
_context.User.Update(user);
_context.SaveChanges();
return(user);
}
public static bool IsAuthorized(this Userrole role)
{
return(role == Userrole.Owner || role == Userrole.NormalUser);
}
public int test(Userrole userrole)
{
return(1);
}
public Task <ActionResult <Userrole> > PostUserRole(Userrole userrole)
{
throw new NotImplementedException();
}
