コード例 #1
0
        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,
        }