//[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));
}
