public JsonResult <List <AspNetUserModel> > GetUserDetailsWithPagingSorting(IndexScreenParameterModel IndexScreenParameterModel) { try { string SelectColumn = string.Empty, SearchValue = string.Empty; string searchColumn = string.Empty; foreach (var item in IndexScreenParameterModel.IndexScreenSelectParameterModel) { SelectColumn += item.SelectParameter + ","; } if (IndexScreenParameterModel.IndexScreenSearchParameterModel != null) { if (IndexScreenParameterModel.IndexScreenSearchParameterModel.Count > 0) { SearchValue = "AND "; foreach (var itemSearch in IndexScreenParameterModel.IndexScreenSearchParameterModel) { if (!string.IsNullOrEmpty(searchColumn)) { searchColumn += " AND "; } if (itemSearch.SearchParameterDataType.ToLower() == "string") { searchColumn += itemSearch.SearchParameter + " LIKE '%" + itemSearch.SearchParameterValue + "%' "; } else { searchColumn += itemSearch.SearchParameter + "=" + itemSearch.SearchParameterValue; } } } } SearchValue = SearchValue + searchColumn; var objList = _iAspNetUser.GetUserDetailsWithPagingSorting(SelectColumn.Substring(0, SelectColumn.Length - 1), SearchValue, IndexScreenParameterModel.PageNo, IndexScreenParameterModel.PageSize, IndexScreenParameterModel.SortColumn, IndexScreenParameterModel.SortOrder); return(Json(objList)); } catch (Exception ex) { Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString()); return(null); } }