private void Bibliotekar()
{
SqlConnection SqlConn = Konekcija.KreirajKonekciju();
try
{
SqlConn.Open();
SqlCommand cmd = new SqlCommand("SELECT BibliotekarId, Ime,Prezime FROM Bibliotekar", SqlConn);
SqlDataReader read = cmd.ExecuteReader();
while (read.Read())
{
Bibliotekar b = new Bibliotekar();
int BibliotekarId = read.GetInt32(0);
string Ime = read.GetString(1);
string Prezime = read.GetString(2);
b.BibliotekarId = BibliotekarId;
b.Ime = Ime;
b.Prezime = Prezime;
bibliotekar.Add(b);
}
listBoxListaBibliotekara.ItemsSource = null;
listBoxListaBibliotekara.ItemsSource = bibliotekar;
}
catch (Exception)
{
throw;
}
}
private void buttonLogin_Click(object sender, RoutedEventArgs e)
{
SqlConnection SqlConn = Konekcija.KreirajKonekciju();
try
{
SqlConn.Open();
SqlCommand cmd = new SqlCommand("SELECT Ime, Sifra FROM Admin", SqlConn);
SqlDataReader read = cmd.ExecuteReader();
while (read.Read())
{
Bibliotekar p = new Bibliotekar();
string Ime = read.GetString(0);
string Prezime = read.GetString(1);
p.Ime = Ime;
p.Prezime = Prezime;
bibliotekar.Add(p);
if (textBox.Text.Trim().Contains(p.Ime) && passwordBox.Password.Contains(p.Prezime))
{
Window1 w1 = new Window1();
Close();
w1.ShowDialog();
}
else
{
MessageBox.Show("Pogresni podaci!");
}
}
}
catch (Exception)
{
throw;
}
finally
{
SqlConn.Close();
}
}
