//Query private pagination_json queryPaginationYourWereJSON(Parame input) { var items = db.ReponseJson.FromSql("EXEC [dbo].[s_Pagination] @table_name,@search_text,@yourwhere,@key_where,@page,@limit_page,@sortby,@sort_type", new SqlParameter("@table_name", input.table_name), new SqlParameter("@search_text", input.search_text), new SqlParameter("@yourwhere", input.yourwhere), new SqlParameter("@key_where", input.key_where), new SqlParameter("@page", input.page), new SqlParameter("@limit_page", input.limit_page), new SqlParameter("@sortby", input.sortby), new SqlParameter("@sort_type", input.sort_type) ).FirstOrDefault(); return(items); }
//json private PaginationJSON queryPaginationAndFilterYourWhereJSON(Parame input) { try { var query = queryPaginationYourWereJSON(input); PaginationJSON pagination = new PaginationJSON(); if (query.Item != null) { pagination.items = JsonConvert.DeserializeObject(query.Item); } else { pagination.items = new object[] { }; } pagination.startRow = input.page; pagination.limitRow = input.limit_page; pagination.resultRow = query.Count_row; return(pagination); } catch (Exception e) { throw new Exception(e.Message); } }