public void StaffLogin(string staffID, string password)
{
Employee_login loginScreen = new Employee_login();
try
{
OleDbConnection dataConnection = new OleDbConnection();
DataTable dt = new DataTable();
dataConnection.ConnectionString = dataConnection.ConnectionString = (@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\..\..\database\\database.accdb");
string sql = "select StaffID from MedicalStaff where StaffID = " + staffID + "";
OleDbDataAdapter adapt = new OleDbDataAdapter(sql, dataConnection);
adapt.Fill(dt);
string Name = dt.Rows[0][0].ToString();
if (staffID == Name && password == "12345")
{
OleDbCommand Add = new OleDbCommand();
Add.CommandText = "INSERT INTO Registration (RegisteredOn, StaffID) VALUES (@Timestamp, @StaffID)";
Add.Parameters.Add("@Timestamp", OleDbType.Date).Value = DateTime.Now;
Add.Parameters.Add("@StaffID", OleDbType.Integer).Value = staffID;
Add.Connection = dataConnection;
Add.Connection.Open();
Add.ExecuteNonQuery();
CentralMonitoringStation CentralStation = new CentralMonitoringStation();
CentralStation.Show();
}
}
catch
{
MessageBox.Show("Wrong StaffID/Password!", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public void validateStaff()
{
OleDbConnection dataConnection = new OleDbConnection();
DataTable dt = new DataTable();
dataConnection.ConnectionString = dataConnection.ConnectionString = (@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\..\..\database\\database.accdb");
string sql = "SELECT LAST(StaffID)FROM Registration";
OleDbDataAdapter adapt = new OleDbDataAdapter(sql, dataConnection);
adapt.Fill(dt);
string StaffID = dt.Rows[0][0].ToString();
if (StaffID == "")
{
MessageBoxResult linkoLogIn = MessageBox.Show("No staff on call. Please log in to proceed!", "Error", MessageBoxButton.OKCancel, MessageBoxImage.Error);
if (linkoLogIn == MessageBoxResult.OK)
{
Employee_login loginScreen = new Employee_login();
loginScreen.Show();
}
}
else
{
BedsideMonitoringStation mainInterface = new BedsideMonitoringStation();
mainInterface.Show();
}
}
private void btnCentralStation_Click(object sender, RoutedEventArgs e)
{
Employee_login loginScreen = new Employee_login();
loginScreen.Show();
}