public static void StoreGroups(ObservableCollectionDisp<Core.Group> groups)
{
try
{
using (SQLiteTransaction transaction = _connection.BeginTransaction())
{
foreach (Group group in groups)
{
Dictionary<string, object> values = group.GetData();
SaveOrUpdate(values, "Name", "Group", false, _connection);
}
transaction.Commit();
}
}
catch (Exception e)
{
Events.Instance.OnEvent(e, new EventError(e.Message, null));
}
}
public static void ReadGroups(ObservableCollectionDisp<Group> groups)
{
groups.Clear();
try
{
using (SQLiteCommand command = _connection.CreateCommand())
{
command.CommandText = "SELECT * FROM [Group]";
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
groups.Add(new Group(reader));
}
reader.Close();
}
}
catch (Exception e)
{
Events.Instance.OnEvent(e, new EventError(e.Message, null));
}
}
