public AuctionItem() { ItemID = 0; Stack = 0; Seller = 0; SellerName = "AuctionMoogle"; Date = TimeObject.Convert(); Price = 0; Sale = 0; SaleDate = TimeObject.Convert(); }
public void BuyItem(AuctionItem item) { var conn = Connect(); conn.Open(); // Set item to sold MySqlCommand buy = conn.CreateCommand(); buy.CommandText = $"UPDATE {item.Table} SET buyer_name=\"AuctionMoogle\", sale={item.Price}, sell_date={TimeObject.Convert()} WHERE id={item.Id};"; buy.ExecuteNonQueryAsync(); buy.Dispose(); conn.Close(); // Alert console Console.WriteLine($"Buying {item.ItemID} from {item.SellerName} for {item.Price}"); // Send money var itemToBuy = new DeliveryBoxItem(); itemToBuy.CharID = item.Seller; itemToBuy.Quantity = item.Price; var con = Connect(); con.Open(); MySqlCommand pay = con.CreateCommand(); pay.CommandText = $"INSERT INTO {itemToBuy.Table} (charid, box, itemid, itemsubid, quantity, sender) " + $"values('{itemToBuy.CharID}','{itemToBuy.Box}','{itemToBuy.ItemID}','{itemToBuy.ItemSubID}','{itemToBuy.Quantity}','{itemToBuy.Sender}');"; Console.WriteLine($"Giving {itemToBuy.Quantity} Gil to {itemToBuy.CharID}"); pay.ExecuteNonQueryAsync(); pay.Dispose(); con.Close(); }