Exemplo n.º 1
0
        private void WriteLogToDatabase()
        {
            // open our db connection
            SQLiteConnection database = DatabaseUtils.ConnectToDatabase();

            // insert our new stats record
            SiteData newSiteData = new SiteData();

            newSiteData.WebsiteName = WebsiteName;
            newSiteData.Status      = Status.ToString();
            newSiteData.Date        = DateTime.Now;
            newSiteData.HTML        = PageHTML;
            database.Execute("INSERT INTO SiteData (WebsiteName, Status, Date, HTML) VALUES (@WebsiteName, @Status, @Date, @HTML)", newSiteData);

            // close our db connection
            database.Close();
        }