public UserForAdminViewModel GetUsers(int pageId = 1, string filterEmail = "", string filterUserName = "")
{
IQueryable <User> result = _context.Users;
if (!string.IsNullOrEmpty(filterEmail))
{
result = result.Where(u => u.Email.Contains(filterEmail));
}
if (!string.IsNullOrEmpty(filterUserName))
{
result = result.Where(u => u.UserName.Contains(filterUserName));
}
// Show Item In Page
int take = 20;
int skip = (pageId - 1) * take;
UserForAdminViewModel list = new UserForAdminViewModel();
list.CurrentPage = pageId;
list.PageCount = result.Count() / take;
list.Users = result.OrderBy(u => u.RegisterDate).Skip(skip).Take(take).ToList();
return(list);
}
public UserForAdminViewModel getusers(int pageid = 1, string filteremail = "", string filteruserName = "")
{
IQueryable <User> results = _db.Users;
if (!string.IsNullOrEmpty(filteremail))
{
results = results.Where(u => u.Email.Contains(filteremail));
}
if (!string.IsNullOrEmpty(filteruserName))
{
results = results.Where(u => u.UserName.Contains(filteruserName));
}
int take = 20;
int skip = (pageid - 1) * take;
UserForAdminViewModel list = new UserForAdminViewModel();
list.CurrentPage = pageid;
list.PageCount = results.Count() / take;
list.users = results.OrderBy(u => u.Registerdate).Skip(skip).Take(take).ToList();
return(list);
}
public UserForAdminViewModel GetDeleteUsers(int pageId = 1, string filterEmail = "", string filterUserName = "")
{
IQueryable <User> result = context.Users.IgnoreQueryFilters().Where(c => c.IsDelete);
if (!string.IsNullOrEmpty(filterEmail))
{
result = result.Where(c => c.Email == filterEmail);
}
if (!string.IsNullOrEmpty(filterUserName))
{
result = result.Where(c => c.UserName == filterUserName);
}
int take = 20;
int skip = (pageId - 1) * take;
UserForAdminViewModel list = new UserForAdminViewModel();
list.CurrentPage = pageId;
list.PageCount = result.Count() / take;
list.Users = result.OrderBy(c => c.RegisterDate).Skip(skip).Take(take).ToList();
return(list);
}
public UserForAdminViewModel GetUsersForAdmin(int pageid = 1, string filtername = "", string filterphone = "")
{
IQueryable <User> result = _context.Users.Include(r => r.Requests);
if (!string.IsNullOrEmpty(filtername))
{
result = result.Where(r => r.UserName.Contains(filtername));
}
if (!string.IsNullOrEmpty(filterphone))
{
result = result.Where(r => r.PhoneNumber.Contains(filterphone));
}
//Show Item in Page
int take = 10;
int skip = (pageid - 1) * take;
UserForAdminViewModel list = new UserForAdminViewModel();
list.CurrentPage = pageid;
list.PageCount = (result.Count()) / take;
list.Users = result.OrderByDescending(r => r.RegisterDate).Take(take).Skip(skip).ToList();
return(list);
}
public async Task <IActionResult> AllUsers()
{
var listOfUsers = _userRepository.GetAllUsers();
var listOfUserViewModel = new List <UserForAdminViewModel>();
foreach (var user in listOfUsers)
{
var viewModel = new UserForAdminViewModel()
{
Id = user.Id,
FirstName = user.FirstName,
LastName = user.LastName,
Role = await _userRepository.GetRole(user)
};
listOfUserViewModel.Add(viewModel);
}
return(View(listOfUserViewModel));
}
public UserForAdminViewModel GetDeleteUsers(int pageId = 1, string filterEmail = "", string filterUserName = "")
{
IQueryable <User> result = _context.Users.IgnoreQueryFilters().Where(u => u.IsDelete);
if (!string.IsNullOrEmpty(filterEmail))
{
result = result.Where(u => u.Email.Contains(filterEmail));
}
if (!string.IsNullOrEmpty(filterUserName))
{
result = result.Where(u => u.UserName.Contains(filterUserName));
}
//Show iTEM iN Page
int take = 20;
int skip = (pageId - 1) * take;
var list = new UserForAdminViewModel()
{
CurrentPage = pageId,
PageCount = result.Count() / take,
Users = result.OrderBy(u => u.RegisterDate).Skip(skip).Take(take).ToList()
};
return(list);
}
public void OnGet(int pageId = 1, string filterEmail = "", string filterUserName = "")
{
UserForAdminViewModel = _userService.GetDeleteUsers(pageId, filterEmail, filterUserName);
}
public void OnGet(int pageid = 1, string filtername = "", string filterphone = "")
{
Users = _userService.GetUsersForAdmin(pageid, filtername, filterphone);
}
public void OnGet(int pageid = 1, string filterusername = "", string filteremail = "")
{
UserForAdminViewModel = _userService.getusers(pageid, filterusername, filteremail);
}
