public Form1()
{
InitializeComponent();
// grab the user settings
XmlSerializer mySerializer = new XmlSerializer(typeof(UserSettings));
FileStream userSettingsFileStream = new FileStream("UserSettings.xml", FileMode.Open);
UserSettings settings = (UserSettings)mySerializer.Deserialize(userSettingsFileStream);
userSettingsFileStream.Close();
address = settings.Address;
// set the last scrape label
SQLiteConnection database = DatabaseUtils.ConnectToDatabase();
ScraperStats stats = database.Query <ScraperStats>("SELECT * FROM ScraperStats ORDER BY LastScrapeDate").FirstOrDefault();
if (stats != null)
{
// if we have stats - update the labels
numOfScrapes = stats.TotalScrapes;
lastScrapeDate = stats.LastScrapeDate;
LastRunDate.Text = "Last Scrape Date: " + lastScrapeDate.ToShortDateString();
TotalScraptes.Text = "Total Scrapes: " + numOfScrapes.ToString();
}
database.Close();
}
/// <summary>
/// Updates the Scraper Stats labels
/// </summary>
private void updateScraperStatsLabels()
{
SQLiteConnection database = DatabaseUtils.ConnectToDatabase();
ScraperStats stats = database.Query <ScraperStats>("SELECT * FROM ScraperStats ORDER BY LastScrapeDate").FirstOrDefault();
if (stats != null)
{
// if we have stats - update the labels
numOfScrapes = stats.TotalScrapes;
lastScrapeDate = stats.LastScrapeDate;
if (LastRunDate.InvokeRequired)
{
LastRunDate.Invoke(new Action(() => LastRunDate.Text = "Last Scrape Date: " + lastScrapeDate.ToShortDateString()));
}
LastRunDate.Text = "Last Scrape Date: " + lastScrapeDate.ToShortDateString();
if (TotalScraptes.InvokeRequired)
{
TotalScraptes.Invoke(new Action(() => TotalScraptes.Text = "Total Scrapes: " + numOfScrapes.ToString()));
}
TotalScraptes.Text = "Total Scrapes: " + numOfScrapes.ToString();
}
database.Close();
return;
}
public static void UpdateScraperStats()
{
SQLiteConnection database = ConnectToDatabase();
string currentDate = DateTime.Now.ToString();
int totalScrapes = 1;
ScraperStats stats = database.Query <ScraperStats>("SELECT * FROM ScraperStats ORDER BY LastScrapeDate").FirstOrDefault();
if (stats != null)
{
//check the stats and remove the old entry
totalScrapes = stats.TotalScrapes + 1;
database.Execute("DELETE FROM ScraperStats");
}
// insert our new stats record
ScraperStats newStats = new ScraperStats();
newStats.LastScrapeDate = DateTime.Now;
newStats.TotalScrapes = totalScrapes;
database.Execute("INSERT INTO ScraperStats (LastScrapeDate, TotalScrapes) VALUES (@LastScrapeDate, @TotalScrapes)", newStats);
database.Close();
}
