public (IList <Book> records, int total, int totalDisplay) GetBooks(int pageIndex,
int pageSize, string searchText, string sortText)
{
using var dbProvider = new SqlServerDataProvider <Book>(_connectionString);
var books = dbProvider.GetData("GetBooks", new List <(string, object, bool)>
{
("PageIndex", pageIndex, false),
("PageSize", pageSize, false),
("SearchText", searchText, false),
("OrderBy", sortText, false),
("Total", 0, true),
("TotalDisplay", 0, true)
});
public (IList <Product> records, int total, int totalDisplay) GetProducts(int pageIndex, int pageSize, string searchText, string sortText)
{
using var dbProvider = new SqlServerDataProvider <Product>(_connectionString);
var products = dbProvider.GetData("SpGetAllProducts", new List <(string, object, bool)>()
{
("PageIndex", pageIndex, false),
("PageSize", pageSize, false),
("SearchText", searchText, false),
("OrderBy", sortText, false),
("Total", 0, true),
("TotalDisplay", 0, true)
});
return(products.result, products.total, products.totalDisplay);
}
