public void GetAllLogsFor(int id, UnityAction <SqlDescription[]> done)
{
// TODO finish me.
Thread thread = new Thread(() =>
{
List <SqlDescription> descriptions = new List <SqlDescription>();
string cmd = "SELECT * FROM " + logTable + " WHERE id = " + id.ToString() + ";";
using (MySqlDataReader reader = ExecuteReader(cmd))
{
while (reader.Read())
{
string notes = reader.GetString("description");
DateTime time = reader.GetDateTime("time");
int balanceChange = reader.GetInt32("balanceChange");
SqlDescription description = new SqlDescription()
{
Description = notes, Time = time, BalanceChange = balanceChange
};
descriptions.Add(description);
}
}
done.Invoke(descriptions.ToArray());
});
thread.Start();
}
public bool InFilter(string filterText)
{
return(ModuleName.Contains(filterText) ||
PageName.Contains(filterText) ||
PageID.Contains(filterText) ||
ActionName.Contains(filterText) ||
ActionTitle.Contains(filterText) ||
SqlGroupName.Contains(filterText) ||
SqlTableName.Contains(filterText) ||
SqlName.Contains(filterText) ||
SqlDescription.Contains(filterText));
}
