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