using System;
using System.Data.SQLite;
using System.Collections;
 
namespace Dizzy
{
 
 
	public class FileList
	{
 
		SQLiteConnection connection;
 
		public FileList() {
			string connectionString = "Data Source=" + GlobalConfig.ListFileName () + ";Version=3";
			this.connection = new SQLiteConnection(connectionString);
		}
 
		public ArrayList Search(string keyword, string type, string user) {
 
			this.connection.Open ();
			ArrayList matches = new ArrayList ();
 
			// Eseguiamo la query
			SQLiteCommand sqlCmd = this.connection.CreateCommand ();
			sqlCmd.CommandText = "SELECT * from files WHERE name LIKE '%" + keyword + "%'";
			SQLiteDataReader reader = sqlCmd.ExecuteReader ();
 
			File tmp;
			while(reader.Read())
			{
				tmp = new File(reader.GetString(0),   // Path
				                      reader.GetString(2),   // User
				                      reader.GetString(1),   // Name
				                      reader.GetInt32(3));  // Size
 
				if ( (type == "Qualsiasi" || tmp.type.Name() == type) &&
				     (user == "" || user == tmp.user) )
				{
					matches.Add (tmp);
				}
			}
 
			this.connection.Close ();
			return matches;
		}
	}
}