/// <summary>
/// Lädt die Supplies eines Druckers aus der Datenbank
/// </summary>
/// <param name="printer">
/// Das Drucker Objekt<remarks>Benötigt Datenbank Id</remarks></param>
/// <returns>Die Liste der Verbrauchsteile</returns>
public List<Supply> GetSupplyList(Printer printer)
{
List<Supply> supplies = new List<Supply>();
using (IDbConnection connection = DatabaseInterface.CreateConnection(ConnectionString))
using (IDbCommand command = DatabaseInterface.CreateCommand("SELECT * FROM supplies WHERE printerId = @PrinterId ORDER BY id", connection))
{
command.Parameters.Add(DatabaseInterface.CreateParameter("@PrinterId", printer.Id));
connection.Open();
//read the supplies
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Supply newSupply = new Supply
{
Id = int.Parse(reader["id"].ToString()),
Description = reader["description"].ToString(),
Value = double.Parse(reader["value"].ToString()),
GlobalAlertTriggered = bool.Parse(reader["globalAlertTriggered"].ToString()),
NotificationValue = int.Parse(reader["notificationValue"].ToString()),
Notified = bool.Parse(reader["notified"].ToString()),
NotifyWhenLow = bool.Parse(reader["notifyWhenLow"].ToString()),
};
supplies.Add(newSupply);
}
return supplies;
}
}
}
/// <summary>
/// Legt das Druckerobjekt und den Verbrauchsgegenstand fest
/// </summary>
/// <param name="supply">Der Verbrauchsgegenstand für den niedriger Füllstand auftrat</param>
/// <param name="printer"></param>
public SupplyEventArgs(Printer printer, Supply supply)
{
Printer = printer;
Supply = supply;
}
