public JsonResult LoadData(string name, string status, int page, int pageSize) { var model = UserBus.List(); if (!string.IsNullOrEmpty(name)) { name = name.ToLower(); model = model.Where(x => x.FirstName.ToLower().Contains(name) || x.LastName.ToLower().Contains(name) || x.Email.ToLower().Contains(name)); } if (!string.IsNullOrEmpty(status)) { model = model.Where(x => x.Role == status); } int totalRow = model.Count(); model = model.Skip((page - 1) * pageSize).Take(pageSize); return(Json(new { data = model, total = totalRow, status = true }, JsonRequestBehavior.AllowGet)); }