private void btnW_Click(object sender, RoutedEventArgs e)
{
if (isValid())
{
// Instance of transactionmod
tr = new TransactionMod();
string t = "w";
DateTime d = dpDate.Date.DateTime;
double a = Convert.ToDouble(tbxAmmount.Text);
int aid = myApp._accountId;
// setting up fields
tr.type = t;
tr.date = d;
tr.ammount = a;
tr.accid = aid;
if (cbCategory.SelectedIndex != -1)
{
var item = (Categories)cbCategory.SelectedItem;
tr.categoryid = item.id;
}
if (tbxDescription.Text != null)
{
tr.description = tbxDescription.Text;
}
if (dc.addNewTransaction(tr) == 1)
{
dpDate.Date = DateTime.Now;
tbxAmmount.Text = "";
cbCategory.SelectedIndex = -1;
tbxDescription.Text = "";
Account acc = dc.getAccount(myApp._accountId);
double current = acc.current;
double newCurrent = current - a;
acc.current = newCurrent;
if (dc.updateAccount(acc) == 1)
{
TextBox tb = new TextBox();
tb.Text = "New transaction was saved.";
spMsg.Children.Add(tb);
}
}
}
}
public int addNewTransaction(TransactionMod tr)
{
int rows = conn.Insert(tr);
return(rows);
}
