public static OrderRecord GetTheMostRecentOrder(int clientId)
{
String query = $"SELECT orderId, clientId, workerId, addressId, status, DATE_FORMAT(max(openDate),'%Y-%m-%d') as openDate, DATE_FORMAT(closeDate,'%Y-%m-%d') as closeDate FROM orders WHERE clientId={clientId}";
var order = connector.ExecuteQuery(query);
var record = new OrderRecord();
if (order.Rows.Count == 0)
{
return(null);
}
record.Fill(order.Rows[0]);
return(record);
}
public static List <OrderRecord> GetOrders(int clientId)
{
List <OrderRecord> ordersRecords = new List <OrderRecord>();
String query = $"SELECT orderId, clientId, workerId, addressId, status, DATE_FORMAT(openDate,'%Y-%m-%d') as openDate, DATE_FORMAT(closeDate,'%Y-%m-%d') as closeDate FROM orders WHERE clientId={clientId}";
DataTable orders = connector.ExecuteQuery(query);
foreach (DataRow dr in orders.Rows)
{
var record = new OrderRecord();
record.Fill(dr);
ordersRecords.Add(record);
}
return(ordersRecords);
}
