private static void CacheMunisTable(string tableName, string primaryKey, DbTransaction trans = null)
{
using (var results = MunisDatabase.ReturnSqlTable("SELECT * FROM " + tableName))
{
results.TableName = tableName;
SqliteFunctions.AddTableToCacheDB(results, primaryKey, trans);
}
}
private static void CacheFATable(DbTransaction trans = null)
{
using (var results = MunisDatabase.ReturnSqlTable(Queries.Munis.SelectAllScanItems()))
{
results.TableName = MunisFixedAssetTable.TableName;
SqliteFunctions.AddTableToCacheDB(results, MunisFixedAssetTable.Asset, trans);
}
}
private static void CacheAssetTable(string tableName, string primaryKey, DbTransaction trans = null)
{
using (var results = DBFactory.GetMySqlDatabase().DataTableFromQueryString("SELECT * FROM " + tableName))
{
results.TableName = tableName;
SqliteFunctions.AddTableToCacheDB(results, primaryKey, trans);
}
}
