private void booksUpdateButton_Click(object sender, EventArgs e)
{
databaseController dbc = new databaseController();
string selectedBook = bookslistBox.SelectedItem.ToString();//exception needs to be handled
MessageBox.Show(selectedBook);
selectedBook = selectedBook.Trim();
string[] BookID = selectedBook.Split('|');
selectedBook = BookID[1].Trim();
int id_b = Convert.ToInt32(BookID[0].Trim());
string title = titleTextBox.Text;
int total_pages = Convert.ToInt32(numOfPages.Value);
int rating = Convert.ToInt32(ratingNumeric.Value);
string publish_date = Convert.ToString(DateTime.Now.Date.ToString("MM/dd/yyyy"));
string summary = Convert.ToString(summaryTextBox.Text);
//getting location id in bookstab
#region location_id
string selectedLocation = locationBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedLocation = selectedLocation.Trim();
string[] LocationID = selectedLocation.Split('|');
selectedLocation = LocationID[1].Trim();
string postalcode = LocationID[2].Trim();
int id_l = Convert.ToInt32(LocationID[0].Trim());
#endregion
//getting publisher id in books tab
#region publisher_id
string selectedPublisher = publishersBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedPublisher = selectedPublisher.Trim();
string[] PublisherID = selectedPublisher.Split('|');
selectedPublisher = PublisherID[1].Trim();
string description = PublisherID[2].Trim();
int id_p = Convert.ToInt32(PublisherID[0].Trim());
selectedPublisher = publishersNameTextBox.Text;
description = publishersDescriptionRichTextBox.Text;
#endregion
//getting genre id
#region genre_id
string selectedGenre = genreBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedGenre = selectedGenre.Trim();
string[] GenreID = selectedGenre.Split('|');
selectedGenre = GenreID[1].Trim();
string description_genre = GenreID[2].Trim();
int id_g = Convert.ToInt32(GenreID[0].Trim());
int id_aa = 0;
#endregion
#region author_id
string selectedAuthor = authorsBooksCombobox.SelectedItem.ToString();//exception needs to be handled
selectedAuthor = selectedAuthor.Trim();
string[] AuthorID = selectedAuthor.Split('|');
selectedAuthor = AuthorID[1].Trim();
string surname = AuthorID[2].Trim();
string middlename = AuthorID[3].Trim();
int id_a = Convert.ToInt32(AuthorID[0].Trim());
#endregion
Book_Authors ba = new Book_Authors(id_b, id_a);
dbc.UpdateBooksAuthors(ba);
Book_Genres bg = new Book_Genres(id_b, id_g);
dbc.UpdateBooksGenres(bg);
Books b = new Books(id_b, title, summary, year, lost, genre_id);
dbc.UpdateBooks(b);
bookslistBox.Items.Clear();
OutputBooks();
}
