Esempio n. 1
0
        void ДобавитьКгигуToolStripMenuItemClick(object sender, EventArgs e)
        {
            if (comboBoxTheme.SelectedIndex < 0)
            {
                MessageBox.Show("Выберите соответствующий каталог для добавлении книги.");
                return;
            }

            FormAllBooks form = new FormAllBooks(listBoxBooks.Items);

            if (form.ShowDialog() != DialogResult.OK)
            {
                return;
            }

            try{
                SQLiteConnection db = new SQLiteConnection(@"Data source=db/Library.db; Version=3");
                db.Open();
                SQLiteCommand command = db.CreateCommand();

                foreach (int idbookselect in form.ExtractSelectedId())
                {
                    command.CommandText = @"INSERT INTO Books_Theme (idBook, idTheme) VALUES (@idB, @idT);";
                    command.Parameters.Add("@idT", System.Data.DbType.Int32).Value = themeKeys[comboBoxTheme.SelectedIndex];
                    command.Parameters.Add("@idB", System.Data.DbType.Int32).Value = idbookselect;
                    command.ExecuteNonQuery();
                }
                db.Close();
                LoadTable_BooksTheme(themeKeys[comboBoxTheme.SelectedIndex]);
            }
            catch (Exception ex) {
                MessageBox.Show(ex.Message);
            }
        }
Esempio n. 2
0
        void ВсеКнигиToolStripMenuItemClick(object sender, EventArgs e)
        {
            FormAllBooks form = new FormAllBooks();

            form.buttonCansel.Visible = false;
            form.buttonOk.Visible     = false;
            form.buttonDelete.Visible = true;
            form.buttonRead.Visible   = true;
            form.ShowDialog();
            LoadInCombo();
        }
Esempio n. 3
0
        void ДобавитьКнигиToolStripMenuItemClick(object sender, EventArgs e)
        {
            if (openFileDialog1.ShowDialog() != DialogResult.OK)
            {
                return;
            }

            SQLiteConnection db = new SQLiteConnection("Data Source=db/" + DATABASENAME + "; Version=3");

            db.Open();
            SQLiteCommand command = db.CreateCommand();

            try{
                Directory.CreateDirectory(FOLDERBOOKS);
                foreach (string filename in openFileDialog1.FileNames)
                {
                    try{
                        File.Copy(filename, FOLDERBOOKS + "\\" + Path.GetFileName(filename));
                    }
                    catch {
                        break;
                    }


                    try{
                        command.CommandText = @"INSERT INTO Books (nameBook) VALUES (@name);";
                        command.Parameters.Add("@name", System.Data.DbType.String).Value = System.IO.Path.GetFileName(filename);
                        command.ExecuteNonQuery();
                    }
                    catch {
                        File.Delete(FOLDERBOOKS + "\\" + Path.GetFileName(filename));
                    }
                }
                db.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                db.Close();
            }
            FormAllBooks formall = new FormAllBooks();

            formall.buttonCansel.Visible = false;
            formall.buttonOk.Visible     = false;
            formall.buttonDelete.Visible = true;
            formall.buttonRead.Visible   = true;
            formall.ShowDialog();
            LoadInCombo();
        }