private void getInformationFromBase()
{
if (connect.connectionToDataBase())
{
OleDbCommand showRecord = new OleDbCommand("SELECT * FROM Komputery", connect.con);
OleDbDataReader data = showRecord.ExecuteReader();
while (data.Read())
{
object office = data["Wersja Office"];
lista.Add(new BaseData()
{
Serial = data["Numer seryjny"].ToString(),
Name = data["Nazwa"].ToString(),
Model = data["Model"].ToString(),
Login = data["Login"].ToString(),
Windows = data["System operacyjny"].ToString(),
Office = changeOfficeVersion(office).ToString(),
RAM = data["RAM"].ToString()
});
DataBaseList.ItemsSource = lista;
}
data.Close();
}
connect.con.Close();
}
private bool testData(string s)
{
bool existInBase = false;
if (connectToBase.connectionToDataBase())
{
OleDbCommand showRecord = new OleDbCommand("SELECT * FROM Komputery", connectToBase.con);
OleDbDataReader data = showRecord.ExecuteReader();
while (data.Read())
{
if (data["Numer seryjny"].ToString() == s)
{
LogField.Foreground = new SolidColorBrush(Colors.YellowGreen);
LogField.Content += "Laptop jest już w bazie! \n";
existInBase = true;
}
else
{
existInBase = false;
}
}
data.Close();
}
connectToBase.con.Close();
return(existInBase);
}
public void OnClickLoginButton(object sender, RoutedEventArgs e)
{
messageLabel.Content = "";
BaseConnect connect = new BaseConnect();
//string pass = passText.Text;
//BaseConnect.pass = passText.Password;
if (connect.connectionToDataBase() == true)
{
BaseView wyswietl_baze = new BaseView();
Content = wyswietl_baze;
messageLabel.Content = "Połączono";
}
else
{
messageLabel.Foreground = new SolidColorBrush(Colors.Red);
messageLabel.Content = "Brak połączenia z bazą lub podane hasło jest nieprawidłowe";
}
}