// Devuelve el histórico de pedidos del cliente 'client'
public static List <HistoricalOrder> selectHistoricalOrders(string client)
{
List <HistoricalOrder> orders = new List <HistoricalOrder>();
db.connect();
MySqlDataReader data;
if (client.Equals(""))
{
data = db.getData("SELECT * FROM Historical");
}
else
{
data = db.getData("SELECT * FROM Historical WHERE client = '" + client + "'");
}
while (data.Read())
{
HistoricalOrder o = new HistoricalOrder();
o.Client = data.GetString(1).Trim();
o.Product = data.GetString(2).Trim();
o.Amount = data.GetInt32(3);
o.Date = DateTime.Parse(data.GetDateTime(4).ToString());
orders.Add(o);
}
return(orders);
}
public static async Task Run([ActivityTrigger] HistoricalOrder historicalOrder, [CosmosDB(
databaseName: "FaceAggregator",
collectionName: "OrdersHistory",
ConnectionStringSetting = "CosmosDBConnection")] IAsyncCollector <dynamic> documents)
{
await documents.AddAsync(new { id = Guid.NewGuid(), historicalOrder.RecognitionOrder.RecognitionName, historicalOrder.RecognitionOrder.SourcePath, historicalOrder.RecognitionOrder.PatternFaces, historicalOrder.RecognitionOrder.DestinationFolder, historicalOrder.RecognitionOrder.EmailAddress, historicalOrder.RecognitionOrder.PhoneNumber, historicalOrder.RecognizedFiles });
await documents.FlushAsync();
}
// Devuelve la lista de pedidos históricos de la tabla 'Historical'
public static List <HistoricalOrder> selectHOrders(int amount, bool ascending)
{
List <HistoricalOrder> orders = new List <HistoricalOrder>();
db.connect();
// 'amount' indica la cantidad de elementos y 'ascending' el orden de búsqueda (ascendente o descendente)
MySqlDataReader data = db.getData("SELECT * FROM Historical ORDER BY date " + (ascending ? "ASC" : "DESC") + " LIMIT 0," + (--amount));
while (data.Read())
{
HistoricalOrder o = new HistoricalOrder();
o.Client = data.GetString(1).Trim();
o.Product = data.GetString(2).Trim();
o.Amount = data.GetInt32(3);
o.Date = DateTime.Parse(data.GetDateTime(4).ToString());
orders.Add(o);
}
return(orders);
}