public JsonResult GetCustomer(DataTableParameters dataTableParameters) { CUSTOMER cus = new CUSTOMER(); var resultSet = new DataTableResultSet(); resultSet.draw = dataTableParameters.Draw; var lst = cus.SelectPaging(dataTableParameters.Start + 1, dataTableParameters.Start + dataTableParameters.Length + 1, dataTableParameters.Search.Value); resultSet.recordsTotal = resultSet.recordsFiltered = cus.GetCount(dataTableParameters.Search.Value); foreach (var i in lst) { var columns = new List <string>(); columns.Add("<input type='checkbox' class='ckb' id='" + i.ID + "' />"); columns.Add(i.ID); columns.Add(i.NAME); columns.Add(i.LOCATION == null ? "" : i.LOCATION.Trim()); columns.Add(i.EMP_NAME == null ? "" : i.EMP_NAME); columns.Add(i.TYPE == null ? "": i.TYPE); columns.Add("<a href='#' class='end' title='End User' id='" + i.ID + "'><span class='badge badge-pill badge-primary'>" + i.NUM_END + "</span></a>"); resultSet.data.Add(columns); } return(Json(resultSet)); }