private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
SQLBook SQLBook = new SQLBook();
SQLBook.DeleteUserBook(Convert.ToInt32(IdLable.Content));
if (SQLBook.RightsCheck(Convert.ToString(UserLable.Content)) == "admin")
{
NavigationService.Navigate(new ReportPage(Convert.ToString(UserLable.Content)));
}
else
{
NavigationService.Navigate(new MyBookList(Convert.ToString(UserLable.Content)));
}
}
public BookPage(int id)
{
InitializeComponent();
SQLBook SQLBook = new SQLBook();
BookForPage bookForPage = SQLBook.GetBookForPage(id);
TitleTextBox.Text = bookForPage.Title;
BookImage.Source = new BitmapImage(new Uri(bookForPage.ImagePath));
AuthorBlock.Text = bookForPage.Authors;
GenreLable.Content += bookForPage.Genre;
TredeBlock.Text = bookForPage.Trade;
TredeBox.Text = bookForPage.Trade;
DescriptionBlock.Text = bookForPage.Description;
DescriptionBox.Text = bookForPage.Description;
EmailLable.Content = bookForPage.Email;
}
private void Button_Click(object sender, RoutedEventArgs e)
{
SQLBook SQLBook = new SQLBook();
if (!string.IsNullOrEmpty(ISBNTextBox.Text) && !string.IsNullOrEmpty(DescriptionTextBox.Text) && !string.IsNullOrEmpty(TradeTextBox.Text))
{
if (SQLBook.ISBNBook(Convert.ToString(ISBNTextBox.Text)) != "Книга не найдена")
{
SQLBook.AddUserBook(Convert.ToString(UserLable.Content), Convert.ToString(ISBNTextBox.Text), Convert.ToString(DescriptionTextBox.Text), Convert.ToString(TradeTextBox.Text), Convert.ToString(ImageLable.Content));
NavigationService.Navigate(new MyBookList(Convert.ToString(UserLable.Content)));
}
else
{
ErrorLable.Content = "Книга не найдена";
}
}
else
{
ErrorLable.Content = "Все поля должный быть заполнены";
}
}
private void Savebutton_Click(object sender, RoutedEventArgs e)
{
SQLBook SQLBook = new SQLBook();
if (!string.IsNullOrEmpty(DescriptionBox.Text) && !string.IsNullOrEmpty(TredeBox.Text))
{
SQLBook.BookUpdate(Convert.ToString(BookImage.Source), Convert.ToString(DescriptionBox.Text), Convert.ToString(TredeBox.Text), Convert.ToInt32(IdLable.Content), Convert.ToString(UserLable.Content));
if (SQLBook.RightsCheck(Convert.ToString(UserLable.Content)) == "admin")
{
NavigationService.Navigate(new ReportPage(Convert.ToString(UserLable.Content)));
}
else
{
NavigationService.Navigate(new MyBookList(Convert.ToString(UserLable.Content)));
}
}
else
{
ErrorLable.Visibility = Visibility.Visible;
}
}
public BookPage(int id, string user)
{
InitializeComponent();
SQLBook SQLBook = new SQLBook();
BookForPage bookForPage = SQLBook.GetBookForPage(id);
TitleTextBox.Text = bookForPage.Title;
BookImage.Source = new BitmapImage(new Uri(bookForPage.ImagePath));
AuthorBlock.Text = bookForPage.Authors;
GenreLable.Content += bookForPage.Genre;
TredeBlock.Text = bookForPage.Trade;
TredeBox.Text = bookForPage.Trade;
DescriptionBlock.Text = bookForPage.Description;
DescriptionBox.Text = bookForPage.Description;
EmailLable.Content = bookForPage.Email;
UserLable.Content = user;
IdLable.Content = id;
TredeBox.Visibility = Visibility.Visible;
DescriptionBox.Visibility = Visibility.Visible;
ButtonStack.Visibility = Visibility.Visible;
}
private void TextBox_TextChanged(object sender, TextChangedEventArgs e)
{
SQLBook SQLBook = new SQLBook();
ErrorLable.Content = SQLBook.ISBNBook(Convert.ToString(ISBNTextBox.Text));
}
