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;
}