public TagAction GetNextTagAction()
{
using (var connection = new SQLiteConnection(DatabaseFilename))
{
using (var statement = connection.Prepare(@"SELECT ID, ITEM_ID, TAG, ACTION_KIND FROM TAG_ACTION ORDER BY ID LIMIT 1;"))
{
if (statement.Step() != SQLiteResult.ROW)
{
return(null);
}
var item = new TagAction
{
Id = statement.GetInteger(0),
ItemId = statement.GetText(1),
Tag = statement.GetText(2),
Kind = (TagActionKind)statement.GetInteger(3)
};
return(item);
}
}
}
public TagAction GetNextTagAction()
{
using (var connection = new SQLiteConnection(DatabaseFilename))
{
using (var statement = connection.Prepare(@"SELECT ID, ITEM_ID, TAG, ACTION_KIND FROM TAG_ACTION ORDER BY ID LIMIT 1;"))
{
if (statement.Step() != SQLiteResult.ROW)
return null;
var item = new TagAction
{
Id = statement.GetInteger(0),
ItemId = statement.GetText(1),
Tag = statement.GetText(2),
Kind = (TagActionKind)statement.GetInteger(3)
};
return item;
}
}
}
