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;
}
