private void ReadConfig()
{
var waypt = new Waypoint();
if (VerifyDatabaseConnection())
{
SQL_search.RunQuery("db_Harbor", "SELECT * FROM [@profiles] WHERE COMPUTER ='" + Environment.MachineName + "'");
if (SQL_search.RecordCount > 0)
{
var dbId = SQL_search.Ds.Tables[0].Rows[0]["ID"].ToString();
var dbVersion = SQL_search.Ds.Tables[0].Rows[0]["VERSION"].ToString();
MachineData.appLocation = SQL_search.Ds.Tables[0].Rows[0]["LOCATION"].ToString();
LoadApplication(SQL_search.Ds.Tables[0].Rows[0]["APPLICATION"].ToString());
//checks for recorded version number -------
if (MachineData.appVersion == dbVersion)
{
return;
}
//updates new version number -----------
SQL_general.UpdateComputer("db_Harbor", MachineData.appVersion, dbId);
}
else
{
waypt.Show();
}
}
else
{
waypt.Show();
}
}
private void LoadApplication(string appName)
{
SQL_general.UpdatePoweredOn();
switch (appName)
{
case "DockScheduleDisplay":
var vm1 = new DockSchedule_VM();
var page1 = new DockSchedule {
DataContext = vm1
};
Navigator.NavigationService = page1.NavigationFrame.NavigationService;
page1.NavButtons.ShowPreview();
page1.Show();
break;
case "DockScheduleTouch":
var vm2 = new DockSchedule_VM();
var page2 = new DockSchedule {
DataContext = vm2
};
Navigator.NavigationService = page2.NavigationFrame.NavigationService;
page2.NavButtons.ShowInteractive();
page2.Show();
break;
case "MachineOperations":
var vm3 = new MachineOperations_VM();
var page3 = new MachineOperations();
Navigator.NavigationService = page3.NavigationFrame.NavigationService;
page3.DataContext = vm3;
page3.Show();
break;
}
}
public static void LogError(string custom, string message, string stackTrace, string source, string targetSite)
{
var dateTime = DateTime.Now.ToString();
var version = Assembly.GetExecutingAssembly().GetName().Version.ToString();
SQL_general.InsertLog("db_Harbor", dateTime, Environment.MachineName, version, custom, message, stackTrace, source, targetSite);
}
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();
}
private void Unlock_Click(object sender, System.Windows.RoutedEventArgs e)
{
if (PswModuleUnlock.Password == password)
{
var column = "";
switch (_vm.PageType)
{
case "Shipping":
column = "ACCESS_SHIPPING";
UserSettings.shipping = true;
break;
case "Accounting":
column = "ACCESS_ACCOUNTING";
UserSettings.accounting = true;
break;
case "Technology":
column = "ACCESS_INFOTECH";
UserSettings.infotech = true;
break;
}
SQL_general.UpdatePermission("db_lighthouse", column);
_parent._vm.AccessSelectedPage(_vm.PageType);
}
PswModuleUnlock.Password = "";
}
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);
}
public void clockDispatcherTimer_Tick(object sender, EventArgs e)
{
var now = DateTime.Now;
if (now.Minute == 0 && now.Second == 0)
{
PrepareSilent();
}
if (now.Minute == 0 && now.Second == 30)
{
SQL_general.UpdatePoweredOn();
}
}
