public List<gov_user> setSearchFilterGroupMember(GroupMemberViewhelper groupMemberViewhelper) { List<gov_user> lstUser = new List<gov_user>(); if (groupMemberViewhelper.UserInGroup != 0) { lstUser = (from u in _cnttDB.gov_user where _cnttDB.gov_group_members.Any(g => g.username == u.username && g.group_id == groupMemberViewhelper.GroupId) select u).ToList(); var a = lstUser; } if (groupMemberViewhelper.UserNotInGroup != 0) { lstUser = (from u in _cnttDB.gov_user where !_cnttDB.gov_group_members.Any(g => g.username == u.username && g.group_id == groupMemberViewhelper.GroupId) select u).ToList(); var a = lstUser; } return lstUser.Where(u => u.hidden_flg == false).ToList(); }
public GroupMemberViewhelper saveListGroupMember(GroupMemberViewhelper groupMemberViewhelper) { List<gov_user> lstUser = setSearchFilterGroupMember(groupMemberViewhelper); int totalCount = lstUser.Count; groupMemberViewhelper.TotalCount = totalCount; if (groupMemberViewhelper.TotalCount > 0) { int totalPage = pageCalculation(totalCount, Constant.limit); groupMemberViewhelper.TotalPage = totalPage; groupMemberViewhelper.Page = pageTransition(groupMemberViewhelper.Direction, groupMemberViewhelper.Page, totalPage); groupMemberViewhelper.FirstPage = fistPageCalculation(Constant.maxPageLine, totalPage, groupMemberViewhelper.Page); groupMemberViewhelper.LastPage = lastPageCalculation(Constant.maxPageLine, totalPage, groupMemberViewhelper.Page, groupMemberViewhelper.FirstPage); int take = Constant.limit; int skip = (groupMemberViewhelper.Page - 1) * take; groupMemberViewhelper.LstUser = lstUser.OrderByDescending(u => u.entry_datetime).Skip(skip).Take(take).ToList(); } ViewData["groupMemberViewhelper"] = groupMemberViewhelper; return groupMemberViewhelper; }
public ActionResult SaveAddGroupMember(GroupMemberViewhelper groupMemberViewhelper) { String content = ""; foreach (var user in groupMemberViewhelper.Username) { gov_group_members groupMember = new gov_group_members(); groupMember.group_id = groupMemberViewhelper.GroupId; groupMember.username = user; groupMember.update_datetime = DateTime.Now; groupMember.update_username = Session.getCurrentUser().username; _cnttDB.gov_group_members.Add(groupMember); int rs = _cnttDB.SaveChanges(); if (rs > 0) { content += Constant.THEM_IN(Constant.ITEM_USER, Constant.USERNAME, user, Constant.ITEM_GROUP, Constant.ID, groupMemberViewhelper.GroupId.ToString()); content += ".<br/>"; } } if (!content.Equals("")) insertHistory(AccessType.themNguoiDungVaoGroup, content); TempData["message"] = "Thêm người dùng vào nhóm thành công!"; return Redirect("listgroupmember?groupId=" + groupMemberViewhelper.GroupId.ToString()); }
public ActionResult DeleteGroupMember(GroupMemberViewhelper groupMemberViewhelper) { if (Session.getCurrentUser() == null) return Redirect("/admin/account/logon"); if (!SercurityServices.HasPermission((int)TypeModule.MODULE_NGUOIDUNG, Session.getCurrentUser().username, TypeAudit.GroupUser)) { return Redirect("/admin/error/error403"); } String content = ""; foreach (var user in groupMemberViewhelper.Username) { try { gov_group_members groupMember = _cnttDB.gov_group_members.Where(g => g.group_id == groupMemberViewhelper.GroupId && g.username == user).FirstOrDefault(); if (groupMember != null) { _cnttDB.gov_group_members.Remove(groupMember); int rs = _cnttDB.SaveChanges(); if (rs > 0) { content += Constant.XOA_IN(Constant.ITEM_USER, Constant.USERNAME, user, Constant.ITEM_GROUP, Constant.ID, groupMember.group_id.ToString()); content += ".<br/>"; } } } catch (Exception ex) { return Redirect("/admin/error/error405"); } } if (!content.Equals("")) insertHistory(AccessType.xoaNguoiDungKhoiGroup, content); TempData["message"] = "Xóa người dùng khỏi nhóm thành công!"; return Redirect("listgroupmember?groupId=" + groupMemberViewhelper.GroupId.ToString()); }
public ActionResult AddGroupMember(GroupMemberViewhelper groupMemberViewhelper) { if (Session.getCurrentUser() == null) return Redirect("/admin/account/logon"); if (!SercurityServices.HasPermission((int)TypeModule.MODULE_NGUOIDUNG, Session.getCurrentUser().username, TypeAudit.GroupUser)) { return Redirect("/admin/error/error403"); } groupMemberViewhelper.UserNotInGroup = groupMemberViewhelper.GroupId; saveListGroupMember(groupMemberViewhelper); return View(); }