private static async void ReadConfig(string versionNum)
{
var wayPoint = new Waypoint();
Navigator.NavigationService = wayPoint.NavigationFrame.NavigationService;
ResultSet rs = await SQL_search.RunQueryAsync("db_lighthouse", "SELECT * FROM [@profiles] WHERE COMPUTER ='" + Environment.MachineName + "'");
if (rs?.recordCount > 0)
{
var dbVer = rs.dataSet.Tables[0].Rows[0]["VERSION"].ToString();
UserSettings.uniqueId = rs.dataSet.Tables[0].Rows[0]["ID"].ToString();
UserSettings.pcName = rs.dataSet.Tables[0].Rows[0]["COMPUTER"].ToString();
UserSettings.username = rs.dataSet.Tables[0].Rows[0]["USERNAME"].ToString();
//UserSettings.version = rs.dataSet.Tables[0].Rows[0]["VERSION"].ToString();
UserSettings.accounting = Convert.ToInt32(rs.dataSet.Tables[0].Rows[0]["ACCESS_ACCOUNTING"]) == 1 ? true : false;
UserSettings.shipping = Convert.ToInt32(rs.dataSet.Tables[0].Rows[0]["ACCESS_SHIPPING"]) == 1 ? true : false;
UserSettings.infotech = Convert.ToInt32(rs.dataSet.Tables[0].Rows[0]["ACCESS_INFOTECH"]) == 1 ? true : false;
//checks for recorded version number -------
if (UserSettings.version == dbVer)
{
return;
}
//updates new version number -----------
SQL_general.UpdateComputer("db_lighthouse", versionNum, UserSettings.uniqueId);
}
else
{
SQL_general.InsertComputer("db_lighthouse", Environment.MachineName, versionNum, versionNum);
}
wayPoint.Show();
}
public void UpdateConfig(string appName)
{
string notes = null;
if (TxtMachineNotes.Text.Length > 0)
{
notes = TxtMachineNotes.Text;
}
MachineData.appLocation = CmbMachineLocation.Text;
SQL_general.InsertComputer("db_Harbor", Environment.MachineName, MachineData.appLocation, TxtMachineNumber.Text, appName, notes, MachineData.appVersion);
}
