public IQueryable <AppMenu> Search(IQueryable <AppMenu> query, AppmenuFilters filters) { if (!string.IsNullOrWhiteSpace(filters.Name)) { query = query.Where(o => o.Name.Contains(filters.Name)); } if (!string.IsNullOrWhiteSpace(filters.Code)) { query = query.Where(o => o.Code.Contains(filters.Code)); } return(query); }
public AppmenuFilters GetFilters() { var filters = new AppmenuFilters() { Page = Convert.ToInt32(HttpContext.Request.Query["page"]), Limit = Convert.ToInt32(HttpContext.Request.Query["limit"]), Name = HttpContext.Request.Query["name"], Code = HttpContext.Request.Query["code"], }; return(filters); }
public async Task <ResponseModel <AppMenuViewModel> > GetList(AppmenuFilters filters, SortCol sortCol) { var query = _accessManagementContext.AppMenu.Where(o => o.Id != 0); query = Search(query, filters); query = Sort(query, sortCol); var vms = await query.Skip((filters.Page - 1) *filters.Limit).Take(filters.Limit) .ProjectTo <AppMenuViewModel>().ToListAsync(); ResponseModel <AppMenuViewModel> result = new ResponseModel <AppMenuViewModel>(); result.status = 0; result.message = ""; result.total = query.Count(); result.data = vms; return(result); }