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); }