예제 #1
0
        private void authorsDeleteButton_Click(object sender, EventArgs e)
        {
            databaseController dbc            = new databaseController();
            string             selectedAuthor = authorsListbox.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());

            selectedAuthor = authorsNameTextBox.Text;
            surname        = authorsSurnameTextBox.Text;
            Authors aut = new Authors(id_a, selectedAuthor, surname);

            dbc.DeleteAuthors(aut);
            authorsListbox.Items.Clear();
            OutputAuthors();
        }
예제 #2
0
        public List <int> idAuthors(Authors ToReadIDs)
        {
            List <int> listOfIDs = new List <int>();

            using (SQLiteConnection con = new SQLiteConnection("data source=Knjiznica_projektt.db"))
            {
                con.Open();
                string           query  = "SELECT id_a FROM authors WHERE name='" + ToReadIDs.name + "' AND surname='" + ToReadIDs.surname + "'";
                SQLiteCommand    com    = new SQLiteCommand(query, con);
                SQLiteDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    int id = reader.GetInt32(0);
                    listOfIDs.Add(id);
                }
                com.Dispose();
                con.Close();
                return(listOfIDs);
            }
        }
예제 #3
0
        private void authorsAddButton_Click(object sender, EventArgs e)
        {
            databaseController dbc = new databaseController();
            int    id_a            = 0;
            string name            = authorsNameTextBox.Text;
            string surname         = authorsSurnameTextBox.Text;
            string middlename      = authorsMiddlenameTextBox.Text;

            if (authorsMiddlenameTextBox.Text == "")
            {
                Authors auth = new Authors(id_a, name, surname);
                dbc.SaveAuthors(auth);
                authorsListbox.Items.Clear();
                OutputAuthors();
            }
            else
            {
                Authors aut = new Authors(id_a, name, surname);
                dbc.SaveAuthors(aut);
                authorsListbox.Items.Clear();
                OutputAuthors();
            }
        }
예제 #4
0
        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();
                }
            }
        }
예제 #5
0
        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();
            }
        }
예제 #6
0
        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();
            }
        }