private void RenameChapterForm_FormClosed(object sender, FormClosedEventArgs e)
{
refFormEditDir.Show();
refFormEditDir.CBoxCh.Text = "";
Array.Clear(refFormEditDir.ThemesList, 0, 49);
refFormEditDir.RefreshChapters();
}
private void EditAddChForm_FormClosed(object sender, FormClosedEventArgs e)
{
refFormEditDir.Show();
refFormEditDir.CBoxTh.Text = "";
refFormEditDir.richTextBox1.Text = "";
refFormEditDir.CBoxTh.Items.Clear();
refFormEditDir.RefreshChapters();
}
private void BYes_Click(object sender, EventArgs e)
{
if (refFormEditDir.CBoxCh.Text != "")
{
string tableDelete = Convert.ToString(refFormEditDir.CBoxCh.SelectedItem).Replace(' ', '_').Replace("'", "UC39UC");
using (SQLiteConnection db = new SQLiteConnection("Data Source = Subjects/" + DBName + ".db; Version = 3"))
{
db.Open();
using (SQLiteCommand cmd = db.CreateCommand())
{
cmd.CommandText = "drop table " + tableDelete;
using (SQLiteDataReader SQReader = cmd.ExecuteReader())
{
for (int i = 0; SQReader.Read(); i++)
{
refFormEditDir.ChaptersList[i] += SQReader["name"];
refFormEditDir.CBoxCh.Items.Add(refFormEditDir.ChaptersList[i]);
}
SQReader.Close();
}
}
db.Close();
}
refFormEditDir.CBoxCh.Items.Clear();
refFormEditDir.CBoxCh.SelectedText = "";
refFormEditDir.CBoxCh.Text = "";
refFormEditDir.CBoxTh.Items.Clear();
refFormEditDir.CBoxTh.Text = "";
refFormEditDir.richTextBox1.Text = "";
refFormEditDir.RefreshChapters();
MessageBox.Show("Глава видалена!");
}
else
{
MessageBox.Show("Виберiть главу!");
}
this.Close();
}