/// <summary>
/// Méthode qui permet de récupérer les metaSlot d'un metaModule
/// </summary>
public List <MetaSlot> listMetaSlot(string refe)
{
List <MetaSlot> listMetaS = new List <MetaSlot>();
conn.LiteCo.Open();
SQLQuery = "SELECT * FROM metaslot WHERE refMetaModule = '" + refe + "';";
using (SQLiteCommand command = new SQLiteCommand(SQLQuery, conn.LiteCo))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
try
{
while (reader.Read())
{
MetaSlot metaS = new MetaSlot
(
reader.GetInt32(0),
reader.GetInt32(1),
reader.GetString(2),
reader.GetString(3)
);
listMetaS.Add(metaS);
}
}
catch (SQLiteException ex)
{
Trace.WriteLine(ex.ToString());
}
conn.LiteCo.Close();
return(listMetaS);
}
}
}
private MetaSlot GetMetaSlotById(int id)
{
SQLQuery = "SELECT * FROM metaslot WHERE idMetaSlot = " + id;
SQLiteCommand command = (SQLiteCommand)conn.LiteCo.CreateCommand();
command.CommandText = SQLQuery;
using (var reader = command.ExecuteReader())
{
MetaSlot metaslot = new MetaSlot(reader.GetInt32(0), reader.GetInt32(1), reader.GetString(2), reader.GetString(3));
reader.Close();
return(metaslot);
}
}
