private bool Exists_Internal(string tokenID)
{
string result = null;
using (IDbConnection dbc = service.GetOpenConnection()) {
using (IDbCommand dbcmd = dbc.CreateCommand()) {
dbcmd.CommandText = String.Format("SELECT tokenID FROM TokenData WHERE {0}='{1}'", SQLiteFields.Name.TOKEN_ID, tokenID);
using (IDataReader dbr = dbcmd.ExecuteReader()) {
while (dbr.Read())
{
result = dbr.GetString(0);
}
}
}
}
return(result != null);
}
// Accessors
public void GetIDs(Action <string[], RequestStatus> OnGetIDs)
{
service.QueueTask(() => {
List <string> result = null;
using (IDbConnection dbc = service.GetOpenConnection()) {
using (IDbCommand dbcmd = dbc.CreateCommand()) {
dbcmd.CommandText = String.Format("SELECT {0} FROM QuestionData", SQLiteFields.Name.QUESTION_ID);
result = new List <string>();
using (IDataReader dbr = dbcmd.ExecuteReader()) {
while (dbr.Read())
{
int idx = dbr.GetOrdinal(SQLiteFields.Name.QUESTION_ID);
if (!dbr.IsDBNull(idx))
{
result.Add(dbr.GetString(idx));
}
}
}
}
}
return(result as object);
},
(resultObject) => {
if (OnGetIDs != null)
{
if (resultObject == null) // doesn't exist
{
OnGetIDs(null, RequestStatus.SQLITE_ERROR);
}
else
{
OnGetIDs((resultObject as List <string>).ToArray(), RequestStatus.SUCCESS);
}
}
});
}