public ActionResult AddEditRole(int id = 0) { var aerm = new AddEditRoleModel(); RoleClass Role = new RoleClass(); var PrivilegeList = new List <PrivilegeClass>(); if (id != 0) { var roleDetail = _Context.Roles.Where(x => x.PK_RoleID == id).Select(x => x).FirstOrDefault(); Role.RoleName = roleDetail.RoleName; Role.RoleId = roleDetail.PK_RoleID; aerm.Role = Role; var userRolePrivileges = _Context.UserRolePrivileges.Where(x => x.FK_RoleID == id).Select(x => x).ToList(); var privileges = _Context.Privileges.Select(x => new { x.PK_PrivilegeID, x.PrivilegeName }).ToList(); foreach (var item in userRolePrivileges) { var previlege = new PrivilegeClass(); previlege.PrivilegeId = item.FK_PrivilegeID; previlege.PrivilegeName = privileges.Where(x => x.PK_PrivilegeID == item.FK_PrivilegeID).Select(x => x.PrivilegeName).FirstOrDefault(); previlege.IsView = item.IsView; previlege.IsCreate = item.IsCreate; previlege.IsUpdate = item.IsUpdate; previlege.IsDelete = item.IsDelete; PrivilegeList.Add(previlege); } aerm.PrivilegeList = PrivilegeList; } else { var privileges = _Context.Privileges.Select(x => x).ToList(); foreach (var item in privileges) { var previlege = new PrivilegeClass(); previlege.PrivilegeId = item.PK_PrivilegeID; previlege.PrivilegeName = item.PrivilegeName; PrivilegeList.Add(previlege); } aerm.PrivilegeList = PrivilegeList; } return(View(aerm)); }
public ActionResult AddEditRole(AddEditRoleModel aerm) { XDocument AddEditRoles = new XDocument(new XDeclaration("1.0", "UTF - 8", "yes"), new XElement("UserRolePrivilegeList", from PList in aerm.PrivilegeList select new XElement("userRolePrililege", new XElement("RoleID", aerm.Role.RoleId), new XElement("RoleName", aerm.Role.RoleName), new XElement("PrivilegeID", PList.PrivilegeId), new XElement("IsView", PList.IsView), new XElement("ISCreate", PList.IsCreate), new XElement("IsUpdate", PList.IsUpdate), new XElement("IsDelete", PList.IsDelete))) ); var abc = AddEditRoles.ToString(); _Context.Sp_RolePrivilegeWXml(abc); return(RedirectToAction("RoleList")); }