public async Task <ActionResult> ProductPosList([FromBody] RequestTableParameter parameter) { try { //var productConfig = new CustomQueryConfig("v_product_merchant", // new QueryField("productId"), display:false), // new QueryField("name")), // new QueryField("price"), // new QueryField("note", sort:false), // new QueryField("categoryName"), // new QueryField("mainImage", filter:false, sort:false), // new QueryField("isProductForRent)) // ); /* */ //var productConfig = new QueryRepository().GetByConfig("v_product_merchant1"); //productConfig.ConnectionString = GlobalVariables.Connection; //productConfig.Provider = TablePlugin.Core.DatabaseProvider.SQLite; //var paginator = new QueryPaginator(); //var products = await paginator.GetAsync<ProductView>(productConfig, parameter); var result = await QueryPaginatorDbService.Build("v_product_merchant1", parameter); return(Ok(result)); } catch (Exception ex) { return(BadRequest(new ErrorResponse(ex))); } //return Ok(products); // id: i + 1, // title: faker.name.firstName(), // imgSrc: imgSrc, // body: faker.lorem.sentence(), // price: faker.random.number({ min: 5, max: 20000 }), // isProductForRent: true, // startDate: '', // endDate: '', // disscountType: 'none', // discountId: -1, }