private void LoadAdminFingerprints() { if (database.Connect()) { try { database.MyComm = new MySql.Data.MySqlClient.MySqlCommand("SELECT id, fingerprint FROM admninistrators", database.MyConn); database.MyReader = database.MyComm.ExecuteReader(); if (database.MyReader.HasRows) { while (database.MyReader.Read()) { AdminFingerPrints.AddFirst(fingerprintReader.DeserializeData(database.MyReader.GetString("fingerprint"))); AdminId.AddFirst(database.MyReader.GetInt32("id")); } } database.MyReader.Close(); database.MyReader.Dispose(); } catch (Exception) { ShowError("Database error", "Error while fetching data from database. Please try again later. Thank you!"); } database.Close(); } else { ShowError("Database error", "Error while connecting to database, please try again later. Thank you."); } }
public void initializeAllAdminFingerprintData() { myDatabase = new Database(); if (myDatabase.Connect()) { try { myDatabase.MyComm = new MySql.Data.MySqlClient.MySqlCommand("SELECT fingerprint FROM admninistrators", myDatabase.MyConn); myDatabase.MyReader = myDatabase.MyComm.ExecuteReader(); if (myDatabase.MyReader.HasRows) { while (myDatabase.MyReader.Read()) { adminsFingerprintData.AddFirst(fingerprintReader.DeserializeData(myDatabase.MyReader.GetString("fingerprint"))); } } myDatabase.MyReader.Close(); myDatabase.MyReader.Dispose(); } catch (Exception e) { MessageBox.Show("Cannot fetch to database, please try again later. " + e, "Database error", MessageBoxButton.OK, MessageBoxImage.Error); myDatabase.Close(); this.Close(); } myDatabase.Close(); } else { MessageBox.Show("Cannot connect to database, please try again later.", "Database error", MessageBoxButton.OK, MessageBoxImage.Error); this.Close(); } }
private void GetStudentFingerprints() { if (database.Connect()) { try { database.MyComm = new MySql.Data.MySqlClient.MySqlCommand("SELECT student_id, fingerprint FROM students WHERE fingerprint != ''", database.MyConn); database.MyReader = database.MyComm.ExecuteReader(); if (database.MyReader.HasRows) { while (database.MyReader.Read()) { studentFmds.AddFirst(fingerprintReader.DeserializeData(database.MyReader.GetString("fingerprint"))); studentIds.AddFirst(database.MyReader.GetString("student_id")); } } database.MyReader.Close(); database.MyReader.Dispose(); } catch (Exception e) { MessageBox.Show("Sorry cannot fetch student data from database.\nPlease try again later.\n" + e, "Databse Error", MessageBoxButton.OK, MessageBoxImage.Error); this.Close(); } database.Close(); } else { MessageBox.Show("Sorry cannot connect to the database.\nPlease try again later.", "Databse Error", MessageBoxButton.OK, MessageBoxImage.Error); this.Close(); } }