private void booksDeleteButton_Click(object sender, EventArgs e) { if (bookslistBox.SelectedItem == null) { MessageBox.Show("Nobena knjiga ni izbrana."); } else { databaseController dbc = new databaseController(); string selectedBook = bookslistBox.SelectedItem.ToString();//exception needs to be handled selectedBook = selectedBook.Trim(); string[] BookID = selectedBook.Split('|'); int id_b = Convert.ToInt32(BookID[0].Trim()); selectedBook = BookID[1].Trim();//title string author_name = BookID[2].Trim(); string author_surname = BookID[3].Trim(); int lost = Convert.ToInt32(BookID[4].Trim()); string year = BookID[5].Trim(); string location_name = BookID[6].Trim(); string publisher_name = BookID[7].Trim(); string genre_genretype = BookID[8].Trim(); int id_g = 0; Authors aid = new Authors(0, author_name, author_surname); dbc.idAuthors(aid); int author_id = 0; foreach (int k in dbc.idAuthors(aid)) { author_id = k; } Locations lid = new Locations(0, location_name, ""); dbc.idLocations(lid); int location_id = 0; foreach (int k in dbc.idLocations(lid)) { location_id = k; } Publishers pid = new Publishers(0, publisher_name); dbc.idPublishers(pid); int publisher_id = 0; foreach (int k in dbc.idPublishers(pid)) { publisher_id = k; } Genres gid = new Genres(0, genre_genretype); dbc.idGenres(gid); int genre_id = 0; foreach (int k in dbc.idGenres(gid)) { genre_id = k; } Books b = new Books(id_b, selectedBook, "", year, lost, genre_id, publisher_id, location_id); #region author_id Book_Authors id = new Book_Authors(0, id_b); dbc.ReadAuthorsID(id); int id_a = 0; foreach (int k in dbc.ReadAuthorsID(id)) { id_a = k; } /*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(); * int id_a = Convert.ToInt32(AuthorID[0].Trim());*/ #endregion Book_Authors ba = new Book_Authors(author_id, id_b); //MessageBox.Show("author"+Convert.ToString(author_id), "book" + Convert.ToString(id_b)); dbc.DeleteBooksAuthors(ba); dbc.DeleteBooks(b); bookslistBox.Items.Clear(); OutputBooks(); userUnLendedBookslistBox.Items.Clear(); userLendedBookslistBox.Items.Clear(); //OutputBooksOnRents_Lended(); OutputBooksOnRents_UnLended(); } }
private void rentABookButton_Click(object sender, EventArgs e) { if (userShowcomboBox.SelectedItem == null) { MessageBox.Show("Izberite člana."); } else { databaseController dbc = new databaseController(); string selectedUser = userShowcomboBox.SelectedItem.ToString();//exception needs to be handled selectedUser = selectedUser.Trim(); string[] UserID = selectedUser.Split('|'); int id_u = Convert.ToInt32(UserID[0].Trim()); string name = UserID[1].Trim();//title string surname = UserID[2].Trim(); string tel = UserID[3].Trim(); string address = UserID[3].Trim(); string location_name = UserID[3].Trim(); string location_postalcode = UserID[3].Trim(); Locations lid = new Locations(0, location_name, ""); dbc.idLocations(lid); int location_id = 0; foreach (int k in dbc.idLocations(lid)) { location_id = k; } Users uid = new Users(0, name, surname, "", "", "", "", 0); dbc.idUsers(uid); int user_id = 0; foreach (int k in dbc.idUsers(uid)) { user_id = k; } if (userUnLendedBookslistBox.SelectedItem == null) { MessageBox.Show("Izberite knjigo."); } else { string selectedBook = userUnLendedBookslistBox.SelectedItem.ToString();//exception needs to be handled selectedBook = selectedBook.Trim(); string[] BookID = selectedBook.Split('|'); int id_b = Convert.ToInt32(BookID[0].Trim()); selectedBook = BookID[1].Trim();//title string author_name = BookID[2].Trim(); string author_surname = BookID[3].Trim(); int lost = Convert.ToInt32(BookID[4].Trim()); string year = BookID[5].Trim(); string location_name_book = BookID[6].Trim(); string publisher_name = BookID[7].Trim(); string genre_genretype = BookID[8].Trim(); int id_g = 0; Authors aid = new Authors(0, author_name, author_surname); dbc.idAuthors(aid); int author_id = 0; foreach (int k in dbc.idAuthors(aid)) { author_id = k; } Locations lid_book = new Locations(0, location_name, ""); dbc.idLocations(lid); int location_id_book = 0; foreach (int k in dbc.idLocations(lid)) { location_id = k; } Publishers pid = new Publishers(0, publisher_name); dbc.idPublishers(pid); int publisher_id = 0; foreach (int k in dbc.idPublishers(pid)) { publisher_id = k; } Genres gid = new Genres(0, genre_genretype); dbc.idGenres(gid); int genre_id = 0; foreach (int k in dbc.idGenres(gid)) { genre_id = k; } Rents rid = new Rents(0, 0, "", id_b, user_id); dbc.idRents(rid); int rent_id = 0; foreach (int k in dbc.idRents(rid)) { rent_id = k; } string rent_date = Convert.ToString(DateTime.Now); int rent_state = 1; Rents rentss = new Rents(rent_id, rent_state, rent_date, id_b, id_u); dbc.UpdateRentsLend(rentss); userUnLendedBookslistBox.Items.Clear(); OutputBooksOnRents_UnLended(); } } }
private void booksUpdateButton_Click(object sender, EventArgs e) { if (titleTextBox.Text == "" || yearTextBox.Text == "" || authorsBooksCombobox.SelectedItem == null || publishersBooksCombobox.SelectedItem == null || genreBooksCombobox.SelectedItem == null || locationBooksCombobox.SelectedItem == null) { MessageBox.Show("Preverite vnos. Eno izmed polij ni napolnjeno."); } else { databaseController dbc = new databaseController(); string selectedBook = bookslistBox.SelectedItem.ToString();//exception needs to be handled selectedBook = selectedBook.Trim(); string[] BookID = selectedBook.Split('|'); int id_b = Convert.ToInt32(BookID[0].Trim()); selectedBook = BookID[1].Trim();//title string author_name = BookID[2].Trim(); string author_surname = BookID[3].Trim(); int lost = Convert.ToInt32(BookID[4].Trim()); string year = BookID[5].Trim(); string location_name = BookID[6].Trim(); string publisher_name = BookID[7].Trim(); string genre_genretype = BookID[8].Trim(); int id_g = 0; string summary = summaryTextBox.Text; #region genre_id string selectedGenre1 = genreBooksCombobox.SelectedItem.ToString();//exception needs to be handled selectedGenre1 = selectedGenre1.Trim(); string[] GenreID1 = selectedGenre1.Split('|'); selectedGenre1 = GenreID1[1].Trim(); int genre_id = Convert.ToInt32(GenreID1[0].Trim()); #endregion #region publisher_id string selectedPublisher = publishersBooksCombobox.SelectedItem.ToString();//exception needs to be handled selectedPublisher = selectedPublisher.Trim(); string[] PublisherID = selectedPublisher.Split('|'); selectedPublisher = PublisherID[1].Trim(); int publisher_id = Convert.ToInt32(PublisherID[0].Trim()); #endregion #region location_id string selectedLocation = locationBooksCombobox.SelectedItem.ToString();//exception needs to be handled selectedLocation = selectedLocation.Trim(); string[] LocationID = selectedLocation.Split('|'); int location_id = Convert.ToInt32(LocationID[0].Trim()); #endregion #region author_id string selectedAuthor = authorsBooksCombobox.SelectedItem.ToString();//exception needs to be handled selectedAuthor = selectedAuthor.Trim(); string[] AuthorID = selectedAuthor.Split('|'); int author_id_waiting = Convert.ToInt32(AuthorID[0].Trim());//nov id #endregion Authors aid = new Authors(0, author_name, author_surname);//tastar id dbc.idAuthors(aid); int author_id = 0; foreach (int k in dbc.idAuthors(aid)) { author_id = k; } Book_Authors baid = new Book_Authors(author_id, id_b);//poiscem id v book authors z pomocjo ttih idejev dbc.idBookAuthors(baid); int book_authors_id = 0; foreach (int k in dbc.idBookAuthors(baid)) { book_authors_id = k; } Books b = new Books(id_b, selectedBook, summary, year, lost, genre_id, publisher_id, location_id); Book_Authors ba = new Book_Authors(author_id, id_b, book_authors_id, author_id_waiting); dbc.UpdateBooksAuthors(ba); dbc.UpdateBooks(b); bookslistBox.Items.Clear(); OutputBooks(); userUnLendedBookslistBox.Items.Clear(); userLendedBookslistBox.Items.Clear(); //OutputBooksOnRents_Lended(); OutputBooksOnRents_UnLended(); } }