private void BYes_Click(object sender, EventArgs e)
{
if (isTheme)
{
if (editDir.CBoxTh.Text != "" && editDir.richTextBox1.Text != "" && editDir.CBoxCh.Text != "")
{
tableName = editDir.CBoxCh.Text.Replace(' ', '_').Replace("'", "UC39UC");
DBName = DBName.Replace(' ', '_');
using (SQLiteConnection db = new SQLiteConnection("Data Source = Subjects/" + DBName + ".db; Version = 3"))
{
db.Open();
using (SQLiteCommand cmd = db.CreateCommand())
{
cmd.CommandText = "delete from " + tableName + " where " + tableName + "Th" + " = '" + editDir.CBoxTh.Text + "' and " + tableName + "Str" + " = '" + editDir.richTextBox1.Text.Replace("'", "UC39UC") + "';";
cmd.ExecuteNonQuery();
}
db.Close();
}
MessageBox.Show("Тема успiшно видалена!");
}
else
{
MessageBox.Show("Данi введенi неправильно!");
}
editDir.CBoxTh.Items.Clear();
Array.Clear(editDir.ThemesList, 0, 49);
editDir.CBoxTh.Text = "";
editDir.richTextBox1.Text = "";
editDir.RefreshThemes();
this.Close();
}
else
{
if (editDir.CBoxCh.Text != "" && editDir.CBoxImgName.Text != "" && editDir.pictureBox1.Image != null)
{
tableName = editDir.CBoxCh.Text.Replace(' ', '_').Replace("'", "UC39UC");
DBName = DBName.Replace(' ', '_');
byte[] photo = editDir.imageToByteArray(editDir.pictureBox1.Image);
using (SQLiteConnection db = new SQLiteConnection("Data Source = Subjects/" + DBName + ".db; Version = 3"))
{
db.Open();
using (SQLiteCommand cmd = db.CreateCommand())
{
cmd.CommandText = "delete from " + tableName + " where " + tableName + "ImgName" + " = '" + editDir.CBoxImgName.Text + "' and " + tableName + "ImgObj" + " = @photo;";
cmd.Parameters.Add("@photo", DbType.Binary, 20).Value = photo;
cmd.ExecuteNonQuery();
}
db.Close();
}
MessageBox.Show("Тема успiшно видалена!");
}
else
{
MessageBox.Show("Данi введенi неправильно!");
}
editDir.CBoxImgName.Items.Clear();
Array.Clear(editDir.ImagesList, 0, 99);
editDir.CBoxImgName.Text = "";
editDir.pictureBox1.Text = "";
editDir.pictureBox1.Image = null;
editDir.RefreshImages();
this.Close();
}
}
private void BYes_Click(object sender, EventArgs e)
{
if (refFormEditDir.RBTheme.Checked == true)
{
if (refFormEditDir.CBoxTh.Text != "" && refFormEditDir.richTextBox1.Text != "" && refFormEditDir.CBoxCh.Text != "")
{
DBName = DBName.Replace(' ', '_');
chapterName = refFormEditDir.CBoxCh.Text.Replace(' ', '_');
chapterName = chapterName.Replace("'", "UC39UC");
themeText = refFormEditDir.richTextBox1.Text.Replace("'", "UC39UC");
themeName = refFormEditDir.CBoxTh.Text.Replace("'", "UC39UC");
using (SQLiteConnection db = new SQLiteConnection("Data Source = Subjects/" + DBName + ".db; Version = 3"))
{
db.Open();
using (SQLiteCommand cmd = db.CreateCommand())
{
cmd.CommandText = "delete from " + chapterName + " where " + chapterName + "Th" + " = '" + themeName + "' or " + chapterName + "Str" + " = '" + themeText + "';";
cmd.ExecuteNonQuery();
cmd.CommandText = "insert into " + chapterName + "(" + chapterName + "Th, " + chapterName + "Str) values('" + themeName + "', '" + themeText + "')";
cmd.ExecuteNonQuery();
}
db.Close();
refFormEditDir.CBoxTh.Text = "";
refFormEditDir.richTextBox1.Text = "";
refFormEditDir.CBoxTh.Items.Clear();
Array.Clear(refFormEditDir.ThemesList, 0, 49);
refFormEditDir.RefreshThemes();
MessageBox.Show("Тема успiшно створена!");
}
}
else
{
MessageBox.Show("Даннi введенi неправильно!");
}
}
else
{
// !!!ДОРАБОТАТЬ!!!
if (refFormEditDir.CBoxCh.Text != "" && refFormEditDir.CBoxImgName.Text != "" && refFormEditDir.pictureBox1.Image != null)
{
DBName = DBName.Replace(' ', '_');
chapterName = refFormEditDir.CBoxCh.Text.Replace(' ', '_');
chapterName = chapterName.Replace("'", "UC39UC");
NewImage = Convert.ToString(refFormEditDir.CBoxImgName.Text).Replace(' ', '_').Replace("'", "UC39UC");
//themeName = refFormEditDir.CBoxImgName.Text.Replace("'", "UC39UC");
byte[] photo = imageToByteArray(refFormEditDir.currentImage);
using (SQLiteConnection db = new SQLiteConnection("Data Source = Subjects/" + DBName + ".db; Version = 3"))
{
db.Open();
using (SQLiteCommand cmd = db.CreateCommand())
{
cmd.CommandText = "delete from " + chapterName + " where " + chapterName + "ImgName" + " = '" + NewImage + "' or " + chapterName + "ImgObj" + " = '" + photo + "';";
cmd.ExecuteNonQuery();
cmd.CommandText = "insert into " + chapterName + "(" + chapterName + "ImgName, " + chapterName + "ImgObj) values('" + NewImage + "', @photo)";
cmd.Parameters.Add("@photo", DbType.Binary, 20).Value = photo;
cmd.ExecuteNonQuery();
}
db.Close();
refFormEditDir.CBoxImgName.Text = "";
refFormEditDir.pictureBox1.Image = null;
refFormEditDir.CBoxImgName.Items.Clear();
Array.Clear(refFormEditDir.ImagesList, 0, 99);
refFormEditDir.RefreshImages();
MessageBox.Show("Тема успiшно створена!");
}
}
else
{
MessageBox.Show("Даннi введенi неправильно!");
}
}
this.Close();
}
