/// <summary>
/// 根据条件获取所有角色
/// </summary>
/// <param name="request">请求条件</param>
/// <returns></returns>
public EasyUIGrid GetAllRoles(EasyUIGridRequest request)
{
int total = 0;
return(new EasyUIGrid()
{
rows = ViewModelRole.ToListViewModel(GetAllRoles(request, ref total)),
total = total
});
}
// GET: Roles/Edit/5
public IActionResult Edit(int id)
{
var role = _unitOfWork.RoleRepository.GetById(id);
if (role == null)
{
return(NotFound());
}
ViewModelRole vmRole = new ViewModelRole
{
Name = role.Name,
Id = role.Id
};
return(View(vmRole));
}
public IActionResult Create(/*[Bind("Id,Name")]*/ ViewModelRole role)
{
var r = new Role
{
Id = role.Id,
Name = role.Name
};
if (ModelState.IsValid)
{
_unitOfWork.RoleRepository.Insert(r);
_unitOfWork.Save();
return(RedirectToAction(nameof(Index)));
}
return(View(role));
}
public IActionResult Edit(ViewModelRole vmRole)
{
var roletoedit = _unitOfWork.RoleRepository.GetById(vmRole.Id);
roletoedit.Name = vmRole.Name;
//
if (ModelState.IsValid)
{
_unitOfWork.RoleRepository.Update(roletoedit);
_unitOfWork.Save();
return(RedirectToAction(nameof(Index)));
}
return(RedirectToAction(nameof(Index)));
}
public List <ViewModelRole> GetRolesByUserId(string id)
{
List <ViewModelRole> lst = new List <ViewModelRole>();
try
{
SqlParameter[] param = { new SqlParameter("@flag", SqlDbType.VarChar, 50)
{
Value = "fetch-userroles"
}
, new SqlParameter("@id", SqlDbType.NVarChar, 128)
{
Value = id
}
, new SqlParameter("@user", SqlDbType.NVarChar, 128)
{
Value = SessionHelper.GetUserID()
} };
DataTable result = SqlHelper.ExecuteDataTable("spUserProfile", param);
if (result != null && result.Rows.Count > 0)
{
foreach (DataRow drow in result.Rows)
{
ViewModelRole obj = new ViewModelRole();
obj.RoleId = Convert.ToString(drow["RoleId"]);
obj.RoleName = Convert.ToString(drow["RoleName"]);
obj.IsAssigned = drow["UserId"] != DBNull.Value ? true : false;
lst.Add(obj);
}
}
}
catch (Exception ex)
{
throw;
}
return(lst);
}
// GET: Roles/Details/5
public IActionResult Details(int id)
{
var role = _unitOfWork.RoleRepository.GetRoleWithItsUsersById(id);
ViewModelRole vmRole = new ViewModelRole
{
Name = role.Name,
Id = role.Id,
Users = role.Users.Select(u => new ViewModelUser
{
Id = u.Id,
FirstName = u.FirstName,
LastName = u.LastName,
UserName = u.UserName
}).ToList()
};
if (role == null)
{
return(NotFound());
}
return(View(vmRole));
}
