public List<Image> loadQueryImages(Query query) { sqliteDbConnection.Open(); List<Image> imageList = new List<Image>(); SQLiteCommand cmd = sqliteDbConnection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * FROM Query INNER JOIN Image ON Query.QueryId=Image.QueryId WHERE Query.QueryId = @queryId"; cmd.Parameters.Add(new SQLiteParameter("@queryId", query.queryId)); SQLiteDataReader reader = cmd.ExecuteReader(); Image tempImage; while (reader.Read()) { tempImage = new Image(); tempImage.link = crypt.DecryptString(reader["Url"].ToString()); tempImage.title = crypt.DecryptString(reader["Title"].ToString()); tempImage.path = reader["Path"].ToString(); imageList.Add(tempImage); } sqliteDbConnection.Close(); return imageList; }
public List<Query> loadQuerys() { List<Query> queryList = new List<Query>(); sqliteDbConnection.Open(); SQLiteCommand cmd = sqliteDbConnection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * FROM Query INNER JOIN Image ON Query.QueryId=Image.QueryId GROUP BY Query.QueryId"; SQLiteDataReader reader = cmd.ExecuteReader(); Query tempQuery; while(reader.Read()) { tempQuery = new Query(); tempQuery.queryId = (reader["queryId"].ToString()); tempQuery.queryText = crypt.DecryptString(reader["queryString"].ToString()); queryList.Add(tempQuery); } sqliteDbConnection.Close(); return queryList; }