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(); }