public AuctionLoader(string connstr, string apikey, string realmname)
{
_connstr = connstr;
_conn = new SqlConnection(_connstr);
_conn.Open();
_explorer = new WowExplorer(Region.US, Locale.en_US, apikey);
_af = _explorer.GetAuctionFiles(realmname);
_ah = _explorer.GetAuctions(realmname);
_dt = new DataTable();
_dt.Columns.Add("ID");
_dt.Columns.Add("ItemID");
_dt.Columns.Add("Owner");
_dt.Columns.Add("Bid");
_dt.Columns.Add("BuyOut");
_dt.Columns.Add("Quantity");
_dt.Columns.Add("TimeLeft");
_dt.Columns.Add("LoadDate");
_dt.Columns["LoadDate"].DataType = typeof(DateTime);
_dateTimeOffset = DateTimeOffset.FromUnixTimeMilliseconds(_af.Files.Take(1).Select(x => x.LastModified).ToArray()[0]);
_dt.Columns["LoadDate"].DefaultValue = _dateTimeOffset.DateTime;
}
