public async Task <IActionResult> Index(KeywordPagedQuery input)
{
var queryable = _dbContext.Roles.AsQueryable();
if (!string.IsNullOrWhiteSpace(input.Q))
{
queryable = queryable.Where(
u => $"{u.Name}".Contains(input.Q) ||
$"{u.Description}".Contains(input.Q));
}
var queryResult = await queryable.OrderBy(x => x.CreationTime).AsNoTracking()
.ToPagedListAsync(input.GetPage(), input.GetSize());
var itemViewModels = new List <ListRoleItemViewModel>();
foreach (var role in queryResult)
{
var dto = _mapper.Map <ListRoleItemViewModel>(role);
itemViewModels.Add(dto);
}
var pagedList = new StaticPagedList <ListRoleItemViewModel>(itemViewModels, queryResult.PageNumber,
queryResult.PageSize, queryResult.TotalItemCount);
var viewModel = new ListRoleViewModel {
Roles = pagedList, Keyword = input.Q
};
return(View(viewModel));
}
public IEnumerable <ListRoleViewModel> GetAll(ListRoleViewModel list, ref Paging pg)
{
return(roleRepository.Get().Paging(list, ref pg).AsEnumerable().Select(Result => new ListRoleViewModel()
{
Role = Result
}));
}
public ActionResult RoleList()
{
ListRoleViewModel ViewModel = new ListRoleViewModel()
{
MasterViewModel = this.MasterViewModel,
Title = "角色列表",
Url = Url.RouteUrl("SecurityApp_Role", new { Action = "DeleteRole" }),
Roles = Actor.Public.AsRoleManager().GetAllTeamRoles()
};
return(Result(ViewModel));
}
public ListRoleViewModel ListRoll(string searchValue, int currPage, int recodperpage)
{
ListRoleViewModel result = new ListRoleViewModel();
List <CustomerRole> list = new List <CustomerRole>();
var db = new DB_CSEntities1();
SqlConnection con = new SqlConnection();
con = Connection.Connect.GetConnect();
SqlCommand cmd = new SqlCommand("sp_role_getall", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@searchValue", searchValue));
cmd.Parameters.Add(new SqlParameter("@currPage", currPage));
cmd.Parameters.Add(new SqlParameter("@recodperpage", 10));
cmd.Parameters.Add("@totalCount", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Connection = con;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
int total = Convert.ToInt16(cmd.Parameters["@totalCount"].Value);
foreach (DataRow rowItem in dt.Rows)
{
CustomerRole item = new CustomerRole();
item.Id = Int32.Parse(rowItem["Id"].ToString());
item.RoleName = rowItem["RoleName"].ToString();
item.IsActive = bool.Parse(rowItem["IsActive"].ToString());
item.Level = Int32.Parse(rowItem["Level"].ToString());
item.LevelName = rowItem["LevelName"].ToString();
item.Description = rowItem["Description"].ToString();
list.Add(item);
}
result.Data = list;
result.Total = total;
return(result);
}
// GET: Roles/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Roles roles = db.IdentityRoles.Find(id);
if (roles == null)
{
return(HttpNotFound());
}
ListRoleViewModel model = new ListRoleViewModel
{
Id = roles.Id,
Name = roles.Name
};
return(View(model));
}
// GET: Roles
public ActionResult Index(RolesMessageId?message)
{
ViewBag.StatusMessage =
message == RolesMessageId.CreateRoleFail ? "No se pudo crear el rol, ya existe." :
message == RolesMessageId.EditRoleFail ? "No se pudo editar el rol, ya existe." :
"";
List <ListRoleViewModel> model = new List <ListRoleViewModel>();
foreach (var item in db.IdentityRoles.ToList().OrderBy(item => item.Name))
{
ListRoleViewModel role = new ListRoleViewModel
{
Id = item.Id,
Name = item.Name
};
model.Add(role);
}
return(View(model.ToList()));
}
