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