private void findBookButton_Click(object sender, RoutedEventArgs e)
{
var result = db.FindBook(authorTextBox.Text, titleTextBox.Text, yearTextBox.Text);
ListOfBooks ls = new ListOfBooks(db, result);
ls.Show();
}
private void Button_Click1(object sender, RoutedEventArgs e)
{
ListOfBooks Log = new ListOfBooks();
this.Hide();
Log.ShowDialog();
this.Show();
Close();
}
public SearchBooks(ListOfBooks bb)
{
InitializeComponent();
this.books = bb;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (Login.Text.Length > 0) //проверка на ввод логина
{
if (pbPassword.Password.Length > 0) //проверка на ввод пароля
{
MySqlConnection connection = new MySqlConnection("server=enkavzg1.beget.tech;username=enkavzg1_var8;password=7Iw&ppuQ;database=enkavzg1_var8");
using (connection)
{
string lUser = Login.Text;
string pUser = pbPassword.Password;
connection.Open();
DataTable Table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter();
MySqlCommand command = new MySqlCommand(
"SELECT IDRole FROM Users WHERE `Login` = @uL AND `Password` = @uP;",
connection);
command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = lUser;
command.Parameters.Add("@uP", MySqlDbType.VarChar).Value = pUser;
adapter.SelectCommand = command;
adapter.Fill(Table);
if (Table.Rows.Count > 0)
{
object read = command.ExecuteScalar();
if (read.ToString() != "0")
{
if (read.ToString() == "Преподаватель")
{
connection.Close();
connection.Open();
ListOfBooks DOL = new ListOfBooks();
this.Hide();
DOL.ShowDialog();
this.Show();
string comman = $"SELECT Role FROM Users WHERE `Login` = '{Login.Text}' AND `Password` = '{Login.Text}';";
MySqlDataAdapter da = new MySqlDataAdapter(comman, connection);
DataTable dt = new DataTable();
da.Fill(dt);
DOL.TDOL.Content = dt.Rows[0]["Role"].ToString();
connection.Close();
connection.Open();
string comma = $"SELECT Name FROM Users WHERE `Login` = '{Login.Text}' AND `Password` = '{Login.Text}';";
MySqlDataAdapter das = new MySqlDataAdapter(comma, connection);
DataTable dts = new DataTable();
das.Fill(dts);
DOL.TDOL.Content = dt.Rows[0]["Name"].ToString();
//string commands = $"SELECT Photo FROM Users WHERE `Login` = '{Login.Text}' AND `Password` = '{Login.Text}';";
//MySqlDataAdapter daa = new MySqlDataAdapter(commands, connection);
//DataTable dtt = new DataTable();
//daa.Fill(dtt);
//string photo = dtt.Rows[0]["Photo"].ToString();
//BitmapImage bimage = new BitmapImage();
//bimage.BeginInit();
//bimage.UriSource = new Uri(photo, UriKind.Relative);
//bimage.EndInit();
//DOL.Photo.ImageSource = bimage;
Close();
}
else
{
MySqlCommand rolePR = new MySqlCommand(
"SELECT Role FROM Users WHERE `Login` = @uLd AND `Password` = @uPd;",
connection);
rolePR.Parameters.Add("@uLd", MySqlDbType.VarChar).Value = lUser;
rolePR.Parameters.Add("@uPd", MySqlDbType.VarChar).Value = pUser;
//adapter.SelectCommand = rolePR;
//adapter.Fill(Table);
ListOfBooks DOL = new ListOfBooks();
DOL.TDOL.Content = (string)rolePR.ExecuteScalar();
MySqlCommand namePR = new MySqlCommand(
"SELECT Name FROM Users WHERE `Login` = @uLl AND `Password` = @uPp;",
connection);
namePR.Parameters.Add("@uLl", MySqlDbType.VarChar).Value = lUser;
namePR.Parameters.Add("@uPp", MySqlDbType.VarChar).Value = pUser;
//adapter.SelectCommand = rolePR;
//adapter.Fill(Table);
DOL.NDOL.Content = (string)namePR.ExecuteScalar();
this.Hide();
DOL.ShowDialog();
this.Show();
Close();
}
}
}
else
{
MessageBox.Show("Пользователь не найден");
}
//
}
}
else
{
MessageBox.Show("Введите пароль"); //ошибка, если пароль не введен
}
}
else
{
MessageBox.Show("Введите логин"); //ошибка, если логин не введен
}
}
