// GET: UserRole
public ActionResult Index()
{
// cho nay lay doi DB
List <usp_AspNetUserRoles_GetList> listDB = new List <usp_AspNetUserRoles_GetList>();
using (var service = new AspNetUserRolesService())
{
listDB = service.GetList();
}
//ListUserRole item = new ListUserRole();
//item.Name = "Test";
//item.UserId = "Tuanpd";
//listDB.Add(item);
//return View(listDB);
var allUsers = db.Users.ToList();
// add dropdownlist userrole
var viewModels = new List <usp_AspNetUser_GetList>();
if (allUsers != null)
{
foreach (var user in allUsers)
{
viewModels.Add(new usp_AspNetUser_GetList {
Id = user.Id, UserName = user.UserName
});
}
}
SelectList selectUsers = new SelectList(viewModels, "Id", "UserName");
ViewBag.userListDb = selectUsers;
// chua toan nhan vien
//ViewBag.ListAllUser = listDB;
//Chua toan bo Role
//ViewBag.ListAllRole = "List All Role";
//foreach (var user in listDB)
//{
// viewModels.Add(new usp_AspNetUser_GetList { Id=user.RoleId, UserName = user.Name});
//}
//SelectList selectRoles = new SelectList(viewModels, "Id", "UserName");
//ViewBag.listRoles = selectRoles;
var Roles = db.Roles.ToList();
var viewModelRoles = new List <usp_AspNetUser_GetList>();
if (Roles != null)
{
foreach (var item in Roles)
{
viewModelRoles.Add(new usp_AspNetUser_GetList {
Id = item.Id, UserName = item.Name
});
}
}
SelectList selectRoles = new SelectList(viewModelRoles, "Id", "UserName");
ViewBag.listRoles = selectRoles;
return(View(listDB));
}
public JsonResult Delete(string userId, string roleId)
{
// chua viet gi
//service Call DB
int?result = null;
using (var service = new AspNetUserRolesService())
{
result = service.DeleteUserRole(userId, roleId);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public JsonResult Search(string Name = "")
{
List <usp_AspNetUserRoles_GetList> listDB = new List <usp_AspNetUserRoles_GetList>();
using (var service = new AspNetUserRolesService())
{
listDB = service.GetList();
}
var model = listDB.Where(u => u.UserName.Contains(Name) || u.Name.Contains(Name)).Select(u => new { UserName = u.UserName, Name = u.Name, UserId = u.UserId, RoleId = u.RoleId }).ToList();
return(Json(model, JsonRequestBehavior.AllowGet));
}
