public void saveButton_Click(object sender, EventArgs e) { if (bEName.Text == "") { MessageBox.Show("Введите название"); } else if (bENote.Text == "") { MessageBox.Show("Введите запись"); } else if (mainForm.connectionOpened == false) { MessageBox.Show("Выберите базу"); } else { date = dateTimePicker.Value.Day.ToString() + "-" + dateTimePicker.Value.Month.ToString() + "-" + dateTimePicker.Value.Year.ToString(); time = dateTimePicker.Value.Hour.ToString() + ":" + dateTimePicker.Value.Minute.ToString(); if (reminderActivator.Checked == true) { checkStatus = 1; } else { checkStatus = 0; } string sql = "INSERT INTO notes (id, name, note, notification, date, time) VALUES (NULL, " + bEName.Text + ", " + bENote.Text + ", '" + checkStatus + "', '" + date + "', '" + time + "')"; SQLiteCommand command = new SQLiteCommand(sql, mainForm.m_dbConnection); command.ExecuteNonQuery(); mainForm.refresh(); MessageBox.Show("Запись создана"); Close(); } }
public void create_Click(object sender, EventArgs e) { if (regex.IsMatch(baseName.Text, 0) == true) { MessageBox.Show("Название должно быть без спец-символов"); } else if (System.IO.File.Exists("bases\\" + baseName.Text + ".db")) { MessageBox.Show("База с таким названием уже существует"); } else if (baseName.Text == "") { MessageBox.Show("Введите название"); } else { filename = "bases\\" + baseName.Text + ".db"; m_dbConnection = new SQLiteConnection("Data Source=" + filename + "; Version=3;"); m_dbConnection.Open(); string sql3 = "CREATE TABLE notes (id integer primary key, name varchar(30), note varchar(1000), notification int, date varchar(10), time varchar(5))"; SQLiteCommand command3 = new SQLiteCommand(sql3, m_dbConnection); command3.ExecuteNonQuery(); string sql4 = "INSERT INTO notes (id, name, note, notification, date, time) VALUES (NULL, 'Имя', 'Пример заметки', 0, '01-01-1970', '00:00')"; SQLiteCommand command4 = new SQLiteCommand(sql4, m_dbConnection); command4.ExecuteNonQuery(); DialogResult dialogResult = MessageBox.Show("Выбрать эту базу?", "", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { if (mainForm.connectionOpened == true) { mainForm.m_dbConnection.Close(); System.Data.SQLite.SQLiteConnection.ClearAllPools(); GC.Collect(); } mainForm.m_dbConnection = new SQLiteConnection("Data Source=" + filename + "; Version=3;"); mainForm.m_dbConnection.Open(); mainForm.refresh(); ConfigurationManager.AppSettings["lastBase"] = filename; mainForm.connectionOpened = true; } Close(); } }