//[Authorize(Roles = "Admin, CanEditGroup")] public ActionResult GroupAddUsers(int id, string userName, string email) { var group = db.Groups.Find(id); string _MaTTP = ""; _MaTTP = User.Identity.Name.ToUpper() == "ADMIN" ? "" : db.Users.FirstOrDefault(u => u.UserName == User.Identity.Name).MA_TINHTP; var model = new SelectUsersOutGroupViewModel(group, _MaTTP); if (!string.IsNullOrEmpty(userName)) { model.UserOutGroup = model.UserOutGroup.Where(s => s.UserName != null && s.UserName.ToUpper().Contains(userName.ToUpper())).ToList(); } if (!string.IsNullOrEmpty(email)) { model.UserOutGroup = model.UserOutGroup.Where(s => s.Email != null && s.Email.ToUpper().Contains(email.ToUpper())).ToList(); } DTINHTP _TTP = (new FDB.DataAccessLayer.FDBContext()).DTINHTP.FirstOrDefault(m => m.MA_TINHTP == _MaTTP); if (_TTP != null) { ViewBag.TenTTP = _TTP.TEN_TINHTP; } return(View(model)); }
//[Authorize(Roles = "Admin, CanEditGroup, CanEditUser")] public ActionResult Index(string txtTenNhom) { string _MaTTP = ""; var listGroup = new List <Group>(); if (User.Identity.Name.ToUpper() == "ADMIN") { listGroup = db.Groups.Where(g => (txtTenNhom == null || txtTenNhom == "") || g.Name.ToUpper().Contains(txtTenNhom.ToUpper())).ToList(); } else { _MaTTP = db.Users.FirstOrDefault(m => m.UserName == User.Identity.Name).MA_TINHTP; var s = db.Groups.Where(g => (txtTenNhom == null || txtTenNhom == "") || g.Name.ToUpper().Contains(txtTenNhom.ToUpper())).ToList(); listGroup = s.Where(m => m.Ma_TTP == _MaTTP).ToList(); } DTINHTP _TTP = (new FDB.DataAccessLayer.FDBContext()).DTINHTP.FirstOrDefault(m => m.MA_TINHTP == _MaTTP); if (_TTP != null) { ViewBag.TenTTP = _TTP.TEN_TINHTP; } ViewBag.TotalRow = listGroup.Count(); return(View(listGroup)); }
//[Authorize(Roles = "Admin, CanEditUser")] public ActionResult UserGroups(string id) { var _db = new ApplicationDbContext(); var user = _db.Users.First(u => u.UserName == id); var model = new SelectUserGroupsViewModel(user, User.Identity.Name); string _MaTTP = ""; _MaTTP = User.Identity.Name.ToUpper() == "ADMIN" ? "" : _db.Users.FirstOrDefault(u => u.UserName == User.Identity.Name).MA_TINHTP; DTINHTP _TTP = (new FDB.DataAccessLayer.FDBContext()).DTINHTP.FirstOrDefault(m => m.MA_TINHTP == _MaTTP); if (_TTP != null) { ViewBag.TenTTP = _TTP.TEN_TINHTP; } return(View(model)); }
//[Authorize(Roles = "Admin")] public ActionResult Index(int?page, string txtUserName, string txtEmail, string txtHoTen) { var Db = new ApplicationDbContext(); var users = new List <ApplicationUser>(); string _MaTTP = ""; if (User.Identity.Name.ToUpper() == "ADMIN") { users = Db.Users.Where(u => ((txtUserName == null || txtUserName == "") || u.UserName.ToUpper().Contains(txtUserName.ToUpper())) && ((txtEmail == null || txtEmail == "") || u.Email.ToUpper().Contains(txtEmail.ToUpper())) && ((txtHoTen == null || txtHoTen == "") || (u.FirstName.ToUpper().Contains(txtHoTen.ToUpper()) || u.LastName.ToUpper().Contains(txtHoTen.ToUpper()))) ).OrderBy(o => o.UserName).ToList(); } else { _MaTTP = Db.Users.FirstOrDefault(u => u.UserName == User.Identity.Name).MA_TINHTP; users = Db.Users.Where(u => ((txtUserName == null || txtUserName == "") || u.UserName.ToUpper().Contains(txtUserName.ToUpper())) && ((txtEmail == null || txtEmail == "") || u.Email.ToUpper().Contains(txtEmail.ToUpper())) && ((txtHoTen == null || txtHoTen == "") || (u.FirstName.ToUpper().Contains(txtHoTen.ToUpper()) || u.LastName.ToUpper().Contains(txtHoTen.ToUpper()))) && (u.MA_TINHTP == _MaTTP) ).OrderBy(o => o.UserName).ToList(); } var model = new List <EditUserViewModel>(); foreach (var user in users) { var u = new EditUserViewModel(user); model.Add(u); } DTINHTP _TTP = (new FDB.DataAccessLayer.FDBContext()).DTINHTP.FirstOrDefault(m => m.MA_TINHTP == _MaTTP); if (_TTP != null) { ViewBag.TenTTP = _TTP.TEN_TINHTP; } ViewBag.TotalRow = model.Count; int pageSize = FDB.Common.Constants.PageSize;; int pageNumber = page ?? 1; // null-coalescing operator: return the value of page if it has a value, or return 1 if page is null. return(View(model.ToPagedList(pageNumber, pageSize))); }
//[Authorize(Roles = "Admin, CanEditGroup")] public ActionResult GroupRemoveUsers(int id) { var group = db.Groups.Find(id); string _MaTTP = ""; _MaTTP = User.Identity.Name.ToUpper() == "ADMIN" ? "" : db.Users.FirstOrDefault(u => u.UserName == User.Identity.Name).MA_TINHTP; var model = new SelectUsersInGroupViewModel(group); DTINHTP _TTP = (new FDB.DataAccessLayer.FDBContext()).DTINHTP.FirstOrDefault(m => m.MA_TINHTP == _MaTTP); if (_TTP != null) { ViewBag.TenTTP = _TTP.TEN_TINHTP; } return(View(model)); }