private void AddButton_Click(object sender, EventArgs e)
{
//MessageBox.Show(CategoryMenu.Text);
if (checkInput())
{
// create a new BudgetItem
BudgetItem newItem = new BudgetItem
(Convert.ToDateTime(dateTimePicker1.Text), CategoryMenu.Text, DescriptionTextBox.Text, float.Parse(AmountTextBox.Text));
// add item to DB
int ukey = Properties.Settings.Default.userkey;
string command = "insert into nts_budget_items(`userkey`, `date`, `name`, `amount`, `catkey`) values(" + ukey + ", " + dateTimePicker1.Value.ToString("yyyyMMdd") + ",\"" + DescriptionTextBox.Text + "\"," + AmountTextBox.Text + ", " + CategoryMenu.SelectedValue + ");";
sqlConn.Open();
SQLiteDataReader reader;
sqlDoReport.CommandText = command;
reader = sqlDoReport.ExecuteReader();
sqlConn.Close();
// alert user that item was successfully added to DB - this needs an if statement!
if (reader.RecordsAffected > 0)
{
SuccessTextBox.Text = "Item successfully added to your budget!";
}
else
{
SuccessTextBox.Text = "There has been an error in adding your item.";
}
// reset window
dateTimePicker1.ResetText();
CategoryMenu.ResetText();
DescriptionTextBox.ResetText();
AmountTextBox.ResetText();
CategoryMenu.ClearSelected();
}
}
/// <summary>
/// Clears the text boxes for the next debt.
/// </summary>
private void ResetForm()
{
NameTextBox.ResetText();
AmountTextBox.ResetText();
MinimumPaymentTextBox.ResetText();
}
