public JsonResult IndexAjax(DataTableJS data) { var itmes = _service.GetIQueryableItems().ToList(); String search = null; if (data.search != null && data.search["value"] != null) { search = data.search["value"]; } var column = data.order[0]["column"]; var dir = data.order[0]["dir"]; string columnName = ((String[])data.columns[int.Parse(column)]["data"])[0]; var queryFilter = _service.GetIQueryableItems() .Where( T => T.Active == 1 && (search == "" || (search != null && (T.KeySearch.ToLower().Contains(search.ToLower()))))); if (dir == "asc") { queryFilter = queryFilter.OrderByField(columnName, true); } else { queryFilter = queryFilter.OrderByField(columnName, false); } data.recordsTotal = _service.GetIQueryableItems().Where(T => T.Active == 1).Count(); data.recordsFiltered = queryFilter.Count(); data.data = queryFilter.Skip(data.start) .Take(data.length == -1 ? data.recordsTotal : data.length) .ToList(); return(Json(data, JsonRequestBehavior.AllowGet)); }
private void LoadDataList() { var Areas = _areaservice.GetIQueryableItems().Where(T => T.Active == 1).ToList().Select(T => new SelectListItem { Value = T.ID.ToString(), Text = T.Name.ToString(), Selected = false }).ToList(); Areas.Insert(0, new SelectListItem { Value = "", Text = "Chọn", Selected = true }); ViewBag.Areas = Areas; }