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