public List <Searchinfo> getAllSearchInfo() { MySqlConnection conn = connect(); MySqlCommand cmd = new MySqlCommand("select * from search where deleted = " + 0, conn); MySqlDataReader reader = null; try { if (conn.State == ConnectionState.Closed) { conn.Open(); } reader = cmd.ExecuteReader(); List <Searchinfo> temp = new List <Searchinfo>(); while (reader.Read()) { String inc = reader["include"] as String; String exc = reader["exclude"] as String; List <String> includeL = new List <string>(); List <String> excludeL = new List <string>(); if (inc != null) { includeL = inc.Split('\n').ToList(); } if (exc != null) { excludeL = exc.Split('\n').ToList(); } Searchinfo dd = new Searchinfo((int)reader["searchId"], (String)reader["searchTitle"], (bool)reader["deleted"], (int)reader["searchStatus"], includeL, excludeL, (DateTime)(reader["startDate"] as DateTime?), reader["endDate"] as DateTime?, reader["firstTwitterDate"] as DateTime?, reader["tempLastTwitterDate"] as DateTime?, (long)reader["tempLastTwitterId"], reader["finishedLastTwitterDate"] as DateTime?, (long)reader["finishedLastTwitterId"]); temp.Add(dd); } return(temp); } catch (Exception ex) { if (config.debug) { throw ex; } else { throw ex; } } finally { if (reader != null) { reader.Close(); } conn.Close(); } }
public TwitterSearch(Searchinfo si) // for resume { this.dataBase = new MysqlHelper(); this.searchInfo = si; onResume(); }