public bool AddUserRoleLink(Forum_Role Role, Forum_User User)
{
if (UserInRole(User, Role)) return false;
var Link = new Forum_UserRoleLink();
Link.RoleID = Role.RoleID;
Link.UserID = User.UserID;
db.Forum_UserRoleLinks.InsertOnSubmit(Link);
return true;
}
public bool UserInRole(Forum_User User, Forum_Role Role)
{
return UserInRole(User, Role.RoleID);
}
public void AddRole(Forum_Role Role)
{
db.Forum_Roles.InsertOnSubmit(Role);
}
public void RemoveUserFromRole(Forum_User User, Forum_Role Role)
{
Forum_UserRoleLink Link = db.Forum_UserRoleLinks.SingleOrDefault(L => L.Forum_Role == Role && L.Forum_User == User);
if (Link == null) return;
db.Forum_UserRoleLinks.DeleteOnSubmit(Link);
}
public bool RoleHasUsers(Forum_Role Role)
{
return (from L in db.Forum_UserRoleLinks where L.RoleID == Role.RoleID select L).FirstOrDefault() != null;
}
public IQueryable<Forum_User> GetUsersInRole(Forum_Role Role, IQueryable<Forum_User> UsersToSearchIn)
{
return from L in db.Forum_UserRoleLinks where L.RoleID == Role.RoleID join U in UsersToSearchIn on L.UserID equals U.UserID select U;
}
public IQueryable<Forum_User> GetUsersInRole(Forum_Role Role)
{
return GetUsersInRole(Role, db.Forum_Users);
}
public void DeleteRole(Forum_Role Role)
{
db.Forum_UserRoleLinks.DeleteAllOnSubmit(from L in db.Forum_UserRoleLinks where L.RoleID == Role.RoleID select L);
db.Forum_Roles.DeleteOnSubmit(Role);
}
public ActionResult UserGroup(int id, int page, string UsersAddButton, string UsersRemoveButton, string NewGroup, string UpdateGroup, string DeleteGroup)
{
var model = new AdminUserGroupModel(){page = page};
model.AddNavigation("Admin Panel", "Overview", "Admin", null);
model.AddNavigation("Edit User Groups");
using (ForumRespository db = new ForumRespository())
{
Forum_User CurrentUser = GetCurrentUser(db);
if (!UserIdentity.IsAdmin)
return AuthenticationHelper.AccessDeniedView(model); // Administrating the forum requires the user to be an Admin.
HandlePermissionsLinkUpdates();
Forum_Role CurrentRole;
if (id != 0)
CurrentRole = db.GetRole(id);
else
CurrentRole = db.GetAllRoles().First();
if (CurrentRole == null)
return NotFoundView("User Group");
model.id = CurrentRole.RoleID;
model.CanBeDeleted = CurrentRole.CanBeDeleted;
model.HasMembers = CurrentRole.RoleID != (int)BuildInRole.Everyone &&
CurrentRole.RoleID != (int)BuildInRole.RegisteredUser;
model.HasPermissions = CurrentRole.RoleID != (int)BuildInRole.Administrator;
if (IsHttpPost && AntiForgeryTokenValid)
{
if (!String.IsNullOrEmpty(UsersAddButton) && model.HasMembers)
{
int nID;
Forum_User ToAdd;
foreach (var ID in Request.Form.GetValues("Users"))
{
try
{
nID = Convert.ToInt32(ID);
}
catch
{
continue;
}
if (nID == (int)BuildInUser.Guest) continue;
ToAdd = db.GetUserByID(nID);
if (ToAdd == null) continue;
if (db.UserInRole(ToAdd, CurrentRole)) continue;
db.AddUserRoleLink(CurrentRole, ToAdd);
}
db.Save();
}
else if (!String.IsNullOrEmpty(UsersRemoveButton))
{
int nID;
var RemovedUsers = Request.Form.GetValues("Users");
if (RemovedUsers != null)
{
foreach (var ID in RemovedUsers)
{
try
{
nID = Convert.ToInt32(ID);
}
catch
{
continue;
}
if (CurrentRole.RoleID == (int)BuildInRole.Administrator && nID == CurrentUser.UserID) continue;
db.RemoveUserFromRole(db.GetUserByID(nID), CurrentRole);
}
db.Save();
}
}
else if (!String.IsNullOrEmpty(UpdateGroup) && model.HasPermissions)
{
if (model.CanBeDeleted)
CurrentRole.Name = Request.Form["Name"];
CurrentRole.AllowSearch = Request.Form["IsAllowedSearch"] != "false";
db.Save();
}
else if (!String.IsNullOrEmpty(NewGroup))
{
var NewRole = new Forum_Role();
NewRole.Name = "Unnamed";
NewRole.CanBeDeleted = true;
db.AddRole(NewRole);
db.Save();
return RedirectToAction("UserGroup", new { id = NewRole.RoleID });
}
else if (!String.IsNullOrEmpty(DeleteGroup) && model.CanBeDeleted && CurrentRole.Forum_UserRoleLinks.Count == 0)
{
db.DeleteRole(CurrentRole);
db.Save();
return RedirectToAction("UserGroup", new { id = 0 });
}
}
if (model.HasMembers)
{
model.CurrentGroupUsers = db.GetUsersInRole(CurrentRole).ToClassList(U => new AdminNamedID(){ID = U.UserID, Name = U.Username});
}
model.UserGroups = db.GetAllRoles().ToClassList(R => new AdminNamedID() { ID = R.RoleID, Name = R.Name });
model.Categories = db.GetAllCategories().ToClassList(C => new AdminNamedID() { ID = C.CategoryID, Name = C.Name });
model.PermissionSets = db.GetAllPermissionSets().ToClassList(P => new AdminNamedID() { ID = P.PermissionID, Name = P.Name });
model.Fixed = AdminPermissionLinkEditors.FixedSet.UserGroups;
var Users = db.GetAllUsers().OrderBy(U => U.Username);
model.LastPage = (Users.Count() - 1) / UsersPerPage + 1;
model.AllUsers = Users.Skip((page - 1) * UsersPerPage).Take(UsersPerPage).ToClassList(U => new AdminNamedID() { ID = U.UserID, Name = U.Username });
if (model.HasPermissions)
{
model.FixedNamedID = new AdminNamedID() { ID = CurrentRole.RoleID, Name = CurrentRole.Name};
model.PermissionLinkList = db.GetPermissionLinks().Where(L => L.RoleID == id).OrderBy(L => L.CategoryID).ToClassList(L => new AdminPermissionLink()
{
Category = new AdminNamedID() { ID = L.CategoryID, Name = db.GetCategoryByID(L.CategoryID).Name },
PermissionSet = new AdminNamedID() { ID = L.PermissionID, Name = db.GetPermissionSetByID(L.PermissionID).Name },
UserGroup = model.FixedNamedID
});
}
model.Name = CurrentRole.Name;
model.IsAllowedSearch = CurrentRole.AllowSearch;
return View(model);
}
}
partial void DeleteForum_Role(Forum_Role instance);
partial void UpdateForum_Role(Forum_Role instance);
partial void InsertForum_Role(Forum_Role instance);
