public List<Component> getComponentListByType(String type)
{
//Get components Type == type
/*SqlCeEngine engine = new SqlCeEngine(StrCon);
engine.Upgrade();*/
List<Component> auxList = new List<Component>();
Component aux = null;
string query = "SELECT * FROM ComponentRepository WHERE Type='" + type + "'";
OleDbConnection conn = new OleDbConnection(StrCon);
OleDbCommand cmd = new OleDbCommand(query, conn);
conn.Open();
OleDbDataReader rdr = cmd.ExecuteReader();
try
{
// Iterate through the results
//
while (rdr.Read())
{
aux = new Component(DB_path);
aux.ID = rdr.GetInt32(0);
aux.Name = rdr.GetString(1);
aux.Description = rdr.GetString(2);
aux.Path = rdr.GetString(3);
aux.setType(rdr.GetString(4));
//aux.Date_added = rdr.GetString(4);
//aux.Download_counter = rdr.GetInt32(5);
/*if (!rdr.IsDBNull(6))
{
aux.Type = rdr.GetString(6);
}*/
auxList.Add(aux);
Console.WriteLine(aux.toString());
}
}
finally
{
// Always call Close when done reading
rdr.Close();
// Always call Close when done reading
conn.Close();
}
return auxList;
}
// Class Methods
public List<Component> getComponentList()
{
//Get all components
List<Component> auxList = new List<Component>();
Component aux = null;
string query = "SELECT * FROM ComponentRepository";
//OleDbConnection conn = new OleDbConnection(StrCon);
// Read all the table
OleDbConnection conexion;
OleDbDataReader rdr;
/*SqlEngine engine = new SqlEngine(StrCon);
engine.Upgrade();*/
try
{
conexion = new OleDbConnection(StrCon);
OleDbCommand cmd = new OleDbCommand(query, conexion);
conexion.Open();
rdr = cmd.ExecuteReader();
// Iterate through the results
while (rdr.Read())
{
// Create the component
aux = new Component(DB_path);
string type = Convert.ToString(rdr.GetValue(0).GetType());
aux.ID = Convert.ToInt32(rdr.GetInt32(0));
aux.Name = rdr.GetString(1);
aux.Description = rdr.GetString(2);
aux.Path = rdr.GetString(3);
aux.setType(rdr.GetString(4));
//aux.Date_added = rdr.GetString(4);
aux.Download_counter = rdr.GetInt32(5);
/*if (!rdr.IsDBNull(6))
{
aux.Type = rdr.GetString(6);
}*/
// Add the component to the list
auxList.Add(aux);
Console.WriteLine(aux.toString());
}
rdr.Close();
conexion.Close();
}
catch (Exception ex)
{
Component c = new Component(DB_path);
c.setDescription(ex.Message);
auxList.Add(c);
Console.WriteLine(ex.ToString());
}
/*finally
{
// Always call Close when done reading
//rdr.Close();
// Always call Close when done reading
//conexion.Close();
}*/
return auxList;
}
