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);
}
}
public async void StartScan(Location location, DateTime datestamp, string scanEmployee)
{
currentScan = InsertNewScan(location, datestamp, scanEmployee);
//var scanItemsQuery = Queries.Munis.SelectScanItemsByDepartment(location.DepartmentCode);
//var scanItemsQuery = Queries.Munis.SelectScanItemsByLocation(location.MunisCode);
var scanItemsQuery = Queries.Munis.SelectAllScanItems();
using (var munisResults = await MunisDatabase.ReturnSqlTableAsync(scanItemsQuery))
using (var assetResults = GetAssetManagerResults(munisResults))
{
munisResults.TableName = MunisFixedAssetTable.TableName;
CleanMunisFields(munisResults);
CacheScanDetails(munisResults, MunisFixedAssetTable.Asset, assetResults, DeviceTable.Id, currentScan.ID);
SyncDataAsync();
LoadCurrentScanItems();
}
syncTimer.Start();
}
