private void buttonDeleteByDateIncomes_Click(object sender, EventArgs e) { if (incomes.Count != 0) { incomes = IncomesModel.SelectAll(); string query = "DELETE FROM Incomes WHERE DateIncomes BETWEEN @before AND @after"; var before = new DateTime(dateTimePickerBefore.Value.Year, dateTimePickerBefore.Value.Month, dateTimePickerBefore.Value.Day, 0, 0, 0); var after = new DateTime(dateTimePickerAfter.Value.Year, dateTimePickerAfter.Value.Month, dateTimePickerAfter.Value.Day, 23, 59, 0); try { connection.Open(); command = new SQLiteCommand(query, connection); command.Parameters.AddWithValue("before", before.ToString("dd-MM-yyyy HH:mm")); command.Parameters.AddWithValue("after", after.ToString("dd-MM-yyyy HH:mm")); command.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { connection.Close(); } ShowIncomes(); } else { MessageBox.Show("Таблица пустая"); } }
private void ShowIncomes() { incomes = IncomesModel.SelectAll(); dataGridViewIncomes.DataSource = incomes; }