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();
}
