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