private void Common (OrderedDictionary od)
{
Assert.IsNotNull (od.GetEnumerator (), "GetEnumerator");
Assert.AreEqual (0, od.Count, "Count-0");
Assert.IsFalse (od.IsReadOnly, "IsReadOnly");
od.Add ("a", "1");
Assert.AreEqual (1, od.Count, "Count-1");
od["a"] = "11";
Assert.AreEqual ("11", od["a"], "this[string]");
od[0] = "111";
Assert.AreEqual ("111", od[0], "this[int]");
DictionaryEntry[] array = new DictionaryEntry[2];
od.CopyTo (array, 1);
Assert.AreEqual ("111", ((DictionaryEntry)array[1]).Value, "CopyTo");
Assert.AreEqual (1, od.Keys.Count, "Keys");
Assert.AreEqual (1, od.Values.Count, "Values");
Assert.IsTrue (od.Contains ("a"), "Contains(a)");
Assert.IsFalse (od.Contains ("111"), "Contains(111)");
od.Insert (0, "b", "2");
Assert.AreEqual (2, od.Count, "Count-2");
od.Add ("c", "3");
Assert.AreEqual (3, od.Count, "Count-3");
OrderedDictionary ro = od.AsReadOnly ();
od.RemoveAt (2);
Assert.AreEqual (2, od.Count, "Count-4");
Assert.IsFalse (od.Contains ("c"), "Contains(c)");
od.Remove ("b");
Assert.AreEqual (1, od.Count, "Count-5");
Assert.IsFalse (od.Contains ("b"), "Contains(b)");
od.Clear ();
Assert.AreEqual (0, od.Count, "Count-6");
Assert.IsTrue (ro.IsReadOnly, "IsReadOnly-2");
// it's a read-only reference
Assert.AreEqual (0, od.Count, "Count-7");
}
public void ClearTests()
{
var d = new OrderedDictionary();
d.Clear();
Assert.Equal(0, d.Count);
for (int i = 0; i < 1000; i++)
{
d.Add(i, i);
}
d.Clear();
Assert.Equal(0, d.Count);
d.Clear();
Assert.Equal(0, d.Count);
for (int i = 0; i < 1000; i++)
{
d.Add("foo", "bar");
d.Clear();
Assert.Equal(0, d.Count);
}
}
public void ReadOnly_Clear ()
{
OrderedDictionary od = new OrderedDictionary ().AsReadOnly ();
od.Clear ();
}
void FillData()
{
DateTime theMonthToFilter = DateTime.Today;
if (calendar1.DisplayDate != null)
{
theMonthToFilter = (DateTime)calendar1.DisplayDate;
}
var startOfMonth = new DateTime(theMonthToFilter.Year, theMonthToFilter.Month, 1);
var endOfMonth = new DateTime(theMonthToFilter.Year, theMonthToFilter.Month, 1).AddMonths(1).AddDays(-1).AddHours(23).AddMinutes(59); ;
//calendar1.SelectedDate;
DataRowView dr = ((DataRowView)dataGrid_projects.SelectedItem);
if (dr==null) return;
String SQL = "SELECT * FROM times WHERE project_id = '" + dr.Row[0] + "' AND julianday(start_date) >= julianday('" + DateTimeSQLite(startOfMonth) + "') AND julianday(end_date) <= julianday('" + DateTimeSQLite(endOfMonth) + "')";
DataSet ds = new DataSet();
using (SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(SQL, cnn))
{
dataAdapter.Fill(ds);
}
DataView dv = ds.Tables[0].DefaultView;
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Link", typeof(DataRow)));
dt.Columns.Add(new DataColumn("Readable", typeof(string)));
dt.Columns.Add(new DataColumn("Day", typeof(int)));
dt.Columns.Add(new DataColumn("Times", typeof(string)));
dt.Columns.Add(new DataColumn("Duration", typeof(string)));
dt.Columns.Add(new DataColumn("Description", typeof(string)));
// dt.Columns[0].Visible = false;
OrderedDictionary dtIndex = new OrderedDictionary();
dtIndex.Clear();
for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
{
dtIndex.Add(ds.Tables[0].Columns[i].ColumnName, i);
}
TimeSpan total = new TimeSpan();
foreach (DataRow r in ds.Tables[0].Rows)
{
var id = r[(int)dtIndex["id"]];
var project_id = r[(int)dtIndex["project_id"]];
DateTime start_date = (DateTime)r[(int)dtIndex["start_date"]];
DateTime end_date =(DateTime)r[(int)dtIndex["end_date"]];
var desc = r[(int)dtIndex["description"]];
TimeSpan diff = end_date-start_date;
total = total + diff;
String diffTime = diff.Hours.ToString() + " Hrs " + diff.Minutes.ToString() + "Mins";
String readable = Ordinal(Convert.ToInt32(start_date.ToString("dd"))) + " " + start_date.ToString("dddd");
dt.Rows.Add(r,readable,start_date.ToString("dd"), start_date.ToString("h:mm tt") + " - " + end_date.ToString("h:mm tt"), diffTime, desc);
}
HrsLabel.Content = (total.Days * 24 + total.Hours) + "hrs " + total.Minutes + " mins = " + (total.TotalHours) + " hrs";
DataView dvdt = dt.DefaultView;
dvdt.Sort = "Day ASC";
ICollectionView iG = CollectionViewSource.GetDefaultView(dvdt);
iG.GroupDescriptions.Add(new PropertyGroupDescription("Day"));
dataGrid.ItemsSource = iG;
}
public void AsReadOnly_AttemptingToModifyDictionary_Throws()
{
OrderedDictionary orderedDictionary = new OrderedDictionary().AsReadOnly();
Assert.Throws<NotSupportedException>(() => orderedDictionary[0] = "value");
Assert.Throws<NotSupportedException>(() => orderedDictionary["key"] = "value");
Assert.Throws<NotSupportedException>(() => orderedDictionary.Add("key", "value"));
Assert.Throws<NotSupportedException>(() => orderedDictionary.Insert(0, "key", "value"));
Assert.Throws<NotSupportedException>(() => orderedDictionary.Remove("key"));
Assert.Throws<NotSupportedException>(() => orderedDictionary.RemoveAt(0));
Assert.Throws<NotSupportedException>(() => orderedDictionary.Clear());
}
protected void processSales()
{
OrderedDictionary soldBoughtItems = new OrderedDictionary();
/*
* First of all the old system was not possible to do with SQL
* Would of required to do a SQL Query for each itemId sold and bought by all players
* That would of ment over 10,000 items x 2 (buyers+sellers) so 20,000 queries to process.
*
* The new system I created to fix this.
* Works like this it everytime this runs matches up 1 GE Buying/Selling auction.
* Then loops it 100 times or until no more matches are possible.
*
* TODO: Match Buyer's of larger item quantity with Sellers with larger quanity instead of Sellers with
* any item quantity. (this requires editing the query below to a better suited query).
*/
BuyOffer buyer = null;
SellOffer seller = null;
int itemId;
int itemAmount;
int price;
int sold;
int bought;
int collectedItem;
int collectedGold;
int overpaid;
byte slot;
long playerHash;
SQLiteDatabase db = new SQLiteDatabase(Constants.databaseName);
for (int processNumSales = 0; processNumSales < 100; processNumSales++)
{
soldBoughtItems.Clear();
//Can't do more then 1 sale at a time, LIMIT 100 wont work since it will pick duplicate sellers.
DataTable dt = db.ExecuteQuery("SELECT S.itemId AS sell_itemId, S.amount AS sell_amount, S.price AS sell_price, S.sold AS sell_sold, S.collectedItem AS sell_collectedItem, S.collectedGold AS sell_collectedGold, S.overpaid AS sell_overpaid, S.slot AS sell_slot, S.playerHash AS sell_playerHash, B.itemId AS buy_itemId, B.amount AS buy_amount, B.price AS buy_price, B.bought AS buy_bought, B.collectedItem AS buy_collectedItem, B.collectedGold AS buy_collectedGold, B.overpaid AS buy_overpaid, B.slot AS buy_slot, B.playerHash AS buy_playerHash FROM grandExchangeBuying AS B, grandExchangeSelling AS S ON B.itemId = S.itemId AND B.aborted = 0 AND S.aborted = 0 AND B.price >= S.price AND S.sold < S.amount AND B.bought < B.amount ORDER BY B.price DESC LIMIT 1");
if (dt.Rows.Count == 0)
{
db.CloseDatabase();
return;
}
else
{
itemId = Convert.ToInt32(dt.Rows[0]["sell_itemId"]);
itemAmount = Convert.ToInt32(dt.Rows[0]["sell_amount"]);
price = Convert.ToInt32(dt.Rows[0]["sell_price"]);
sold = Convert.ToInt32(dt.Rows[0]["sell_sold"]);
collectedItem = Convert.ToInt32(dt.Rows[0]["sell_collectedItem"]);
collectedGold = Convert.ToInt32(dt.Rows[0]["sell_collectedGold"]);
overpaid = Convert.ToInt32(dt.Rows[0]["sell_overpaid"]);
slot = Convert.ToByte(dt.Rows[0]["sell_slot"]);
playerHash = (long)dt.Rows[0]["sell_playerHash"];
seller = new SellOffer(itemId, itemAmount, price, sold, collectedItem, collectedGold, overpaid, slot, playerHash);
itemId = Convert.ToInt32(dt.Rows[0]["buy_itemId"]);
itemAmount = Convert.ToInt32(dt.Rows[0]["buy_amount"]);
price = Convert.ToInt32(dt.Rows[0]["buy_price"]);
bought = Convert.ToInt32(dt.Rows[0]["buy_bought"]);
collectedItem = Convert.ToInt32(dt.Rows[0]["buy_collectedItem"]);
collectedGold = Convert.ToInt32(dt.Rows[0]["buy_collectedGold"]);
overpaid = Convert.ToInt32(dt.Rows[0]["buy_overpaid"]);
slot = Convert.ToByte(dt.Rows[0]["buy_slot"]);
playerHash = (long)dt.Rows[0]["buy_playerHash"];
buyer = new BuyOffer(itemId, itemAmount, price, bought, collectedItem, collectedGold, overpaid, slot, playerHash);
}
if (seller == null || buyer == null) continue;
int amountToBuy = buyer.getTotalAmount() - buyer.getAmountTraded();
int amountToSell = seller.getTotalAmount() - seller.getAmountTraded();
// This check will never happen. SQL Query will not allow it.. Just old code I left in.
if (amountToBuy <= 0 || amountToSell <= 0)
continue;
int amount = (amountToBuy > amountToSell) ? amountToSell : amountToBuy;
// Buys from Seller a random amount of a item.
amount = misc.random(1, amount);
// Buyer will pay minimum what the seller wants.
int amountBuyerOverpaid = (buyer.getPriceEach() - seller.getPriceEach()) * amount; // buyer is paying more than the seller wants, therefore MAY recieve this amount as a refund.
bool buyerKeepsRefund = misc.random(1) == 0; // if 0, the buyer gets a refund, if its 1...the seller gets more.
buyer.setAmountTraded(buyer.getAmountTraded() + amount);
seller.setAmountTraded(seller.getAmountTraded() + amount);
/**
* How much refunded gold Buyer gets in addition to his previous refunded gold.
* or
* How much of the Buyer's overpaid gold that they couldn't keep goes as extra profit to the Seller.
*/
if (buyerKeepsRefund && amountBuyerOverpaid > 0)
buyer.setAmountOverpaid(buyer.getAmountOverpaid() + amountBuyerOverpaid);
else if (!buyerKeepsRefund && amountBuyerOverpaid > 0)
seller.setAmountOverpaid(seller.getAmountOverpaid() + amountBuyerOverpaid);
// Shows amount of Item Buyer bought in Slot 1 minus how much he already took out.
if (buyer.getAmountItemsLeftToCollect() > 0)
buyer.setSlot1(new Item(buyer.getItem(), buyer.getAmountItemsLeftToCollect()));
//Shows amount of Gold Buyer has in Slot 2 from previous refunded money plus how much he maybe will be refunded this sale.
if ((buyer.getAmountCollectedGold() < buyer.getAmountOverpaid()) && (buyer.getAmountOverpaid() - buyer.getAmountCollectedGold()) > 0)
buyer.setSlot2(new Item(995, (buyer.getAmountOverpaid() - buyer.getAmountCollectedGold())));
//Shows amount of Gold Seller in Slot 2 has minus how much he already took out.
if (seller.getAmountGoldLeftToCollect() > 0)
seller.setSlot2(new Item(995, seller.getAmountGoldLeftToCollect()));
Player buyerP = Server.getPlayerForName(buyer.getPlayerName());
Player sellerP = Server.getPlayerForName(seller.getPlayerName());
//Update both Buyer and Seller's Slots in the database
try
{
db.ExecuteNonQuery("UPDATE grandExchangeBuying SET bought = " + buyer.getAmountTraded() + ", overpaid = " + buyer.getAmountOverpaid() + " WHERE slot = " + buyer.getSlot() + " AND playerHash = " + buyer.getPlayerHash());
db.ExecuteNonQuery("UPDATE grandExchangeSelling SET sold = " + seller.getAmountTraded() + ", overpaid = " + seller.getAmountOverpaid() + " WHERE slot = " + seller.getSlot() + " AND playerHash = " + seller.getPlayerHash());
}
catch (Exception e)
{
//Instantly skip this sale if any database errors occurred.
//If one of those queries works and other fails then you will have a dupe -_-.
//TODO: A fix would be to keep retrying both queries until both successful.
misc.WriteError("[GrandExchange SQL Error]: " + e.Message);
continue;
}
/*
* TODO: Fix When player is offline and logs in after item is bought. He won't see messages below..
* Add something to Packets.cs (sendLogin() method) to process this.
* Maybe a (boolean in playerSaves for GE update?)
*/
if (buyerP != null)
{
buyerP.getPackets().sendMessage("One or more of your Grand Exchange offers has been updated.");
buyerP.getPackets().updateGEProgress(buyer);
if (buyerP.getGESession() != null)
{
Item[] items = { buyer.getSlot1(), buyer.getSlot2() };
buyerP.getPackets().sendItems(-1, -1757, 523 + buyer.getSlot(), items);
}
}
/*
* TODO: Fix When player is offline and logs in after item is bought. He won't see messages below..
* Add something to Packets.cs (sendLogin() method) to process this.
* Maybe a (boolean in playerSaves for GE update?)
*/
if (sellerP != null)
{
sellerP.getPackets().sendMessage("One or more of your Grand Exchange offers has been updated.");
sellerP.getPackets().updateGEProgress(seller);
if (sellerP.getGESession() != null)
{
Item[] items = { seller.getSlot1(), seller.getSlot2() };
sellerP.getPackets().sendItems(-1, -1757, 523 + seller.getSlot(), items);
}
}
}
}
