public ActionResult Models(string RoleId) { int role = int.Parse(RoleId); RolesRightsAssociation a = new RolesRightsAssociation(); a.IsVisible = false; a.IsReadonly = false; //Right ri = new Right(); //ri.Controller ="DefaultController"; //ri.Label ="DefaultLabel"; //a.Right=ri; //var viewModel = // from ra in _dbContext.RolesRightsAssociations // join r in _dbContext.Rights on ra.RightsFK equals r.RightsPK into tl_j // where ra.RolesFK == role // from j in tl_j.DefaultIfEmpty() // select new UserRoleModel // { // Controller = j.Controller, // Label = j.Label, // IsVisible = ra.IsVisible == null ? false : ra.IsVisible, // IsReadonly = ra.IsReadonly == null ? false : ra.IsReadonly // }; /*from r in _dbContext.Rights join ra in _dbContext.RolesRightsAssociations on r.RightsPK equals ra.RightsFK where ra.RolesFK == role select new UserRoleModel { Controller = r.Controller, Label = r.Controller, IsVisible = ra.IsVisible, IsReadonly = ra.IsReadonly };*/ return PartialView("_RolesRightsAssociation", _dbContext.sp_GetRigtsRolesInteraction(role)); //sp_GetRigtsRolesInteraction_Result model = _dbContext.sp_GetRigtsRolesInteraction(role); //return View(); //var viewModel = // from ro in _dbContext.Roles // join ri in _dbContext.Rights on ro.RolePK equals ri.RolesFK // where ro.RolePK == id // select new RoleModel // { // RightPK = ri.RightsPK, // RightName = ri.RightName // }; //return Json(viewModel.ToList()); }
public RolesRightsAssociation AddRoleRightAssociation(sp_GetRigtsRolesInteraction_Result s, int RolePK) { RolesRightsAssociation ra = new RolesRightsAssociation { IsReadonly = s.IsReadonly == null ? false : bool.Parse(s.IsReadonly.ToString()), IsVisible = s.IsVisible == null ? false : bool.Parse(s.IsVisible.ToString()), RightsFK = s.RightsPK, RolesFK = RolePK }; return ra; }