public static void UpdateAuctions(Database db, string realmName, IBlizzardProgress bp)
{
Configuration cfg = db.Configurations.First();
if (db.Configurations.First().SelectedRealm != realmName)
{
cfg.SelectedRealm = realmName;
cfg.lastUpdate = 0;
db.Auctions.DeleteAllOnSubmit(db.Auctions);
db.SubmitChanges();
}
string realmSlug = db.Realms.Single(realm => realm.Name == realmName).Slug;
string url = "http://us.battle.net/api/wow/auction/data/" + realmSlug;
JsonValue status = JSON.JsonDecode(GetWebString(url));
if (status.Object.ContainsKey("files"))
{
long lastModified = status.Object["files"].Array[0].Object["lastModified"].Long;
if (cfg.lastUpdate != lastModified)
{
cfg.lastUpdate = lastModified;
db.SubmitChanges();
url = status.Object["files"].Array[0].Object["url"].String;
status = JSON.JsonDecode(GetWebString(url));
Dictionary<long, bool> webIds = new Dictionary<long, bool>();
UpdateAuctions(db, status, AuctionFaction.Alliance, webIds, bp);
UpdateAuctions(db, status, AuctionFaction.Horde, webIds, bp);
UpdateAuctions(db, status, AuctionFaction.Neutral, webIds, bp);
CloseAuctions(db, webIds, bp);
}
}
}
public static void UpdateRealms(Database db)
{
JsonValue status = JSON.JsonDecode(GetWebString("http://us.battle.net/api/wow/realm/status"));
if (status.Object.ContainsKey("realms"))
{
var query = from realm in status.Object["realms"].Array
select new Realm()
{
Name = realm.Object["name"].String,
Slug = realm.Object["slug"].String,
Queue = realm.Object["queue"].Boolean,
Status = realm.Object["status"].Boolean,
Population = realm.Object["population"].String == "high" ? RealmPopulation.High :
realm.Object["population"].String == "medium" ? RealmPopulation.Medium :
RealmPopulation.Low,
Type = realm.Object["type"].String == "pve" ? RealmType.PvE :
realm.Object["type"].String == "pvp" ? RealmType.PvP :
realm.Object["type"].String == "rp" ? RealmType.RP :
RealmType.RPPvP
};
foreach (Realm webRealm in query)
{
Realm dbRealm = db.Realms.SingleOrDefault(realm => realm.Name == webRealm.Name);
if (dbRealm != null)
{
dbRealm.Update(webRealm);
}
else
{
db.Realms.InsertOnSubmit(webRealm);
}
}
db.SubmitChanges();
// For each realm in the database see if it is still availabe from the web
foreach (Realm dbRealm in db.Realms)
{
Realm webRealm = query.SingleOrDefault(realm => realm.Name == dbRealm.Name);
if (webRealm == null)
{
db.Realms.DeleteOnSubmit(dbRealm);
}
}
db.SubmitChanges();
if (db.Configurations.First().SelectedRealm != null)
{
string selectedRealmName = db.Configurations.First().SelectedRealm;
Realm selectedRealm = db.Realms.SingleOrDefault(realm => realm.Name == selectedRealmName);
if (selectedRealm == null)
{
db.Configurations.First().SelectedRealm = null;
db.SubmitChanges();
}
}
}
}
public MainWindow()
{
InitializeComponent();
string dbName = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + "\\wma.mdf";
_database = Database.Open(dbName);
BlizzardAPI.UpdateRealms(_database);
realmComboBox.ItemsSource = from realm in _database.Realms select realm;
if (_database.Configurations.First().SelectedRealm != null)
{
_ignoreEvent = true;
realmComboBox.SelectedValue = _database.Configurations.First().SelectedRealm;
_ignoreEvent = false;
UpdateAuctionsListView();
}
}
private static void UpdateAuctions(Database db, JsonValue status, AuctionFaction faction, Dictionary<long, bool> webIds, IBlizzardProgress bp)
{
string factionName = (faction == AuctionFaction.Alliance) ? "alliance" :
(faction == AuctionFaction.Horde) ? "horde" :
"neutral";
if (status.Object.ContainsKey(factionName))
{
var query = from auction in status.Object[factionName].Object["auctions"].Array
select new Auction()
{
AuctionId = auction.Object["auc"].Long,
ItemId = auction.Object["item"].Long,
Owner = auction.Object["owner"].String,
Bid = auction.Object["bid"].Long,
Buyout = auction.Object["buyout"].Long,
Quantity = auction.Object["quantity"].Long,
TimeLeft = (auction.Object["timeLeft"].String == "VERY_LONG") ? AuctionTimeLeft.VeryLong :
(auction.Object["timeLeft"].String == "LONG") ? AuctionTimeLeft.Long :
(auction.Object["timeLeft"].String == "MEDIUM") ? AuctionTimeLeft.Medium :
AuctionTimeLeft.Short,
Faction = faction,
Status = AuctionStatus.Active,
FirstSeen = DateTime.Now,
LastSeen = DateTime.Now
};
int progressCurrent = 0;
int progressCount = query.Count();
bp.UpdateProgress(progressCurrent, progressCount);
foreach (Auction webAuction in query)
{
Auction dbAuction = db.Auctions.SingleOrDefault(auction => auction.AuctionId == webAuction.AuctionId);
if (dbAuction != null)
{
dbAuction.LastSeen = DateTime.Now;
dbAuction.TimeLeft = webAuction.TimeLeft;
}
else
{
db.Auctions.InsertOnSubmit(webAuction);
}
webIds[webAuction.AuctionId] = true;
progressCurrent++;
if (progressCurrent % 1000 == 0)
{
bp.UpdateProgress(progressCurrent, progressCount);
db.SubmitChanges();
}
}
bp.UpdateProgress(progressCount, progressCount);
db.SubmitChanges();
}
}
private static void CloseAuctions(Database db, Dictionary<long, bool> webIds, IBlizzardProgress bp)
{
var activeAuctions = (from auction in db.Auctions where auction.Status == AuctionStatus.Active select auction).ToList();
int progressCurrent = 0;
int progressCount = activeAuctions.Count;
bp.UpdateProgress(progressCurrent, progressCount);
foreach (Auction dbAuction in activeAuctions)
{
if (!webIds.ContainsKey(dbAuction.AuctionId))
{
dbAuction.Status = GetAuctionStatus(dbAuction.TimeLeft, dbAuction.LastSeen);
}
progressCurrent++;
if (progressCurrent % 1000 == 0)
{
bp.UpdateProgress(progressCurrent, progressCount);
db.SubmitChanges();
}
}
db.SubmitChanges();
}
public static Database Open(string dbName)
{
bool fRebuild = false;
// In the event that we call DeleteDatabase, we need to make sure it gets closed.
using (Database db = new Database(dbName))
{
if (!db.DatabaseExists())
fRebuild = true;
if (!fRebuild)
{
try
{
if (db.Configurations.Count() < 1 || db.Configurations.First().Version != Configuration.CurrentVersion)
fRebuild = true;
}
catch
{
fRebuild = true;
}
if (fRebuild)
{
db.DeleteDatabase();
}
}
}
Database result = new Database(dbName);
if (fRebuild)
{
result.CreateDatabase();
Configuration cfg = new Configuration() { Version = Configuration.CurrentVersion };
result.Configurations.InsertOnSubmit(cfg);
result.SubmitChanges();
}
return result;
}
