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