//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);
}
}
