public ShowUserRequestForAdminViewModel ShowUserRequestForAdmin(int userid, int pageid = 1, string filtertitle = "")
{
IQueryable <Request> result = _context.Requests.Include(r => r.RequestGroup).Where(r => r.UserID == userid);
if (!string.IsNullOrEmpty(filtertitle))
{
result = result.Where(r => r.UserID == userid && r.RequestGroup.GroupTitle.Contains(filtertitle));
}
int take = 10;
int skip = (pageid - 1) * take;
var user = GetUserByID(userid);
ShowUserRequestForAdminViewModel userreq = new ShowUserRequestForAdminViewModel();
userreq.CurrentPage = pageid;
userreq.PageCount = (result.Count()) / take;
userreq.Requests = result.OrderByDescending(r => r.CreateDate).Take(take).Skip(skip).ToList();
userreq.UserName = user.UserName;
return(userreq);
}
public ShowUserRequestForAdminViewModel GetAllRequests(int pageid = 1, string filtertitle = "", string filterusername = "")
{
IQueryable <Request> requests = _context.Requests.Include(r => r.RequestGroup).Include(r => r.User);
if (!string.IsNullOrEmpty(filtertitle))
{
requests = requests.Where(r => r.RequestGroup.GroupTitle.Contains(filtertitle));
}
if (!string.IsNullOrEmpty(filterusername))
{
requests = requests.Where(r => r.User.UserName.Contains(filterusername));
}
int take = 10;
int skip = (pageid - 1) * take;
ShowUserRequestForAdminViewModel allreq = new ShowUserRequestForAdminViewModel();
allreq.CurrentPage = pageid;
allreq.PageCount = (requests.Count()) / take;
allreq.Requests = requests.OrderByDescending(r => r.CreateDate).Take(take).Skip(skip).ToList();
return(allreq);
}
public void OnGet(int id, int pageid = 1, string filtertitle = "")
{
AllUserRequest = _userService.ShowUserRequestForAdmin(id, pageid, filtertitle);
}
public void OnGet(int pageid = 1, string filtertitle = "", string filterusername = "")
{
AllRequests = _userService.GetAllRequests(pageid, filtertitle, filterusername);
}
