private void callMenu(int roleID)
{
CM_ROLE_PERM_XREF rpx = new CM_ROLE_PERM_XREF();
var menu = from n in db.CM_ROLE_PERM_XREF
join p in db.CM_PERMISSIONS on n.PERMISSION_ID equals p.PERMISSION_ID
join r in db.CM_USER_ROLES on n.ROLE_ID equals r.ROLE_ID
where n.ROLE_ID == roleID
orderby p.PERMISSIONDESCRIPTION
select new
{
MenuDesc = p.PERMISSIONDESCRIPTION,
URL = p.FORM_URL,
Controller = p.CONTROLLER_NAME,
Action = p.ACTION_NAME,
RoleID = n.ROLE_ID,
RoleName = r.ROLE_NAME
//MenuDesc = n.CM_PERMISSIONS.PERMISSIONDESCRIPTION,
//URL = n.CM_PERMISSIONS.FORM_URL,
//Controller = n.CM_PERMISSIONS.CONTROLLER_NAME,
//Action = n.CM_PERMISSIONS.ACTION_NAME,
//RoleID = n.ROLE_ID,
//RoleName = n.CM_USER_ROLES.ROLE_NAME
};
this.Repeater1.DataSource = menu.ToList();
this.Repeater1.DataBind();
}
/// <summary>
/// Gets a collection of membership users where the user name contains the specified user name to match.
/// </summary>
/// <returns>
/// A <see cref="T:System.Web.Security.MembershipUserCollection"/> collection that contains a page of <paramref name="pageSize"/><see cref="T:System.Web.Security.MembershipUser"/> objects beginning at the page specified by <paramref name="pageIndex"/>.
/// </returns>
/// <param name="usernameToMatch">The user name to search for.</param><param name="pageIndex">The index of the page of results to return. <paramref name="pageIndex"/> is zero-based.</param><param name="pageSize">The size of the page of results to return.</param><param name="totalRecords">The total number of matched users.</param>
internal bool DeletePermission(decimal p)
{
//ICollection<CM_USER_ROLE_XREF> UserRoleColl = new Collection<CM_USER_ROLE_XREF>();
// CM_USER_PROFILE up = new CM_USER_PROFILE();
//CM_USER_ROLE_XREF urx = new CM_USER_ROLE_XREF();
try
{
var PermxCount = (from Permx in db.CM_ROLE_PERM_XREF where Permx.PERMISSION_ID == p select Permx).Count();
if (PermxCount != null)
{
for (int i = 0; i < PermxCount; i++)
{
CM_ROLE_PERM_XREF objDelPermissionRoleRef = (from Permission in db.CM_ROLE_PERM_XREF where Permission.PERMISSION_ID == p select Permission).FirstOrDefault();
db.CM_ROLE_PERM_XREF.Remove(objDelPermissionRoleRef);
db.SaveChanges();
}
}
CM_PERMISSIONS objDeletePermission = (from Perm in db.CM_PERMISSIONS where Perm.PERMISSION_ID == p select Perm).FirstOrDefault();
db.CM_PERMISSIONS.Remove(objDeletePermission);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
public bool MapRolestoPermission(int roleID, int PermID)
{
CM_ROLE_PERM_XREF rpx = new CM_ROLE_PERM_XREF();
// if (db.CM_ROLE_PERM_XREF.Count(x => x.ROLE_ID == roleID) > 0 && db.CM_ROLE_PERM_XREF.Count(x => x.PERMISSION_ID == PermID) > 0)
var count = from n in db.CM_ROLE_PERM_XREF
where (n.ROLE_ID == roleID && n.PERMISSION_ID == PermID)
select new { n.RECORD_ID };
if (count.Count() > 0)
{
return(false);
}
else
{
rpx.ROLE_ID = roleID;
rpx.PERMISSION_ID = PermID;
rpx.CREATED_DATE = DateTime.Now;
rpx.CREATED_BY = "Admin";
rpx.PARENT_TASK = 1;
db.CM_ROLE_PERM_XREF.Add(rpx);
db.SaveChanges();
return(true);
}
}
public PartialViewResult AddRole2PermissionReturnPartialView(int permissionId, int roleId)
{
//CM_USER_PROFILE role = db.CM_USER_PROFILE.Find(roleId);
//CM_PERMISSIONS _permission = db.CM_PERMISSIONS.Find(permissionId);
//string temp = Request.QueryString[0];
//int id = Convert.ToInt32(RouteData.Values["id"]);
CM_ROLE_PERM_XREF rp = db.CM_ROLE_PERM_XREF.FirstOrDefault(a => a.PERMISSION_ID == permissionId && a.ROLE_ID == roleId);
if (rp == null)
{
var identity = ((CustomPrincipal)User).CustomIdentity;
CM_ROLE_PERM_XREF roleperm = new CM_ROLE_PERM_XREF();
roleperm.PERMISSION_ID = permissionId;
roleperm.ROLE_ID = roleId;
roleperm.CREATED_BY = identity.Name;
roleperm.CREATED_DATE = DateTime.Now;
db.CM_ROLE_PERM_XREF.Add(roleperm);
db.SaveChanges();
}
var mdmPerm = (from x in db.CM_PERMISSIONS
//join rx in db.CM_ROLE_PERM_XREF on x.PERMISSION_ID equals rx.PERMISSION_ID
//join r in db.CM_USER_ROLES on rx.ROLE_ID equals r.ROLE_ID
where x.PERMISSION_ID == permissionId
select new PermissionListModel
{
Id = (int)x.PERMISSION_ID,
PERMISSIONDESCRIPTION = x.PERMISSIONDESCRIPTION,
PARENT_PERMISSION = x.PARENT_PERMISSION,
ISACTIVE = x.ISACTIVE,
ACTION_NAME = x.ACTION_NAME,
CONTROLLER_NAME = x.CONTROLLER_NAME,
FORM_URL = x.FORM_URL,
ICON_CLASS = x.ICON_CLASS,
TOGGLE_ICON = x.TOGGLE_ICON,
ISOPEN_CLASS = x.ISOPEN_CLASS,
//UserRoles = rx.PermRoles
}).FirstOrDefault();
var roles = (from rx in db.CM_ROLE_PERM_XREF
join r in db.CM_USER_ROLES on rx.ROLE_ID equals r.ROLE_ID
where rx.PERMISSION_ID == permissionId
select new RolesListModel
{
ROLE_ID = r.ROLE_ID,
ROLE_NAME = r.ROLE_NAME
}).ToList();
ViewBag.PermRoles = roles;
//if (!role.PERMISSIONS.Contains(_permission))
//{
// role.PERMISSIONS.Add(_permission);
// database.SaveChanges();
//}
return(PartialView("_ListRolesTable4Permission", mdmPerm));
}
public PartialViewResult DeleteRoleFromPermissionReturnPartialView(int id, int permissionId)
{
//CM_USER_ROLES role = db.CM_USER_ROLES.Find(id);
//CM_PERMISSIONS permission = db.CM_PERMISSIONS.Find(permissionId);
CM_ROLE_PERM_XREF rp = db.CM_ROLE_PERM_XREF.FirstOrDefault(a => a.PERMISSION_ID == permissionId && a.ROLE_ID == id);
db.CM_ROLE_PERM_XREF.Remove(rp);
db.SaveChanges();
//if (role.PERMISSIONS.Contains(permission))
//{
// role.PERMISSIONS.Remove(permission);
// database.SaveChanges();
//}
var mdmPerm = (from x in db.CM_PERMISSIONS
//join rx in db.CM_ROLE_PERM_XREF on x.PERMISSION_ID equals rx.PERMISSION_ID
//join r in db.CM_USER_ROLES on rx.ROLE_ID equals r.ROLE_ID
where x.PERMISSION_ID == id
select new PermissionListModel
{
Id = (int)x.PERMISSION_ID,
PERMISSIONDESCRIPTION = x.PERMISSIONDESCRIPTION,
PARENT_PERMISSION = x.PARENT_PERMISSION,
ISACTIVE = x.ISACTIVE,
ACTION_NAME = x.ACTION_NAME,
CONTROLLER_NAME = x.CONTROLLER_NAME,
FORM_URL = x.FORM_URL,
ICON_CLASS = x.ICON_CLASS,
TOGGLE_ICON = x.TOGGLE_ICON,
ISOPEN_CLASS = x.ISOPEN_CLASS,
//UserRoles = rx.PermRoles
}).FirstOrDefault();
var roles = (from rx in db.CM_ROLE_PERM_XREF
join r in db.CM_USER_ROLES on rx.ROLE_ID equals r.ROLE_ID
where rx.PERMISSION_ID == id
select new RolesListModel
{
ROLE_ID = r.ROLE_ID,
ROLE_NAME = r.ROLE_NAME
}).ToList();
//IEnumerable<CM_USER_ROLES> r = roles;
//List<RolesListModel> llst = roles.Select(a => new { a.ROLE_ID, a.ROLE_NAME }).ToList();
ViewBag.PermRoles = roles;
return(PartialView("_ListRolesTable4Permission", mdmPerm));
}
public bool DeleteAssignedPermissions(decimal RecID)
{
//ICollection<CM_USER_ROLE_XREF> UserRoleColl = new Collection<CM_USER_ROLE_XREF>();
//CM_USER_PROFILE up = new CM_USER_PROFILE();
//CM_USER_ROLE_XREF urx = new CM_USER_ROLE_XREF();
CM_ROLE_PERM_XREF rpx = new CM_ROLE_PERM_XREF();
try
{
CM_ROLE_PERM_XREF objDelPermssnXRoleRef = (from PermssnXRoleRef in db.CM_ROLE_PERM_XREF where PermssnXRoleRef.RECORD_ID == RecID select PermssnXRoleRef).FirstOrDefault();
db.CM_ROLE_PERM_XREF.Remove(objDelPermssnXRoleRef);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
