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