private bool executeSync(string q) { XDLINE xdl = new XDLINE(); string[] res = xdl.executeQuery(q); return(res[0] == "Success"); }
public MainWindow() { InitializeComponent(); // FindVisualChildren<TextBox>(AccountsTbl).ElementAt(0).TextChanged += showTextTB; if (!xdl.OpenConnection()) { MessageBox.Show("Cannot Connect to the Database!"); Environment.Exit(0); } else { xdl.CloseConnection(); StringComparer stringComparer = StringComparer.OrdinalIgnoreCase; systemui = new UserInterface(); xdl = new XDLINE(); initializeControls(); XDLINE.isOnline = online_switch.IsChecked; sqlsync.loadDumpList(dumqlList); student.loadStudentList(studentList); rec.loadAttendanceRecords(attendance_List); adm.loadAccountlist(AccountsTbl); //MessageBox.Show(xdl_offline.OpenConnection().ToString()); //MessageBox.Show(xdl_online.OpenConnection().ToString()); } showPorts(); }
public bool perfromSync() { XDLINE.isOnline = true; XDLINE xdl = new XDLINE(); bool result = false; List <string>[] queries = this.selectItems("dump_query_table", "query_id, query", new string[] { "query_id", "query" }, ""); int numberOfQueries = queries[0].Count(); for (int i = 0; i < numberOfQueries; i++) { result = executeSync(queries[1].ElementAt(i)); if (result) { XDLINE.isOnline = false; XDLINE xdll = new XDLINE(); xdll.deleteQuery("dump_query_table", "query_id = " + queries[0].ElementAt(i)); } XDLINE.isOnline = true; } XDLINE.isOnline = false; return(result); }