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