private int queryPaginationCountRowYourWere(Parame input) { int count = db.Database.SqlQuery <int>("EXEC [dbo].[pagination_row_count] @table_name,@search_text,@yourwhere,@key_where", 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) ).FirstOrDefault(); return(count); }
private object queryPaginationAndFilterYourWhereJSONnonPagination(Parame input) { try { return(queryPaginationYourWereJSON(input)); } catch (Exception e) { throw new Exception(e.Message); } }
private IEnumerable <T> queryPaginationYourWere <T>(Parame input) { IEnumerable <T> items = db.Database.SqlQuery <T>("EXEC [dbo].[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) ).ToList(); return(items); }
//json private PaginationJSON queryPaginationAndFilterYourWhereJSON(Parame input) { try { PaginationJSON pagination = new PaginationJSON(); pagination.items = queryPaginationYourWereJSON(input); pagination.startRow = input.page; pagination.limitRow = input.limit_page; int count = queryPaginationCountRowYourWere(input); pagination.resultRow = count; pagination.searchRow = count; return(pagination); } catch (Exception e) { throw new Exception(e.Message); } }
private object queryPaginationYourWereJSON(Parame input) { string items = db.Database.SqlQuery <string>("EXEC [dbo].[pagination_json] @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(); if (items != null) { JavaScriptSerializer json_serializer = new JavaScriptSerializer(); var result = json_serializer.DeserializeObject(items); return(result); } return(new object[] { }); }