// GET: CompanyPermissions/Create public IActionResult Create() { var listado = _context.Users.ToList(); //listado = (from user in _context.Users // join userRoles in _context.UserRoles on user.Id equals userRoles.UserId // join role in _context.Roles on userRoles.RoleId equals role.Id // select new { UserId = user.Id, UserName = user.UserName, RoleId = role.Id, RoleName = role.Name }) // .ToListAsync(); var data = new CompanyPermissionVM(); List <AspnetUserList> aspNetUser = new List <AspnetUserList>(); foreach (var user in listado) { var u = new AspnetUserList(); u.UserId = user.Id; u.UserName = user.UserName; aspNetUser.Add(u); } ViewBag.UserId = new SelectList(aspNetUser, "UserId", "UserName"); // var comid = HttpContext.Session.GetString("comid"); var comName = _context.Companys.Select(x => x.CompanyName).FirstOrDefault(); var cp = _context.CompanyPermissions.Select(x => new { x.ComId, x.UserId, x.CompanyPermissionId, x.isChecked, x.isDefault }).FirstOrDefault(); data = new CompanyPermissionVM(); data.UserId = cp.UserId; data.CompanyName = comName; data.ComId = cp.ComId; data.isChecked = cp.isChecked; data.isDefault = cp.isDefault; data.CompanyPermissionId = cp.CompanyPermissionId; return(View(data)); }
public JsonResult getUserCompany(string UserId) { var SavedList = _context.CompanyPermissions.Where(x => x.UserId == UserId).ToList(); var dataList = new List <CompanyPermissionVM>(); var d = _context.Companys.FirstOrDefault(); var cp = _context.CompanyPermissions.Where(x => x.UserId == UserId && x.ComId.ToString() == d.CompanyCode).FirstOrDefault(); var data = new CompanyPermissionVM(); data.UserId = UserId; data.CompanyName = d.CompanyName; data.ComId = Guid.Parse(d.CompanyCode); if (cp != null) { data.isChecked = cp.isChecked; data.isDefault = cp.isDefault; data.CompanyPermissionId = cp.CompanyPermissionId; } foreach (var cc in SavedList) { foreach (var item in dataList) { if (item.ComId == cc.ComId) { item.isChecked = cc.isChecked; item.isDefault = cc.isDefault; item.CompanyPermissionId = cc.CompanyPermissionId; } } } return(Json(data)); }