/// <summary>
/// Get the actual purchase by ID from the database
/// </summary>
/// <exception cref="PurchaseNotFoundException"></exception>
public Purchase GetPurchase(int ID)
{
using (IDbConnection connection = new SQLiteConnection($@"Data Source={WPFHelper.DataPath}Database.db;Version=3;")) {
connection.Open();
DbPurchase purchase = connection.QueryFirst <DbPurchase>($"SELECT * FROM {DbPurchase.DName}" +
$"WHERE {DbPurchase.DName}.{nameof(DbPurchase.ID)} = {ID}");
if (purchase == null)
{
throw new PurchaseNotFoundException("Purchase with GUID:" + ID + " does not exist!");
}
return(new Purchase(purchase));
}
}
/// <summary>
/// Create a purchase from database entry
/// </summary>
public Purchase(DbPurchase current)
{
ID = current.ID;
PurchaseDate = DateTime.Parse(current.Date);
Shop = (Shop)current.ShopID;
}
public Purchase ComposePurchse(DbPurchase dbPurchase)
{
Cart cart = ComposeCart(dbPurchase.CartId, dbPurchase.UserName);
return(new Purchase(dbPurchase.UserName, cart));
}
