public ActionResult Index()
{
var model = new MemberSearchViewModel();
ViewBag.Data_GroupID = Utilities.GetSelectListData(
GroupService.GetALL(), x => x.ID, x => x.Name, true);
return View(model);
}
public ActionResult getall(MemberSearchViewModel model, int page = 1, int rows = 10)
{
var query = MemberService.GetALL()
.Include(x => x.Group);
if (!string.IsNullOrEmpty(model.SearchName))
{
query = query.Where(x => x.Name.Contains(model.SearchName));
}
if (model.GroupID.HasValue)
{
query = query.Where(x => x.GroupID == model.GroupID.Value);
}
var count = query.Count();
var data = query.Select(x => new MemberListViewModel()
{
ID = x.ID,
GroupID = x.GroupID,
GroupName = x.Group.Name,
Name = x.Name
})
.OrderBy(x => x.ID)
.Skip((page - 1) * rows)
.Take(rows).ToList();
var obj = new
{
rows = data,
total = count
};
return Json(obj);
}
