[HttpGet("GetProductos")] // post api/Cliente/GeProductos public ActionResult getProductos([FromQuery(Name = "PageNumber")] int PageNumber, [FromQuery(Name = "Rows")] int Rows) { ProductoServices clienteServices = new ProductoServices(); List <Producto> lProducto = clienteServices.ReturnProducts(PageNumber, Rows); int total = 0; string query = "SELECT COUNT(*) AS 'TOTAL' FROM [adpruebas_de_timbrado].[dbo].[admProductos];"; string connString = DatabaseServices.GetConnString(); using (SqlConnection sqlConnection = new SqlConnection(connString)) { SqlCommand cmd = new SqlCommand(query, sqlConnection); sqlConnection.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { total = reader.GetInt32(0); } } } ListOfProductos listOfProductos = new ListOfProductos(lProducto, PageNumber, total); string jsonString; jsonString = JsonSerializer.Serialize(listOfProductos); return(Ok(jsonString)); }