Esempio n. 1
0
        public List <HistoryItem> getHistoryBrowser()
        {
            List <HistoryItem> allHistoryItems   = new List <HistoryItem>();
            string             chromeHistoryFile = @"C:\Users\" + UserName + @"\AppData\Local\Google\Chrome\User Data\Default\History";

            if (File.Exists(chromeHistoryFile))
            {
                using (SQLiteConnection connection
                           = new SQLiteConnection("Data Source=" + chromeHistoryFile))
                {
                    connection.Open();

                    String command = "select * from urls order by last_visit_time desc limit "
                                     + NumURL.ToString();
                    SQLiteDataAdapter adapter = new SQLiteDataAdapter(command, connection);
                    DataSet           dataset = new DataSet();
                    adapter.Fill(dataset);
                    if (dataset != null && dataset.Tables.Count > 0 & dataset.Tables[0] != null)
                    {
                        DataTable dt = dataset.Tables[0];
                        foreach (DataRow historyRow in dt.Rows)
                        {
                            HistoryItem historyItem = new HistoryItem();
                            historyItem.URL   = Convert.ToString(historyRow["url"]);
                            historyItem.Title = Convert.ToString(historyRow["title"]);
                            long     utcMicroSeconds = Convert.ToInt64(historyRow["last_visit_time"]);
                            DateTime gmtTime         = DateTime.FromFileTimeUtc(10 * utcMicroSeconds);
                            DateTime localTime       = TimeZoneInfo.ConvertTimeFromUtc
                                                           (gmtTime, TimeZoneInfo.Local);
                            historyItem.VisitedTime = localTime;
                            allHistoryItems.Add(historyItem);
                        }
                    }
                }
            }
            return(allHistoryItems);
        }
Esempio n. 2
0
 public GetContentFromURL(HistoryItem item)
 {
     this.item = item;
 }