private async void btnUpdate_Click(object sender, EventArgs e)
{
int selectedRowIndex = dgvSpending.CurrentRow.Index;
MessageBox.Show("id = " + dgvSpending[0, selectedRowIndex].Value.ToString());
if (selectedRowIndex != dgvSpending.Rows.Count - 1)
{
Financier.CurrentSpending = Financier.FinfSpending(int.Parse(dgvSpending[0, selectedRowIndex].Value.ToString()));
FAddChange fAddChange = new FAddChange();
fAddChange.ShowDialog();
if (fAddChange.DialogResult == DialogResult.OK)
{
FillSpendingTable();
try
{
SqlCommand command = new SqlCommand("UPDATE [Spending] SET [Name] =@Name, [Quantity] =@Quantity, [Summ]=@Summ,[Category] = @Category, [Date] =@date WHERE id = @id", sqlConnection);
command.Parameters.AddWithValue("@id", Financier.CurrentSpending.ID);
command.Parameters.AddWithValue("@Name", Financier.CurrentSpending.Value);
command.Parameters.AddWithValue("@Date", Financier.CurrentSpending.Date);
command.Parameters.AddWithValue("@Quantity", Financier.CurrentSpending.Quantity);
command.Parameters.AddWithValue("@Summ", Financier.CurrentSpending.Summ);
command.Parameters.AddWithValue("@Category", Financier.CurrentSpending.Category);
await command.ExecuteNonQueryAsync();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
}
else
{
MessageBox.Show("Нет выбранных строк!");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
int selectedRowIndex = dgvSpending.CurrentRow.Index;
if (selectedRowIndex != dgvSpending.Rows.Count - 1)
{
Financier.DeleteSpending(int.Parse(dgvSpending[0, selectedRowIndex].Value.ToString()));
try
{
SqlCommand command = new SqlCommand("DELETE FROM spending WHERE id = @id", sqlConnection);
command.Parameters.AddWithValue("@id", dgvSpending[0, selectedRowIndex].Value);
command.ExecuteNonQuery();
FillSpendingTable();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
else
{
MessageBox.Show("Нет выбранных строк!");
}
}
