public override bool CheckRepeatedTest()
{
try
{
if (DB_Connection != null && DB_Connection.State == ConnectionState.Open)
{
MySqlCommand command = DB_Connection.CreateCommand();
command.CommandText = "SELECT * FROM " + SqlTable + " WHERE sn=" + SerialNumber + " AND test_flag=1;";
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read() && reader["sn"].ToString().Contains(SerialNumber))
{
DB_Connection.Close();
return(true);
}
DB_Connection.Close();
return(false);
}
else
{
return(false);
}
}
catch (Exception e)
{
Debug.WriteLine("Exception: " + e.Message);
return(false);
}
}
public void Login_Click(object sender, RoutedEventArgs e)
{
dbConnection.Open();
List <string> matrikelnummern = dbConnection.GetColumn("SELECT S_Matrikelnummer,S_Passwort FROM tbl_schueler;", 0);
List <string> passwoerter = dbConnection.GetColumn("SELECT S_Matrikelnummer,S_Passwort FROM tbl_schueler;", 1);
List <string> lkuerzel = dbConnection.GetColumn("SELECT L_Kuerzel,L_Passwort FROM tbl_lehrer;", 0);
List <string> lpasswoerter = dbConnection.GetColumn("SELECT L_Kuerzel,L_Passwort FROM tbl_lehrer;", 1);
if (Int64.TryParse(txtMatrikelnummer.Text, out long l))
{
for (int i = 0; i < matrikelnummern.Count; i++)
{
if (matrikelnummern[i] == txtMatrikelnummer.Text && passwoerter[i] == txtPasswort.Password)
{
loginSchueler(matrikelnummern[i]);
return;
}
}
}
else
{
for (int i = 0; i < lkuerzel.Count; i++)
{
if (lkuerzel[i] == txtMatrikelnummer.Text && lpasswoerter[i] == txtPasswort.Password)
{
loginLehrer(lkuerzel[i]);
return;
}
}
}
MessageBox.Show("Matrikelnummer oder Passwort falsch", "Fehler");
dbConnection.Close();
}
public async Task updateDataAsync(DB_Connection con)
{
activityLogManager = new ActivityLogManager();
DeviceManager = new DeviceManager();
UserManager = new UserManager();
con.Open();
DataTable dt_personInRoom = await con.QuerryAsync("SELECT ID, UserID, DeviceID_Login, Time_Login FROM v_personsInRoom;");
DataTable dt_user = await con.QuerryAsync("SELECT * FROM tbl_User;");
DataTable dt_devices = await con.QuerryAsync("SELECT * FROM tbl_Devices;");
DataTable dt_activityLog = await con.QuerryAsync("SELECT * FROM tbl_ActivityLog WHERE DeviceID_Logout IS NOT NULL;");
con.Close();
personsInRoomCount = dt_personInRoom.Rows.Count;
isEnabled = personsInRoomCount > 0;
// All user
foreach (DataRow item in dt_user.Rows)
{
UserManager.AddUser(new User(
Int32.Parse(item[0].ToString()),
item[1].ToString(),
item[2].ToString(),
item[3].ToString(),
item.Field <DateTime>(4)
));
}
// User in Room
foreach (DataRow item in dt_personInRoom.Rows)
{
UserManager.GetUser(Int32.Parse(item[1].ToString())).IsLoggedIn = true;
}
// Devices
foreach (DataRow item in dt_devices.Rows)
{
DeviceManager.AddDevice(new Device(
Int32.Parse(item[0].ToString()),
item[1].ToString()
));
}
}